Postgresql & Yast System Services

[ank2002]

Linux & SuSE 10.1 newbie - I built and installed PostgreSQL DB. The install went well and the server runs fine. Problems is that I would like to set the db server to start at boot. When I look at YaST System Services to enable the db service it is not there. I figure this is bacause I installed it outside of YaST.

I spent a bunch of time today seeing if I could get the init.d files right. I pulled the etc/init.d/postgresql file out of the server RPM to use as a sample but no matter what I tried I ended up with a "returned 126 (undefined error)". Google searchs returned nothing helpful about the error. Any suggestions or pointers to help understand the 126 error would be appreciated. I think I am over my head.

I can use use the Postgres packages that come with 10.1 but I was not sure how to control the location & folder structure for where the server DB would be installed.

Thx for any help

[daark.child]

When you have finished the postgresql installation, navigate to the contrib/start-scripts subdirectory in the postgresql source directory. Copy the linux/unix startup script thats in there and put it in /etc/init.d. Make it executable and name it something like postgresql. Edit the file so that the postgresql user is the same in the script as the one you setup for your system. After that do something like

#chkconfig --add postgresql
#chkconfig postgresql on

The above will setup postgresql to start whenever you start or reboot the system. To start it immediately without a reboot, do

#/etc/init.d/postgresql start

[ank2002]

When you have finished the postgresql installation, navigate to the contrib/start-scripts subdirectory in the postgresql source directory. Copy the linux/unix startup script thats in there and put it in /etc/init.d. Make it executable and name it something like postgresql. Edit the file so that the postgresql user is the same in the script as the one you setup for your system. After that do something like

#chkconfig --add postgresql
#chkconfig postgresql on

The above will setup postgresql to start whenever you start or reboot the system. To start it immediately without a reboot, do

#/etc/init.d/postgresql start

Thanks for the assist & info