[Pgcluster-general] PGCluster version 1.3 , implementation

[Rick Vernam]

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