[opensuse] Can't Start PostgreSQL Service
I've installed PostgreSQL 8.4 from the server:database:postgresql repository since it includes the pgAdmin3 program. However, after installing it, I can't get it to start! It should simply start with the "rcpostgresql start" command, but I get "Starting PostgreSQLcould not start server failed" as a result. I therefore ran "bash -x /etc/init.d/postgresql start" to see where it hangs. It seems to wait on the following command: + su - postgres -c 'LD_LIBRARY_PATH= /usr/bin/pg_ctl start -s -w -p /usr/bin/postmaster -D /var/lib/pgsql/data -o ""' could not start server Issuing the command as root on the command line results in the same result. Removing the -s option does not provide any more clues, and there is no log file to check. I have no idea why I can't start the server and don't know where to go from here. I've tried re-installing, downgrading, etc but nothing helps. Any help is appreciated. Anthony Simonelli -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Tue, Aug 18, 2009 at 11:57:44 -0500, Anthony Simonelli wrote:
I've installed PostgreSQL 8.4 from the server:database:postgresql repository since it includes the pgAdmin3 program. However, after installing it, I can't get it to start! It should simply start with the "rcpostgresql start" command, but I get "Starting PostgreSQLcould not start server failed" as a result. I therefore ran "bash -x /etc/init.d/postgresql start" to see where it hangs. It seems to wait on the following command:
+ su - postgres -c 'LD_LIBRARY_PATH= /usr/bin/pg_ctl start -s -w -p /usr/bin/postmaster -D /var/lib/pgsql/data -o ""' could not start server
Issuing the command as root on the command line results in the same result. Removing the -s option does not provide any more clues, and there is no log file to check. I have no idea why I can't start the server and don't know where to go from here. I've tried re-installing, downgrading, etc but nothing helps. Any help is appreciated.
Anthony Simonelli
Is it an update? Then you need to replace "ident sameuser" with "ident" in pg_hba.conf. See https://bugzilla.novell.com/522375 Peter -- "WARNING: This bug is visible to non-employees. Please be respectful!" SUSE LINUX Products GmbH Research & Development
On Wednesday 19 August 2009 04:35:22 am Peter Poeml wrote:
On Tue, Aug 18, 2009 at 11:57:44 -0500, Anthony Simonelli wrote:
I've installed PostgreSQL 8.4 from the server:database:postgresql repository since it includes the pgAdmin3 program. However, after installing it, I can't get it to start! It should simply start with the "rcpostgresql start" command, but I get "Starting PostgreSQLcould not start server failed" as a result. I therefore ran "bash -x /etc/init.d/postgresql start" to see where it hangs. It seems to wait on the following command:
+ su - postgres -c 'LD_LIBRARY_PATH= /usr/bin/pg_ctl start -s -w -p /usr/bin/postmaster -D /var/lib/pgsql/data -o ""' could not start server
Issuing the command as root on the command line results in the same result. Removing the -s option does not provide any more clues, and there is no log file to check. I have no idea why I can't start the server and don't know where to go from here. I've tried re-installing, downgrading, etc but nothing helps. Any help is appreciated.
Anthony Simonelli
Is it an update? Then you need to replace "ident sameuser" with "ident" in pg_hba.conf. See https://bugzilla.novell.com/522375
Peter
I finally figured out what the problem was. Your mention of the pg_hba.conf file (which was correct), combined with the bug I found https://bugzilla.novell.com/show_bug.cgi?id=522375 lead me to the answer. I found that turning "silent_mode = off" allowed it to display error messages: # rcpostgresql start Starting PostgreSQL2009-08-19 11:49:06 CDT LOG: could not create IPv6 socket: Address family not supported by protocol 2009-08-19 11:49:06 CDT WARNING: could not create listen socket for "localhost" 2009-08-19 11:49:06 CDT FATAL: could not create any TCP/IP sockets could not start server I had disabled IPV6 support in Network Devices because browsing the Internet was extremely slow with it enabled. In my hosts file, the "localhost" alias was assigned to ::1, the IPV6 localhost. Because of these two factors, PostgreSQL could not create a listen socket. I changed my hosts file to assign ::1 to ipv6-localhost and 127.0.0.1 to localhost. After that, PostgreSQL would start! What a waste of time trying to figure this out when all I had to do was change my hosts file (or enable IPV6). I don't know why localhost was assigned to ::1 by default, especially if I have IPV6 disabled. And it would have been nice to have silent_mode off as a command option. Should I fill out a bug report for any of this or am I just a victim of circumstances? -- To unsubscribe, e-mail: opensuse+unsubscribe@opensuse.org For additional commands, e-mail: opensuse+help@opensuse.org
On Wed, Aug 19, 2009 at 12:09:17 -0500, Anthony Simonelli wrote:
On Wednesday 19 August 2009 04:35:22 am Peter Poeml wrote:
On Tue, Aug 18, 2009 at 11:57:44 -0500, Anthony Simonelli wrote:
I've installed PostgreSQL 8.4 from the server:database:postgresql repository since it includes the pgAdmin3 program. However, after installing it, I can't get it to start! It should simply start with the "rcpostgresql start" command, but I get "Starting PostgreSQLcould not start server failed" as a result. I therefore ran "bash -x /etc/init.d/postgresql start" to see where it hangs. It seems to wait on the following command:
+ su - postgres -c 'LD_LIBRARY_PATH= /usr/bin/pg_ctl start -s -w -p /usr/bin/postmaster -D /var/lib/pgsql/data -o ""' could not start server
Issuing the command as root on the command line results in the same result. Removing the -s option does not provide any more clues, and there is no log file to check. I have no idea why I can't start the server and don't know where to go from here. I've tried re-installing, downgrading, etc but nothing helps. Any help is appreciated.
Anthony Simonelli
Is it an update? Then you need to replace "ident sameuser" with "ident" in pg_hba.conf. See https://bugzilla.novell.com/522375
Peter
I finally figured out what the problem was. Your mention of the pg_hba.conf file (which was correct), combined with the bug I found https://bugzilla.novell.com/show_bug.cgi?id=522375 lead me to the answer. I found that turning "silent_mode = off" allowed it to display error messages:
Yes, that was the other bug I reported when I ran into the other problem. It cost me (and helpful people in #postgresql-de) quite some time to debug!
# rcpostgresql start Starting PostgreSQL2009-08-19 11:49:06 CDT LOG: could not create IPv6 socket: Address family not supported by protocol 2009-08-19 11:49:06 CDT WARNING: could not create listen socket for "localhost" 2009-08-19 11:49:06 CDT FATAL: could not create any TCP/IP sockets could not start server
I had disabled IPV6 support in Network Devices because browsing the Internet was extremely slow with it enabled. In my hosts file, the "localhost" alias was assigned to ::1, the IPV6 localhost. Because of these two factors, PostgreSQL could not create a listen socket.
I changed my hosts file to assign ::1 to ipv6-localhost and 127.0.0.1 to localhost. After that, PostgreSQL would start! What a waste of time trying to figure this out when all I had to do was change my hosts file (or enable IPV6). I don't know why localhost was assigned to ::1 by default, especially if I have IPV6 disabled. And it would have been nice to have silent_mode off as a command option.
Should I fill out a bug report for any of this or am I just a victim of circumstances?
Please, join in at the bugzilla issue, to express your sentiment, adding weight into the bug which might cause it to be fixed. Thanks, Peter -- "WARNING: This bug is visible to non-employees. Please be respectful!" SUSE LINUX Products GmbH Research & Development
participants (2)
-
Anthony Simonelli
-
Peter Poeml