[Pgcluster-general] Strange problems...

[John Gardner]

We've just set up a simple 2 node cluster, with 1 of the nodes also the
replicator, and no load balancer (as yet)... It looks like this;

+------------+		+------------+
| cluster_2  |		| cluster_1  |
| replicator |		|            |
+------------+		+------------+

Now, there is obviously some communication going on between the two
servers as error messages appear on both consoles at the same time, but
if I try to use createdb to create a database on either server I get:

./createdb rep_test
ERROR:  This query is not permitted when all replication servers fell down
STATEMENT:  CREATE DATABASE rep_test
createdb: database creation failed: ERROR:  This query is not permitted
when all replication servers fell down

Now, I know that both cluster servers are running and the replicator is
also running.

If I run psql -l on cluster_1 I get:

        List of databases
   Name    |  Owner   | Encoding
-----------+----------+----------
 postgres  | postgres | UTF8
 template0 | postgres | UTF8
 template1 | postgres | UTF8
 test      | postgres | UTF8
(4 rows)

and on cluster_2 I get:


        List of databases
   Name    |  Owner   | Encoding
-----------+----------+----------
 postgres  | postgres | UTF8
 template0 | postgres | UTF8
 template1 | postgres | UTF8
(3 rows)

I haven't created the template0 and template1 databases, so they've
managed to be created and replicated automatically, but when I try and
drop them from either cluster I get:

./dropdb template1
ERROR:  This query is not permitted when all replication servers fell down
STATEMENT:  DROP DATABASE template1
dropdb: database removal failed: ERROR:  This query is not permitted
when all replication servers fell down

Can anyone point me in the right direction?

Thanks

John