Chapter 4: Deploying The PostgreSQL Relational Database
Starting the database
As user postgres start the database. It is important that you use both the -i and the -D flags.
You should redirect stdout and stderr to a file for logging purposes. Start the database in the background:
-bash-3.00$ /usr/bin/postmaster -i -D /opt/pgsql/data > /opt/pgsql/logfile 2>&1 &
You should see the following or similar processes running after starting the database:
| -bash-3.00$ ps auwwwwx|grep post |
| root 5544 0.0 0.1 4420 1152 pts/0 S 11:19 0:00 su - postgres |
| postgres 5545 0.2 0.1 4384 1440 pts/0 S 11:19 0:00 -bash |
| postgres 5602 0.0 0.2 19476 3056 pts/0 S 11:22 0:00 /usr/bin/postmaster -i -D /opt/pgsql/data |
| postgres 5603 0.0 0.1 9392 2052 pts/0 S 11:22 0:00 postgres: logger process |
| postgres 5605 0.0 0.3 19476 3116 pts/0 S 11:22 0:00 postgres: writer process |
| postgres 5606 0.0 0.2 10392 2088 pts/0 S 11:22 0:00 postgres: stats buffer process |
| postgres 5607 0.0 0.2 9568 2208 pts/0 S 11:22 0:00 postgres: stats collector process |
There is more configuration to be done but it will be done later after installing the Globus Toolkit.
Remember that Postgres needs to be deployed in this way on both nodes B and C. It is not necessary on node A.
|