468,161 Members | 1,983 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,161 developers. It's quick & easy.

How to obtain the real problem that avoids postgresql service starting?

Hi all,...
I'd like to know where can I get information about what is happening to
postgresql so it can't be started...

all I get is:
Starting postgresql service: [FAILED]

Is there any log file, or a way to start the database with a kind of -v
(verbose) option??
Or maybe any configuration parameter to modify on postgresql files,...

Any suggestion will help a lot!

That's it...
Thanks!
Netto
Nov 12 '05 #1
3 8053
> "Netto" <rc*****@yahoo.com> escreveu na mensagem
news:bq***********@news.hub.org...
Hi all,...
I'd like to know where can I get information about what is happening to
postgresql so it can't be started...


I wasn't able to find a file as I would like, but I when I tried to start
postmaster straightly, I got a message with the real problem,... you can try
that if need... :)

Netto
Nov 12 '05 #2
I think this is a pretty serious shortcoming of the standard
/etc/init.d/postgresql script, it sends all output (std. out AND error to
/dev/null).

You should have a line something like this

su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA -p /usr/bin/postmaster -o '-p ${PGPORT}' start > /var/log/postgres.log 2>&1" < /dev/null

You can see where I have replaced the "> /dev/null" with "> /var/log/postgres.log"

You would want to do this first, before attempting to start postgres, so
[root@somebox /#] vi /etc/init.d/postgresql
[root@somebox /#] touch /var/log/postgres.log
[root@somebox /#] chown postgres /var/log/postgres.log
[root@somebox /#] /etc/init.d/postgresql start

Now, when it fails, you will get decent logging in /var/log/postgres.log

Hope this helps.

Craig
On Tue, 2 Dec 2003, Netto wrote:
Hi all,...
I'd like to know where can I get information about what is happening to
postgresql so it can't be started...

all I get is:
Starting postgresql service: [FAILED]

Is there any log file, or a way to start the database with a kind of -v
(verbose) option??
Or maybe any configuration parameter to modify on postgresql files,...

Any suggestion will help a lot!

That's it...
Thanks!
Netto

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 12 '05 #3
However, if you then rotate the logs, you end up with space that won't be
reclaimed until the postmaster is restarted. I guess this is why people use
syslog.

On Fri, Dec 05, 2003 at 03:12:29PM +1100, Craig O'Shannessy wrote:
I think this is a pretty serious shortcoming of the standard
/etc/init.d/postgresql script, it sends all output (std. out AND error to
/dev/null).

You should have a line something like this

su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl -D $PGDATA-p /usr/bin/postmaster -o '-p ${PGPORT}' start > /var/log/postgres.log 2>&1" < /dev/null

You can see where I have replaced the "> /dev/null" with "> /var/log/postgres.log"

You would want to do this first, before attempting to start postgres, so


[root@somebox /#] vi /etc/init.d/postgresql
[root@somebox /#] touch /var/log/postgres.log
[root@somebox /#] chown postgres /var/log/postgres.log
[root@somebox /#] /etc/init.d/postgresql start

Now, when it fails, you will get decent logging in /var/log/postgres.log

Hope this helps.

Craig


On Tue, 2 Dec 2003, Netto wrote:
Hi all,...
I'd like to know where can I get information about what is happening to
postgresql so it can't be started...

all I get is:
Starting postgresql service: [FAILED]

Is there any log file, or a way to start the database with a kind of -v
(verbose) option??
Or maybe any configuration parameter to modify on postgresql files,...

Any suggestion will help a lot!

That's it...
Thanks!
Netto



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster


--
Martijn van Oosterhout <kl*****@svana.org> http://svana.org/kleptog/ "All that is needed for the forces of evil to triumph is for enough good
men to do nothing." - Edmond Burke
"The penalty good people pay for not being interested in politics is to be
governed by people worse than themselves." - Plato


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE/0Ag3Y5Twig3Ge+YRAsi8AKCesZcgvyrOw8f5R34Chvl3vRF0jA CgkOd4
zIe3Rz4L4YmVgcECHzLTvoc=
=JiGp
-----END PGP SIGNATURE-----

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Muhyiddin A.M Hayat | last post: by
4 posts views Thread by Phil Campaigne | last post: by
1 post views Thread by Shelby Cain | last post: by
1 post views Thread by nampet | last post: by
1 post views Thread by gcdp | last post: by
reply views Thread by kamranasdasdas | last post: by
reply views Thread by gcreed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.