[Pgcluster-general] PGCluster version 1.3 , implementation
Zoltan Boszormenyi
zb at cybertec.at
Thu Aug 2 11:33:27 UTC 2007
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
>
--
----------------------------------
Zoltán Böszörményi
Cybertec Geschwinde & Schönig GmbH
http://www.postgresql.at/
More information about the Pgcluster-general
mailing list