17 PostgreSQL Database and MySQL Administration

Internet Express provides the PostgreSQL and MySQL database management systems.

PostgreSQL is an advanced database server that supports most SQL constructs, including subselects, transactions, and user-defined types and functions. Each PostgreSQL server controls access to a number of databases, storage areas used by the server to partition information. A typical installation may have several databases, for example: a production database, used to keep all information about a company; a training database, used for training and testing purposes; and private databases, used by individuals to store personal information.

MySQL is an open source database management system that relies on SQL for processing the data in the database. MySQL is most commonly used for Web applications and for embedded application

This chapter provides information that helps you administer your Internet Express PostgreSQL database

•Considerations when installing PostgreSQL (Section : Installing PostgreSQL).

•Starting and stopping the PostgreSQL server (Section : Starting and Stopping PostgreSQL Server).

•Viewing the PostgreSQL log file (Section : Viewing the PostgreSQL Log File).

•Location of PostgreSQL files, commands, reference pages, and accounts for administering your PostgreSQL account (Section : Important Files and Directories).

•Running the postmaster startup script that enables you to run the PostgreSQL commands (Section : Running the Postmaster Startup Script).

•Administering existing PostgreSQL accounts and databases (Section : Using Existing PostgreSQL Accounts).

•Setting up a crontab entry for vacuuming databases (Section : Setting up a Crontab Entry for Vacuuming Databases).

•Scaling PostgreSQL (Section : Scaling PostgreSQL).

This chapter also provides the following information about MySQL:

•MySQL directories and files(Section : Directories and Files Established by MySQL Installation)

•Starting and stopping the MySQL server (Section : Starting and Stopping the MySQL Server Using a Command Line)

•MySQL configuration files (Section : MySQL Configuration Files)

•MySQL log files (sec-mysql-log-files)

Installing PostgreSQL

Installation tasks include getting the subset, compiling, initializing, starting the server, and creating a database. See the Internet Express Installation Guide for the installation procedure.

PostgreSQL is installed in /usr/internet/pgsql/. A /usr/local/pgsql symbolic link is created to duplicate the PostgreSQL default installation path.

When you install PostgreSQL, it automatically creates an account called postgres with /usr/ internet/pgsql/ as its home directory.

Starting and Stopping PostgreSQL Server

You can start and stop the PostgreSQL server from the Administration utility. Follow these steps:

Installing PostgreSQL 249