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