I don't believe there is any central place where the cluster name is
stored (somebody will surely correct me if I'm wrong). When you init a
cluster with a name, the system uses that name to create a schema in the
target database with the name "_<cluster name>". You can see this schema
in psql by selecting from the pg_namespace table, then adding that
schema name to your search path if you want to get a list of tables,
etc. It's even easier to use a tool like pgAdmin, which has a nice
display of all the objects in a given database.
 
If you want to remove nodes from a cluster in an orderly way, i.e., you
are still using the cluster and not just blowing it away, you should
probably use slonik commands like "drop node" or "uninstall node". I
haven't used those, so perhaps somebody else can give a "best practice"
on how to do this. In my test environment I just do a "drop schema
"_<cluster name>" cascade" which cleans things up nicely in a given
database, but of course that leaves the cluster as a whole in an
inconsistent state.
 
- DAP

  _____  

From: slony1-general-bounces at gborg.postgresql.org
[mailto:slony1-general-bounces at gborg.postgresql.org] On Behalf Of
Victoria Parsons
Sent: Tuesday, August 03, 2004 4:20 AM
To: slony1-general at gborg.postgresql.org
Subject: [Slony1-general] location of cluster information



Hi Slony people, 

I have set up several slave systems from one master database using
slony. Most of them were just for testing, and I can't remember all the
clusternames I used. Where are the cluster names and the databases
associated with them stored? If I no longer wish to replicate these can
I and should I delete the old clusters?

Cheers, 
Vicki Parsons 



************************************************************************
This message should be regarded as confidential. If you have received
this email in error please notify the sender and destroy it immediately.
Statements of intent shall only become binding when confirmed in hard
copy by an authorised signatory.

Detica Limited is registered in England under No: 1337451 and Detica
(Rubus) Limited under No: 03361831.

Registered offices: Surrey Research Park, Guildford, Surrey, GU2 7YP,
England.
************************************************************************

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20040803/29306b9c/attachment.html