Hi Guillaume,
Excellent point:
> Suppose I have a second cluster. I'll have to do this :
>
cd /etc/init.d
cp postgresql postgresql2
cd /etc/sysconfig/pgsql
cp postgresql postgresql2
$EDITOR postgresql2
In $EDITOR, I'll change the different environment values I want. For
example:
>PGPORT=5567
>PGDATA=/db/second_cluster
In such case the new created start-up script postgresql2 should not be
modified in the following line:
# Override defaults from /etc/sysconfig/pgsql if file is present
[ -f /etc/sysconfig/pgsql/${NAME} ] && . /etc/sysconfig/pgsql/${NAME}
export PGDATA
export PGPORT
Or it will automatically match-up names from both directories, i.e.:
/etc/init.d/postgresql will get variables from /etc/sysconfig/pgsql
/postgresql?
/etc/init.d/postgresql2 will get variables from /etc/sysconfig/pgsql
/postgresql2
Pete
From: Guillaume Lelarge <
guillaume@xxxxxxxxxxxx>
To: Eustace Scrubb <
piotr.kublicki@xxxxxxx>
Cc: pgsql-general@xxxxxxxxxxxxxx
Date: 26/04/2010 22:18
Subject: Re: Start-up script for few clusters: just add water?
Le 26/04/2010 13:45, Eustace Scrubb a écrit :
> [...]
> I've installed Postgres with few instances/clusters, however I've got a
> problem with start-up scripts for all clusters. As far as I know the file
> postgresql should be modified in the /etc/sysconfig/pgsql directory. The
> question is as follows:
> Can I paste few clusters in this file? Currently I've got something like
> this:
>
> PGPORT=5566
> PGDATA=/db/one_cluster
>
> Such script will start only one cluster during server rebooting. Can I
just
> add more clusters in PGDATA in the file, something like this:
>
> PGPORT=5566
> PGDATA=/db/first_cluster
> PGPORT=5567
> PGDATA=/db/second_cluster
> PGPORT=5568
> PGDATA=/db/third_cluster
>
> Will it work?
>
According to the /etc/sysconfig/pgsql directory you're talking about, I
suppose you are on Fedora.
You need to create one init.d script by cluster and one file in the
/etc/sysconfig/pgsql directory per cluster.
Suppose I have a second cluster. I'll have to do this :
cd /etc/init.d
cp postgresql postgresql2
cd /etc/sysconfig/pgsql
cp postgresql postgresql2
$EDITOR postgresql2
In $EDITOR, I'll change the different environment values I want. For
example:
PGPORT=5567
PGDATA=/db/second_cluster
If I need a third cluster, I will do the exact same step but give a
different name for the init.d script (and also the PostgreSQL sysconf
file, don't forget they need to have the exact same name).
--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com
This email (and attachments) are confidential and intended for the addressee(s) only. If you are not the intended recipient please notify the sender, delete any copies and do not take action in reliance on it. Any views expressed are the author's and do not represent those of IOP, except where specifically stated. IOP takes reasonable precautions to protect against viruses but accepts no responsibility for loss or damage arising from virus infection. For the protection of IOP's systems and staff emails are scanned automatically.”
Institute of Physics Registered in England under Registration No 293851
Registered Office: 76/78 Portland Place, London W1B 1NT
