I am attempting to start postgreSQL on my computer at boot time. I can start the server from the command line but cannot figure out how to get it to start on boot.

The problem is that postgreSQL server must be run by a particular user (in this case "postgres"). I am wondering how to script that and where I should be putting it in the etc folder, and how to organize, and....

I would ask the postgres guys, but their documentation is fairly clear as to how to start their software, I'm more wondering how to execute the commands to automagically...

So to summarize:

How do I start run a command as the user "postgres" at system boot?

Or you make a cron for the user "postgress" or you make a simple script (su postgress (no passwd needed), command to start). and put this into /etc/rc.d/rc.local

I tried that (rc.d). Wouldn't the user need to come back?

[code]
su postges
start server
exit ????
[code]

Will look into creating a cron for postgres. But I think the rc.d is preferred.

#!/bin/sh

su postgres &
cd /etc/rc.d/ &
./rc.postgre start

# end script

put that script in your rc.local and give it a shot.

Put this line
into
/etc/rc.d/rc.local
(modify directories to match your system) ... ;)


Cheers,
Tink

I have it in place. Will let you know.

The wife needs me off the computer so I will shutdown right now and let you know after work.

Went with Tinkster's... It looks like he's running postgreSQL (mentions a couple things you would only know if you had read the manual or worked with postgres).

That worked.

Sorry it took so long, but I am having trouble with my computer overheating and the reinstall of postgres kept cutting the power to my computer and ......

Anyway. I used tinkster's solution, it worked. I now have postgresql running everytime I turn my computer on.