Installing PostgreSQL using RPM

In order to use ListManager with PostgreSQL, you will first need to download the RPM files appropriate to your version of Linux, from one of the postgresql.org mirror sites. ListManager will not work with versions of PostgreSQL older than 7.3.2, and we do not recommend using it with newer versions. If you are upgrading from an older version, you may find the Backup and Restore chapter (particularly the Migration Between Releases section) of the PostgreSQL Administrator's Guide helpful. The instructions here are a general guide to installing PostgreSQL on Red Hat Linux.

Documentation for PostgreSQL can be found at http://www.postgresql.org/docs/ .
 

You may also find our tuning tips helpful.

Installing PostgreSQL

After downloading PostgreSQL, log in as root and execute the following commands to install PostgreSQL:

1. As the root user, install the RPM files that were downloaded from postgresql.org:

rpm -ih postgresql-libs-7.3.2-1PGDG.i386.rpm
rpm -ih postgresql-7.3.2-1PGDG.i386.rpm
rpm -ih postgresql-server-7.3.2-1PGDG.i386.rpm

(The file names shown here represent those that were current at the time of this writing. The files you download may have slightly different names.)

2. Become the postgres user:

su - postgres

3. Initialize the data directory:

initdb --lc-collate=C

(The option shown here favors optimal database performance, rather than locale-specific sorting rules. If you are working with languages other than English, you may want to consult the Localization chapter of the PostgreSQL Administrator's Guide.)
 

4. Add or replace the following lines in /var/lib/pgsql/data/postgresql.conf :

syslog = 2
tcpip_socket = true

(The options shown here send log messages to the syslog facility, and allow database connections over TCP/IP sockets. Note that if you want the database to be accessible over the network, or if you have untrusted users on the computer that runs PostgreSQL, editing pg_hba.conf may be necessary. Consult the PostgreSQL Administrator's Guide for detailed configuration options.)
 

5. Start the database server:

pg_ctl start

6. Create a PostgreSQL user for ListManager to use, and assign it a password. We use "lmuser"; please select your own user name:

createuser -A -D -P lmuser
Enter password for user "lmuser":

7. Create a database for ListManager to use. We use "lmdatabase"; please select your own database name:

createdb --owner lmuser lmdatabase

8. Leave your postgres user session, becoming root again:

exit

9. Run the installer for ListManager. The user, password, and database will be those which you chose in the steps above. We recommend you select a user, password, and database different from those used in the examples.