In a shell and logged as "unprivileged_user" (a user which is not "root"), I presently have two clusters that I can start manually like this: unprivileged_user> pg_ctl start -D /where/cluster1/is/located/pgcluster1 -l /where/cluster1/is/located/pgcluster1.log unprivileged_user> pg_ctl start -D /where/cluster2/is/located/pgcluster2 -l /where/cluster2/is/located/pgcluster2.log
I would like to start the clusters at boot time and I would like them to be started as the non-root user "unprivileged_user". I would need a "/etc/init.d/" script...
Can you advise me how to do that?
There is one in PostgreSQL source files. Look into contrib/start-scripts directory. There is a linux script. Copy it under another name in the /etc/init.d/ directory. Duplicate it. And change it wrt to your installations.
