installing_postgresql_on_rh_fc
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | |||
installing_postgresql_on_rh_fc [2007/04/25 16:50] – stephann | installing_postgresql_on_rh_fc [2010/09/06 13:22] (current) – Delete obsolete page dbs | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Install PostgreSQL on RH/FC ===== | ||
- | << | ||
- | Some of these notes come from the mailing list at http:// | ||
- | |||
- | ==== PostgreSQL Packages ==== | ||
- | |||
- | These are the packages you will need to install for PostgreSQL on Red Hat or Fedora Core. | ||
- | |||
- | | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | |||
- | The current version of PostgreSQL appears to be 8.1.8. | ||
- | |||
- | ==== Configuring PostgreSQL ==== | ||
- | |||
- | You will need to start the PostgreSQL server manually the first time. Eventually, you may want to configure it to run at system startup. | ||
- | |||
- | | ||
- | |||
- | Switch to user postgres before running the commands below. | ||
- | |||
- | su postgres | ||
- | |||
- | === Contrib utilities === | ||
- | |||
- | The [[http:// | ||
- | |||
- | | ||
- | |||
- | You will also want to add [[https:// | ||
- | |||
- | | ||
- | |||
- | === Create database and add languages === | ||
- | |||
- | Change to the postgres user home directory and add the [[http:// | ||
- | |||
- | | ||
- | |||
- | Create a Unicode database named evergreen. | ||
- | |||
- | | ||
- | |||
- | Add plperl and plperlu languages to the evergreen database only. The [[http:// | ||
- | |||
- | | ||
- | | ||
- | |||
- | === Drop and recreate database === | ||
- | |||
- | If you need to start over with a fresh database these commands will drop the current evergreen and recreate it. | ||
- | | ||
- | | ||
- | | ||
- | | ||
- | |||
- | === Change db user password === | ||
- | |||
- | | ||
- | Here you will see a welcome message. | ||
- | | ||
- | PostgreSQL will respond with "ALTER ROLE". | ||
- | | ||
- | |||
- | << | ||
- | |||
- | This page is under construction. |
installing_postgresql_on_rh_fc.1177534227.txt.gz · Last modified: 2022/02/10 13:33 (external edit)