Globus Toolkit Tutorial The Globus Consortium
 
 

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.
 
 
 
FAQ Feedback The Globus Consortium Home Page