[Pgcluster-general] Best practice for bringing up clustered DBs

[Leif Madsen]

On 2/22/07, a.mitani at sra-europe.com <a.mitani at sra-europe.com> wrote:
> Hi,

Hi!

> > "A replication server can add dynamically, without stopping other
> > servers, such as Cluster DB."
> >
> > Basically means what? If I add a new replication server to the mix,
> > and I add it into the configuration files, I have to restart the
> > database, or not for it to become aware of that new replication
> > server?
>
> When start new replication server, it sends notice of start-up to all
> Cluster DBs.
> After that, the data of new replication server will be added to the
> replication server table in each Cluster DB, automatically.
> So, it is not necessary to restart Cluster DB when you add new replication
> server.

Thanks so much for the quick and informative replies! That makes sense.

So when the new replication server is brought up, do the Cluster DBs
automatically enter an entry into their cluster.conf files, or is this
just done in memory? I guess the real question is, "Should I be
updating the cluster.conf file with the new replication servers for
the next time the DB is restarted, even though they are aware of the
new replication server once it comes up?"

-- 
Leif Madsen.
http://www.leifmadsen.com
http://www.oreilly.com/catalog/asterisk