• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

hit a wall with postgresql deb

smp

Diamond Member
apt-get install postgresql

I don't get it.
I tried to force it, looked for stuff in logs (don't even know where to look else /var/log/ ) .. um, not sure how to figure out what
dpkg: error processing postgresql (--install):
subprocess post-installation script returned error exit status 1
that is.
How do I go about figuring this out?
 
looks like it's a broken package.



Some things to try:

apt-get -f install

This will "fix" the installer.

apt-get clean

Also try to remove the package...

apt-get --purge remove postgresql

--purge will remove all the configuration files and extra stuff. normal uninstalls leave the configs behind.

Also be sure to run apt-get update, and apt-get upgrade to get the latest versions of stuff.

Also try to do all that stuff thru the dselect frontend. For some reason it seems to de a better job then apt-get commands by themselves.
 
Originally posted by: drag

Also try to remove the package...

apt-get --purge remove postgresql

--purge will remove all the configuration files and extra stuff. normal uninstalls leave the configs behind.

Backup your postgres database if you have one. I don't know if you *need* to, but it looks like it might be a good idea 😉

 
Originally posted by: n0cmonkey
You are root when you run this right?

ummm

disobey:/var# whoami
root
disobey:/var#

Yup! 🙂
(I know, I know .. it's happened before)


And yeah I tried apt-get clean, apt-get remove (but not purge, that's one I was missing) and --force and stuff, but to no avail. Autoclean, not sure what's the diff there with clean .. anyways

.. I tried again.
And same deal.
Maybe downloading the .deb and doing it that way .....
I am afraid of dselect.


edit: no go the dpkg route with a .deb from security.debian.org
dselect eh?
I think I remember breaking my box last time I used that


:Q
 
Another somewhat related question ..

if I have a database I was using in postgresql and I dumped it, can I import it into mysql?
 
dselect is easy. I screwed it up once and eventually got it fixed. Haven't done it since.

hah... something about the "Haven't done it since" sort of throws off the "dselect is easy" bit.
🙂
 
Isn't there output before that? That message just says the install failed, but the install usually fails because a command exits with an error code. You should probably see an error message from whatever command failed.

edit: didn't notice your link.

/usr/lib/postgresql/bin/initdb: /dev/null: Permission denied

What's the permissions on /dev/null?
 
Woah, that's weird. /dev/null should be readable and writeable by everyone. Try "chmod ga+w /dev/null" as root.

You are running dpkg as root but I'm guessing that it is dropping to the postgres user to do whatever it's doing, and the postgres user can't write to /dev/null.
 
I didn't know that about /dev/null/ .. trying.....


disobey:/dev# ls -al | grep null
-rwxrw-rw- 1 root root 0 Feb 10 04:02 null




IT WORKED!!!

Sweet, but now I don't understand why /dev/null had the wrong permissions.
I <3 /dev/null .... it's the existential cornerstone of linux 🙂
 
🙂 🙂 🙂

I don't know why it had the wrong permissions either, can't say I've seen that before... (but hey, at least it was a simple problem)
 
Back
Top