<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
The command for starting Postgresql server on cluster db 1 is <br>
<br>
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -o "-i" start<br>
<br>
there is no -R option at all<br>
<br>
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -o "-i" -R start<br>
/usr/local/pgsql/bin/pg_ctl: invalid option -- R<br>
pg_ctl: invalid option (null)<br>
Try "pg_ctl --help" for more information.<br>
<br>
/usr/local/pgsql/bin/pg_ctl --help<br>
pg_ctl is a utility to start, stop, restart, reload configuration files,<br>
report the status of a PostgreSQL server, or signal a PostgreSQL
process.<br>
<br>
Usage:<br>
pg_ctl start [-w] [-D DATADIR] [-s] [-l FILENAME] [-o "OPTIONS"]<br>
pg_ctl stop [-W] [-D DATADIR] [-s] [-m SHUTDOWN-MODE]<br>
pg_ctl restart [-w] [-D DATADIR] [-s] [-m SHUTDOWN-MODE] [-o
"OPTIONS"]<br>
pg_ctl reload [-D DATADIR] [-s]<br>
pg_ctl status [-D DATADIR]<br>
pg_ctl kill SIGNALNAME PID<br>
<br>
Common options:<br>
-D, --pgdata DATADIR location of the database storage area<br>
-s, --silent only print errors, no informational messages<br>
-w wait until operation completes<br>
-W do not wait until operation completes<br>
--help show this help, then exit<br>
--version output version information, then exit<br>
(The default is to wait for shutdown, but not for start or restart.)<br>
<br>
If the -D option is omitted, the environment variable PGDATA is used.<br>
<br>
Options for start or restart:<br>
-l, --log FILENAME write (or append) server log to FILENAME<br>
-o OPTIONS command line options to pass to the postmaster<br>
(PostgreSQL server executable)<br>
-p PATH-TO-POSTMASTER normally not necessary<br>
<br>
Options for stop or restart:<br>
-m SHUTDOWN-MODE may be "smart", "fast", or "immediate"<br>
<br>
Shutdown modes are:<br>
smart quit after all clients have disconnected<br>
fast quit directly, with proper shutdown<br>
immediate quit without complete shutdown; will lead to recovery on
restart<br>
<br>
Allowed signal names for kill:<br>
HUP INT QUIT ABRT TERM USR1 USR2<br>
<br>
Report bugs to <a class="moz-txt-link-rfc2396E" href="mailto:pgsql-bugs@postgresql.org"><pgsql-bugs@postgresql.org></a>.<br>
<br>
<br>
Tarhon-Onu Victor wrote:
<blockquote
cite="mid:Pine.LNX.4.64.0708021401440.5283@oynpxoyhr.vnfv.npgvirzrqvngrpu.pbz"
type="cite">
<pre wrap="">On Thu, 2 Aug 2007, Trinath Somanchi wrote:
</pre>
<blockquote type="cite">
<pre wrap="">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 .
</pre>
</blockquote>
<pre wrap=""><!---->
Make sure you start the postgresql server on cluster db 1 with the
-R switch.
</pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<img src="cid:part1.03090903.09070002@intoto.com" border="0"></div>
</body>
</html>