Differences

This shows you the differences between two versions of the page.

--- installing_postgresql_on_rh_fc [2007/04/25 16:45] – stephann
+++ installing_postgresql_on_rh_fc [2007/04/25 16:50] – stephann
@@ Line 1: / Line 1: @@
+===== Install PostgreSQL on RH/FC =====
+<<[[installing_packages_on_rh_fc|Prev]]|[[server_installation|Index]]|[[installing_apache2_and_mod_perl2_on_rh_fc|Next]]>>
+Some of these notes come from the mailing list at http://open-ils.org/listserv.html.
+==== PostgreSQL Packages ====
+These are the packages you will need to install for PostgreSQL on Red Hat or Fedora Core.
+   postgresql
+   postgresql-contrib (contributed utilities and stored procedures)
+   postgresql-devel
+   postgresql-docs
+   postgresql-libs (installs as a dependency with posgresql)
+   postgresql-pl
+   postgresql-server (installs as a dependency with postgresql-pl)
+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.
+   service postgresql start
+Switch to user postgres before running the commands below.
+   su postgres
+=== Contrib utilities ===
+The [[http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/|tsearch2]] utility is a full-text search extension for PostgreSQL.  You should add this to template1 (which will subsequently be used to create your database).
+   bash-3.1$ psql template1 < /usr/share/pgsql/contrib/tsearch2.sql
+You will also want to add [[https://projects.commandprompt.com/public/pgsql/browser/trunk/pgsql/contrib/tablefunc/|tablefunc]] to template1.  This installs crosstab (pivot) and connectby (tree descendancy) functions.
+   bash-3.1$ psql template1 < /usr/share/pgsql/contrib/tablefunc.sql
+=== Create database and add languages ===
+Change to the postgres user home directory and add the [[http://www.postgresql.org/docs/8.1/interactive/plpgsql.html|plpgsql]] language to template1.  This allows any database created hereafter to use this language.  It is considered safe and does not give any more access than regular SQL commands.
+   bash-3.1$ createlang plpgsql -d template1
+Create a Unicode database named evergreen.
+   bash-3.1$ createdb -E UNICODE evergreen
+Add plperl and plperlu languages to the evergreen database only.  The [[http://www.postgresql.org/docs/8.1/interactive/plperl-trusted.html|plperlu]] language provides an environment for executing any Perl code so it isn't considered safe to add to template1.
+   bash-3.1$ createlang plperl -d evergreen
+   bash-3.1$ createlang plperlu -d evergreen
+=== Drop and recreate database ===
+If you need to start over with a fresh database these commands will drop the current evergreen and recreate it.
+   bash-3.1$ dropdb evergreen
+   bash-3.1$ createdb -E UNICODE evergreen
+   bash-3.1$ createlang plperl -d evergreen
+   bash-3.1$ createlang plperlu -d evergreen
+=== Change db user password ===
+   bash-3.1$ psql
+Here you will see a welcome message.
+   postgres=# alter user postgres password 'my password';
+PostgreSQL will respond with "ALTER ROLE".
+   postgres=# \q
+<<[[installing_packages_on_rh_fc|Prev]]|[[server_installation|Index]]|[[installing_apache2_and_mod_perl2_on_rh_fc|Next]]>>
+This page is under construction.