Internet Express for Tru64 UNIX Version 6.8 Administration Guide (14233)

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 17.1: Installing PostgreSQL).
• Starting and stopping the PostgreSQL server (Section 17.2: Starting and Stopping PostgreSQL
Server).
• Viewing the PostgreSQL log file (Section 17.3: Viewing the PostgreSQL Log File).
• Location of PostgreSQL files, commands, reference pages, and accounts for administering
your PostgreSQL account (Section 17.4.1: Important Files and Directories).
• Running the postmaster startup script that enables you to run the PostgreSQL commands
(Section 17.4.2: Running the Postmaster Startup Script).
• Administering existing PostgreSQL accounts and databases (Section 17.4.3: Using Existing
PostgreSQL Accounts).
• Setting up a crontab entry for vacuuming databases (Section 17.5: Setting up a Crontab
Entry for Vacuuming Databases).
• Scaling PostgreSQL (Section 17.6: Scaling PostgreSQL).
This chapter also provides the following information about MySQL:
• MySQL directories and files(Section 17.7.1: Directories and Files Established by MySQL
Installation)
• Starting and stopping the MySQL server (Section 17.7.3: Starting and Stopping the MySQL
Server Using a Command Line)
• MySQL configuration files (Section 17.7.4: MySQL Configuration Files)
• MySQL log files (sec-mysql-log-files)
17.1 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.
17.2 Starting and Stopping PostgreSQL Server
You can start and stop the PostgreSQL server from the Administration utility. Follow these steps:
17.1 Installing PostgreSQL 255