Need help adding postgresql sevice at boot...

trist007 · 11-17-2009, 08:26 PM

I'm running Slackware 13.0

I edit the /etc/rc.d/rc.M file to add postgresql. The service needs to be started as the postgres user. This is what I've tried so far.

Code:

# Start the PostgreSQL database:
if [ -x /usr/local/pgsql/bin/pg_ctl ]; then
  . sudo -u postgres /usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/data -l serverlog
fi

Code:

# Start the PostgreSQL database:
if [ -x /usr/local/pgsql/bin/pg_ctl ]; then
   sudo -u postgres /usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/data -l serverlog
fi

It's one with and without the ".". Yet it still fails to load on boot.

If I run

Code:

sudo -u postgres /usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/data -l serverlog

directly in a terminal it loads up everything fine.

Any ideas?

bathory · 11-18-2009, 01:10 AM

Use the full path to sudo:

Code:

/usr/bin/sudo -u postgres /usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/data -l serverlog

May I ask why you put the script in rc.M and not in rc.local?

trist007 · 11-18-2009, 01:11 AM

Oh man that's right. No reason, what's rc.local meant for? I usually put all the services in rc.M.

How come in rc.M some lines have a period and others don't, what's period for?

Like I know sometimes when running a sh file I do

./start.sh but how come it's not on everything.

Also, just tried the suggested solution and it's still not working.

bathory · 11-18-2009, 03:21 AM

Hi,

rc.local is used to run commands or scripts, at the end of the default runlevel init scripts. So it's always good to put your custom startup scripts there.
The dot means that the command runs from current direcotry.
Regarding your problem maybe you have to give also the full path to serverlog, or you could try to use su instead of sudo:

Code:

/bin/su postgres -c "/usr/local/pgsql/bin/pg_ctl start -D /usr/local/pgsql/data -l serverlog"

trist007 · 11-19-2009, 01:37 AM

Nope that didn't work. Any other ideas? I can't find the full path to serverlog.

bathory · 11-19-2009, 04:47 AM

According to postgres documentation if serverlog does not exist it will be created, so you can use for example "-l /tmp/serverlog" so it gets written in /tmp.
Anyway try to use this startup script, after modifying it to suit your needs

Regards

trist007 · 11-19-2009, 06:36 AM

Excellent finally got it. Thank you so much. Made some minor changes.

Code:

root@server:~# cat postgresql.sh
#!/bin/sh

case "$1" in
        start)
                su postgres -c "/usr/local/pgsql/bin/pg_ctl  -D /usr/local/pgsql/data -p /usr/local/pgsql/bin/postmaster start  > /dev/null 2>&1" < /dev/null
                ;;
        stop)
                kill `ps -efa | grep postmaster | grep -v grep | awk '{print $2}'`
                ;;
        *)
                echo $"Usage: $0 {start|stop}"
                exit 1
esac

exit 0