More on start up

[daniel.java]

I can't figure out on how to run postgreSQL on start up. I have put everything I need at rc.local (adsl-start, httpd -k start, other stuff) but the postmaster thing doesn't work. I know that, as root, u cannot access postgres. Then I tried to put this in rc.local:

sudo -u postgres postmaster

But, still, it didn't work (although it works on the command promot).
So is there any way to do this by scripting or should I look to other places where postgreSQL is configured?

[andutt]

I would recommend to create a real startprogram under /etc/init.d for that program that every other applications have. But if you need a quick answer try to use..

su - postgres -c "postmaster"

In /etc/rc.local... that will change user to postgres and execute postmaster as that user...i havent tried it postgres my self so i can´t say if it workes, but its worth a try.