[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