In order to prevent unprepared access during starting / stop, a load balancer
should start at the end.Please stop from a load balancer conversely at the
time of a stop.
Start and a stop of replication server
|
(1) Start replication server
| $ /usr/local/pgsql/bin/pgreplicate -D /usr/local/pgsql/etc |
(2) Stop replication server
| $ /usr/local/pgsql/bin/pgreplicate -D /usr/local/pgsql/etc
stop |
(3) Restart replication server
| $ /usr/local/pgsql/bin/pgreplicate -D /usr/local/pgsql/etc
restart |
(4) Usage of a replication server's operation command .
A replication server's operation command is 'pgreplicate'.
Usage : pgreplicate [-D path of a configuration file] [-W path of
a log file][-v] [-n] [-l][-h] [stop | restart]
Options' meaning is as follows.
| -D |
Specification of the path of a configuration file. (default is "./") |
| -W |
Specification of the path of a log file. (default is "./") |
| -n |
Replication server is started without demonizing. |
| -v |
Replication server is started by a debug mode. In a debug mode,
a lot of strings for debugging are displayed.This option needs to
use together with -n option. |
| -l |
Replication server prints error logs in the log file. |
| -h |
Replication server prints help information and stops. |
| stop: |
This option stops the replication server. |
| restart: |
This option restart the replication server. |
Start and a stop of Cluster DB
|
(1)Starting of Cluster DB
Starting of Cluster DB is the same as starting of 'postmster' of PostgreSQL.
| $ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -o "-i"
start |
Please refer to the manual
of PostgreSQL about the starting option of PostgreSQL.
(2)Stop of Cluster DB
Please specify the stop option as the stop of Cluster DB.
| $ /usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data stop
|
Start and a stop of load balancer
|
(1) Start load balance server
| $ /usr/local/pgsql/bin/pglb -D /usr/local/pgsql/etc |
(2) Stop of a load balancer
| $ /usr/local/pgsql/bin/pglb -D /usr/local/pgsql/etc stop |
(3) Restart of a load balancer
| $ /usr/local/pgsql/bin/pglb -D /usr/local/pgsql/etc restart |
(4) Usage of a load balancer's operation command .
A load balancerr's operation command is 'pglb'.
Usage : pglb [-D path of a configuration file] [-W path of log file][-v]
[-n] [-l][-h] [stop | restart]
Options' meaning is as follows.
| -D |
Specification of the path of a configuration file. (default is "./") |
| -W |
Specification of the path of a log file. (default is "./") |
| -n |
Replication server is started without demonizing. |
| -v |
Replication server is started by a debug mode. In a debug mode,
a lot of strings for debugging are displayed.This option needs to
use together with -n option. |
| -l |
Replication server prints error logs in the log file. |
| -h |
Replication server prints help information and stops. |
| stop: |
This option stops the replication server. |
| restart: |
This option restart the replication server. |
Creation of a new database, and data transition from the existing
database
|
You can create a new database by the 'createdb' command. You can import
data by the COPY command or the psql command to take in the data of the
existing database. These are the same as PostgreSQL. When you execute these
commands in a Cluster DB, these commands will be executed in all Cluster
DBs automatically by a synchronous replication.
|
