[Pgcluster-general] Strange problems...

[a.mitani at sra-europe.com]

Hi,

I'm afraid that the configuration may be incorrect.
Could you show us your configuration files (pgreplicate.conf/cluster.conf)
and your network information (hostname, IP address etc.), if you can.

And, please do not remove the template database.
These are required for postgresql as well.

Regards,
-----------------
At.Mitani


> 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
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>