[Pgcluster-general] PGCluster version 1.3 , implementation

[Rick Vernam]

First, have you searched in this list's archives?
There is likely a solution here, which could surely save you a good amount of 
time.

We'll want to see cluster.conf & pgreplicate.conf, to start with...

On Thursday 02 August 2007 08:51:56 am Trinath Somanchi wrote:
>  I have configure rsync over ssh , but still I get the error .
>
>  >$  /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -o "-i -R " start
>
>  postmaster starting
>  Start in recovery mode!
>  Please wait until a data synchronization finishes from Master DB...
>  PGR_Get_Cluster_Conf_Data failed
>
>  please help me in troubleshooting this error.
>
>
>
>
>  Trinath Somanchi wrote:
> Do I need RSYNC over SSH configured for this
>
> 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