Postgress TCP/IP connection at Startup

dhruiz · 10-22-2004, 09:13 AM

Hi,
I'm beginning to work with Postgres (7.4) and I have a silly question. I can't connect with my database through TCP/IP immediately after start my system. I need to shutdown postmaster and restart it with the "-i" option.After that, everything works fine, what means that the configuration files are OK. My question is:
How can I do in order to start postmaster with "-i" option during my system startup ???

Thanks

D

iluvatar · 10-22-2004, 09:19 AM

sounds like you have to add the -i option to the bootscript where the postgresql server is started. I see you have debian woody wich I don't know, but on most distro's the bootscripts are located at /etc/rc.d or /etc/init.d. search there for a script wich starts postgresql.

greetz,
.-=~ iluvatar ~=-.

dhruiz · 10-28-2004, 08:30 AM

Hi,
I found this line in the script postgresql under /etc/init.d, should I add a "-i" option after --start ?.

(/sbin/start-stop-daemon --pidfile $PGDATA/postmaster.pid --chuid postgres --startas /usr/lib/postgresql/bin/postgresql-startup --start 2>&1

iluvatar · 10-28-2004, 10:01 AM

I think you should add it before the --start...

greetz,
.-=~ iluvatar ~=-.

dhruiz · 10-29-2004, 09:05 AM

Actually,
it should be after --start and without anything just i, because parameter format for the start-stop daemons in Debian.

Thank you so much for your help !!!!!

D

iluvatar · 10-29-2004, 09:09 AM

Quote:

because parameter format for the start-stop daemons in Debian.

sorry, didn't know that....

greetz,
.-=~ iluvatar ~=-.