[Pgcluster-general] PGCluster version 1.3 , implementation

Rick Vernam rickv at hobi.com
Fri Aug 3 14:40:15 UTC 2007 

MASTER_CLUSTER_DB-1 is saying that there is no user psql_mstr.
The user that owns the postgres processes, is it psql_mstr?
The db seems to be expecting user psql_master...

On Friday 03 August 2007 05:32:18 am Trinath Somanchi wrote:
>  Hi ,
>  I have searched Google for my problem , and found a link for my problem.
>
>  http://pgfoundry.org/pipermail/pgcluster-general/2005-March/000096.html
>
>  But , Now , I have seen some errors :
>
>  I have started MASTER CLUSTER-DB-1
>
>  [psql_mstr at pgsql]$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -o
> "-i " start postmaster starting
>  LOG:  database system was shut down at 2007-08-03 15:23:23 IST
>  LOG:  checkpoint record is at 0/A7F830
>  LOG:  redo record is at 0/A7F830; undo record is at 0/0; shutdown TRUE
>  LOG:  next transaction ID: 709; next OID: 17253
>  LOG:  database system is ready
>
>  Now , started REPLICATOR -1
>
>  [psql_master at pgsql]$ /usr/local/pgsql/bin/pgreplicate -n -v -D
> /usr/local/pgsql/etc DEBUG:replicate_main():replicate main 8001 port bind
> OK
>  DEBUG:PGRreplicate_packet_send():cmdSts=N
>  DEBUG:PGRreplicate_packet_send():cmdType=
>  DEBUG:PGRreplicate_packet_send():rlog=0
>  DEBUG:PGRreplicate_packet_send():request_id=0
>  DEBUG:PGRreplicate_packet_send():replicate_id=0
>  DEBUG:PGRreplicate_packet_send():port=0
>  DEBUG:PGRreplicate_packet_send():pid=0
>  DEBUG:PGRreplicate_packet_send():from_host=1mc111.intotoind.com
>  DEBUG:PGRreplicate_packet_send():dbName=template1
>  DEBUG:PGRreplicate_packet_send():userName=psql_master
>  DEBUG:PGRreplicate_packet_send():recieve sec=0
>  DEBUG:PGRreplicate_packet_send():recieve usec=0
>  DEBUG:PGRreplicate_packet_send():query_size=75
>  DEBUG:PGRreplicate_packet_send():query=SELECT
> PGR_SYSTEM_COMMAND_FUNCTION(1,'1mc111.intotoind.com',8001,8101,8201)
> DEBUG:sem_lock[1]
>  DEBUG:pgr_createConn():PQsetdbLogin host[1mc121.server.com] port[5432]
> db[template1] user[psql_master] DEBUG:pgr_createConn():PQsetdbLogin
> host[1mc111.server.com] port[5432] db[template1] user[psql_master]
> ERROR:pgr_createConn():PQsetdbLogin failed. close socket
>  DEBUG:pgr_createConn():PQsetdbLogin ok
>  ERROR:pgr_createConn():PQsetdbLogin failed. close socket
>  ERROR:pgr_createConn():PQsetdbLogin failed. close socket
>  ERROR:pgr_createConn():PQsetdbLogin failed. close socket
>  ERROR:pgr_createConn():PQsetdbLogin failed. close socket
>  ERROR:pgr_createConn():PQsetdbLogin  timeout
>  ERROR:setTransactionTbl():New Transaction but
> pgr_createConn5432 at 1mc111.intotoind.com failed
> DEBUG:deleteTransactionTbl(): getTransactionTbl failed
>  DEBUG:sem_unlock[1]
>
>
>  Now , I started MASTER-CLUSTER-DB-2 IN RECOVERY MODE :
>
>  [psql_mstr at pgsql]$ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -o
> "-R -i " start postmaster starting
>  Start in recovery mode!
>  Please wait until a data synchronization finishes from Master DB...
>  PGR_Get_Cluster_Conf_Data failed
>
>  I got the above error , and DB start failed.
>
>  But when I see the log at MASTER_CLUSTER_DB-1 , it an FATAL error log as
> shown below ,
>
>  FATAL:  user "psql_mstr" does not exist
>  FATAL:  user "psql_mstr" does not exist
>  FATAL:  user "psql_mstr" does not exist
>  FATAL:  user "psql_mstr" does not exist
>  FATAL:  user "psql_mstr" does not exist
>  FATAL:  user "psql_mstr" does not exist
>
>  I have test RSYNC over SSH and tested it , it works fine.
>
>  Can any one plot the mistake or problem in here.
>
>  Please help me in troubleshooting this problem ,
>
>  Thanks in Advance ,
>
>  Best Regards,
>  Trinath Somanchi.
>
>
>
>  Rick Vernam wrote:
> On Thursday 02 August 2007 07:45:51 am Trinath Somanchi wrote:
>
>  Do I need RSYNC over SSH configured for this
>
> yes
>
>
>  Trinath Somanchi wrote:
> When I run that command , i'm getting this error
>
> Start in recovery mode!
> Please wait until a data synchronization finishes from Master DB...
> PGR_Get_Cluster_Conf_Data failed
>
>  Please help me troubleshoot this error.
>
> Zoltan Boszormenyi wrote:
>
> Trinath Somanchi írta:
>
> The command for starting Postgresql server on cluster db 1 is
>
> /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -o "-i" start
>
> there is no -R option at all
>
> "-R" is an option for postgres/postmaster. try:
> /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -o "-i -R"  start
>
>
> /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -o "-i" -R  start
> /usr/local/pgsql/bin/pg_ctl: invalid option -- R
> pg_ctl: invalid option (null)
> Try "pg_ctl --help" for more information.
>
> /usr/local/pgsql/bin/pg_ctl --help
> pg_ctl is a utility to start, stop, restart, reload configuration files,
> report the status of a PostgreSQL server, or signal a PostgreSQL
> process.
>
> Usage:
>   pg_ctl start   [-w] [-D DATADIR] [-s] [-l FILENAME] [-o "OPTIONS"]
>   pg_ctl stop    [-W] [-D DATADIR] [-s] [-m SHUTDOWN-MODE]
>   pg_ctl restart [-w] [-D DATADIR] [-s] [-m SHUTDOWN-MODE] [-o
> "OPTIONS"] pg_ctl reload  [-D DATADIR] [-s]
>   pg_ctl status  [-D DATADIR]
>   pg_ctl kill    SIGNALNAME PID
>
> Common options:
>   -D, --pgdata DATADIR   location of the database storage area
>   -s, --silent           only print errors, no informational messages
>   -w                     wait until operation completes
>   -W                     do not wait until operation completes
>   --help                 show this help, then exit
>   --version              output version information, then exit
> (The default is to wait for shutdown, but not for start or restart.)
>
> If the -D option is omitted, the environment variable PGDATA is used.
>
> Options for start or restart:
>   -l, --log FILENAME     write (or append) server log to FILENAME
>   -o OPTIONS             command line options to pass to the postmaster
>                          (PostgreSQL server executable)
>   -p PATH-TO-POSTMASTER  normally not necessary
>
> Options for stop or restart:
>   -m SHUTDOWN-MODE   may be "smart", "fast", or "immediate"
>
> Shutdown modes are:
>   smart       quit after all clients have disconnected
>   fast        quit directly, with proper shutdown
>   immediate   quit without complete shutdown; will lead to recovery on
> restart
>
> Allowed signal names for kill:
>   HUP INT QUIT ABRT TERM USR1 USR2
>
> Report bugs to <pgsql-bugs at postgresql.org>.
>
> Tarhon-Onu Victor wrote:
>
> On Thu, 2 Aug 2007, Trinath Somanchi wrote:
>
> When I stop Cluster DB 1 , and insert rows into Cluster DB 2 and then
> start Cluster DB 1 , the previously inserted , rows into Cluster DB 2
> were not show in Cluster DB 1. How to troubleshoot this .
>
>     Make sure you start the postgresql server on cluster db 1 with the
> -R switch.
>
> --
> ------------------------------------------------------------------------
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>
> --
>
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general
>
>
>
> _______________________________________________
> Pgcluster-general mailing list
> Pgcluster-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgcluster-general

More information about the Pgcluster-general mailing list