[GENERAL] Drop Cluster

Hi, Is there any command to drop a postgres cluster??? I tried the following link http://www.digipedia.pl/man/pg_dropcluster.8.html but it says command not found. Is there any other way?? Any help will be highly appreciated. Thanks in advance. Regards, Sweta. -- Sent via pgsql-general

[GENERAL] Drop Cluster

Hi, Is there any command to drop a postgres cluster??? I tried the following link http://www.digipedia.pl/man/pg_dropcluster.8.html but it says command not found. Is there any other way?? Any help will be highly appreciated. Thanks in advance. Regards, Sweta. -- Sent via pgsql-general

Re: [GENERAL] Drop Cluster

Will deleting the contents from the directory remove "Cluster already exists" error??? Thanks and Regards, Sweta. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Drop Cluster]

rt PGDATA Still I get the same error replconfig.cnf:17: Error: namespace "_replcluster" already exists in database of node 1 Now what to do Regards, Sweta -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Drop Cluster]

eck whether the > _replcluster schema is already exists or not by giving the command "/dn" > this give --> [r...@quirinus pg_log]# su - postgres -bash-3.2$ /dn -bash: /dn: No such file or directory -bash-3.2$ dn -bash: dn: command not found Regards, Sweta -- S

Re: [GENERAL] Drop Cluster

hi, Thankyou Its done :) Regards, Sweta -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL]

ot;dbname=$MASTERDBNAME user=$MASTERDBA host=$MASTERHOST port=$MASTERPORT" > slon.log & On slave run /usr/local/pgsql/bin/slon $CLUSTERNAME "dbname=$SLAVEDBNAME user=$SLAVEDBA host=$SLAVEHOST port=$SLAVEPORT" > slon.log & Now I dont know how to stop it ... :(

Re: [GENERAL]

Hello , >> > You can use "kill " command to kill the slon daemons, > find > the pid's of the cluster and kill. > > But that is not totally right :P . If there is no other way we will use it.. But I want to stop slony properly using s

[GENERAL] Sequence Not created with pg_dump

Hello all, When I create a db dump using -- pg_dump -s dbname > mydump.sql Sequences present are not being added to the mydump.sql file PS Cannot paste the contents of the file . Its too large :P Regards Sweta -- Sent via pgsql-general mailing list (pgsql-general@postgresql.

Re: [GENERAL] Sequence Not created with pg_dump

> > Seems unlikely (IOW, if so, you've found a bug no one else has ever > seen). Maybe they are being created implicitly by SERIAL column > declarations? > Yeah they are created by the Serial column . Regards Sweta -- Sent via pgsql-general mailing list (pgsql-ge

[GENERAL] duplicate key violates unique constraint

e constraint "sl_table_tab_reloid_key" I am a bit confused about where to post it.. So I am posting it here first... Thanks and Regards, Sweta. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general