Thread: How to start several PostgreSQL clusters at boot time on a Debian OS
Hello and thank you for reading my post. My question is about starting PostgreSQL clusters at boot time. The OS is Debian Wheezy. I have installed PostgreSQL from the sources (postgresql-9.3.5.tar.gz) at http://www.postgresql.org/ftp/source/v9.3.5/. 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? Best regards. -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-start-several-PostgreSQL-clusters-at-boot-time-on-a-Debian-OS-tp5823085.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Re: How to start several PostgreSQL clusters at boot time on a Debian OS
From
Guillaume Lelarge
Date:
Hi,
--
2014-10-15 12:18 GMT+02:00 Léa Massiot <lmhelp1@orange.fr>:
Hello and thank you for reading my post.
My question is about starting PostgreSQL clusters at boot time.
The OS is Debian Wheezy.
I have installed PostgreSQL from the sources (postgresql-9.3.5.tar.gz) at
http://www.postgresql.org/ftp/source/v9.3.5/.
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.
Regards.
--
It's perfect. Thank you very much. -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-start-several-PostgreSQL-clusters-at-boot-time-on-a-Debian-OS-tp5823085p5823088.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On 10/15/2014 03:18 AM, Léa Massiot wrote: > Hello and thank you for reading my post. > > My question is about starting PostgreSQL clusters at boot time. > > The OS is Debian Wheezy. > I have installed PostgreSQL from the sources (postgresql-9.3.5.tar.gz) at > http://www.postgresql.org/ftp/source/v9.3.5/. > > 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... Are you aware that 9.3 is available for Wheezy from the Postgres Apt Repo?: http://www.postgresql.org/download/linux/debian/ If you use the package you can get what you want built in, using pg_createcluster among other tools. > > Can you advise me how to do that? > Best regards. > > > > -- > View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-start-several-PostgreSQL-clusters-at-boot-time-on-a-Debian-OS-tp5823085.html > Sent from the PostgreSQL - general mailing list archive at Nabble.com. > > -- Adrian Klaver adrian.klaver@aklaver.com
Hello Adrian, Yes, I am aware of it. I even used to use Debian pg_createcluster and other tools before. Even so, thank you for your comment. Best regards. -- View this message in context: http://postgresql.1045698.n5.nabble.com/How-to-start-several-PostgreSQL-clusters-at-boot-time-on-a-Debian-OS-tp5823085p5823264.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.