Filter
Top Products
2-2
Cisco Carrier Sensitive Routing User Guide
Chapter2 PostgreSQL Database Operations and Functionalities
Database Operations
• -S—Tells the postmaster to run in silent mode. This is not recorded to a log file.
• -i—Tells postmaster to allow network connections. If this is not set, the postmaster accepts
connections only from the local host.
Note This is needed for the GUI to connect to the database even when it is running on the same
machine.
• -B and -N—Set up shared memory segments.
• -D—Tells the postmaster the location of the database files.
Note For servers with console login, disable Xwindow in the file .profile, so the database can be restarted
from a reboot.
Exiting the Database
To exit the postgreSQL database, perform the following steps:
Step 1 Log in to the Solaris system by entering postgres as the user.
A “postgres” password prompt may appear.
Step 2 Enter the following command:
/etc/init.d/postgres_init stop
This command calls the postgreSQL command pg_ctl stop.
Reactivating the Database
To reactivate the postgreSQL database, perform the following steps.
Step 1 Log in into the Solaris system by entering postgres as the user.
A “postgres” password prompt may appear.
Step 2 Enter the following command:
/etc/init.d/postgres_init restart
This command calls the postgreSQL command pg_ctl restart. The parameters for this command are
described in “Activating the Database” section on page2-1.