Search Postgresql Archives

Re: Start-up script for few clusters: just add water?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 






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 


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux