[Pgcluster-general] pgcluster example

[David King]

I should also mention that I've basically copy-pasted the  
configuration on the Example page, including the <Log_File_Info> bits.  
The log file in the example is /var/log/postgresql/pglb.log, which  
Postgres has permission to write, but it's never written. On cluster_1  
and cluster_2, which are both load balancers and replicators, I'm  
starting Postgres with

         su - $PGUSER -c "$DAEMON -D '$PGDATA' &" >>$PGLOG 2>&1
         su - $PGUSER -c "$prefix/bin/pgreplicate -D $PGDATA &" >> 
$PGLOG 2>&1
         su - $PGUSER -c "$prefix/bin/pglb -D $PGDATA &" >>$PGLOG 2>&1

Into $PGLOG, only this is written:

     LOG:  database system was shut down at 2008-06-25 11:03:59 PDT
     LOG:  checkpoint record is at 0/48CEC0
     LOG:  redo record is at 0/48CEC0; undo record is at 0/0; shutdown  
TRUE
     LOG:  next transaction ID: 0/637; next OID: 10820
     LOG:  next MultiXactId: 1; next MultiXactOffset: 0
     LOG:  database system is ready

Which is regular start-up noise. On cluster_3, which is only a cluster  
node, I'm running only the first line. Each node has this in their  
pg_hba.conf:

     host    all         all         172.16.197.0/24       trust

So they should be able to connect to each other just fine, which I can  
verify: they can all connect to each other on port 5432, the regular  
Postgres port, without being prompted for a password.

Clearly I'm doing something wrong :)

On 25 Jun 2008, at 11:24, David King wrote:

> I'm following the example configuration at http://www.pgcluster.org/wiki/Example
> , and it doesn't look complete. After setting up the configuration
> documented there, and starting postgres, pgpl, and pgreplicate, what's
> next?
>
> I assume that this setting:
>
>     <Receive_Port>          5433     </Receive_Port>
>
> tells pglb on what port to listen. When I connect to it, like this:
>
>     psql -h cluster_1 -p 5433 -U postgres postgres
>
> I get:
>
>     psql: server closed the connection unexpectedly
>         This probably means the server terminated abnormally
>         before or while processing the request.
>
> Did I do something wrong? Is there a more detailed FAQ than <http://www.pgcluster.org/wiki/FAQ
>> ?
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general