HowTo start Postgre sql daemon

josedsilva · 03-20-2003, 04:26 AM

How do I get the postgre sql server (daemon) up at bootup?
what is a documentation disk?

Crashed_Again · 03-20-2003, 10:34 AM

What distro are you using? You can try doing:

chkconfig --levels 35 postgresqld on

I think its 'postgresqld'. Do:

chkconfig --list | grep postgre

to see exactly what the service is called.

TimeSaver · 03-20-2003, 05:41 PM

If you have the GUI (in the latest releases of Linux (Redhat, Mandrake, SUse) Try going to services options and enabling it.

Or try editing the /etc/rc.d/init.d/xinetd
and there will be entries for bunch of daemans, add one for the pgsql and turn it on.

you can start manually by

/etc/rc.d/init.d/pgsql start

Crashed_Again · 03-20-2003, 06:03 PM

Quote:

you can start manually by

/etc/rc.d/init.d/pgsql start

Although this will start the postgresql service it will not be configured to start at boot up.

Tinkster · 03-20-2003, 06:05 PM

That's how I do it on my Slackware 8.1 boxes...

Code:

Taken from my /etc/rc.d/rc.local
/bin/su - postgres /usr/local/pgsql/bin/pg_ctl start -l home/postgres/logfile -D /usr/local/pgsql/data&

Cheers,
Tink