Differences

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

--- installing_postgresql_on_debian [2007/03/29 10:57] – stompro
+++ installing_postgresql_on_debian [2007/04/16 23:33] – Add UNICODE flag to installing PostgreSQL on Debian dbs
@@ Line 1: / Line 1: @@
+===== Installing Postgresql on Debian =====
+<<[[Installing_Prerequisites_on_Debian|Prev]]|[[Server_Installation|Index]]|[[Installing_Apache2_and_mod_perl2_on_Debian|Next]]>>
+==== Install Base Packages ====
+To install the postgresql packages on debian.
+  apt-get install postgresql-8.1 postgresql-contrib-8.1 postgresql-doc-8.1 postgresql-plperl-8.1 postgresql-server-dev-8.1
+Explanation:
+  * postgresql-8.1 - This is the core package that contains the program.
+  * postgresql-contrib-8.1 - The contains contributed utilites and stored procedures.
+  * postgresql-doc-8.1 - The documentation.
+  * postgresql-plperl-8.1 - Perl procedural language.
+  * postgresql-server-dev-8.1 - Dev files.
+----
+==== Installing Contrib packages ====
+Switch to user postgres for any of the following commands
+   # su postgres
+**[[http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/Tsearch_V2_Readme.html|Tsearch2]]** - full text search extension for PostgreSQL.
+  bash# psql template1 < /usr/share/postgresql/8.1/contrib/tsearch2.sql
+**[[http://projects.commandprompt.com/projects/public/pgsql/browser/trunk/pgsql/contrib/tablefunc/README.tablefunc|tablefunc]]** - Crosstab (aka, pivot) functions, CONNECT_BY (tree descendancy) function.
+  bash# psql template1 < /usr/share/postgresql/8.1/contrib/tablefunc.sql
+----
+==== Create Database and add languages ====
+Add the [[http://www.postgresql.org/docs/8.1/interactive/plpgsql.html|plpgsql]] language to template1.  This allows any database created after this to use the [[http://www.postgresql.org/docs/8.1/interactive/plpgsql.html|plpgsql]] language.  This language is considered safe and does not give any more access than regular SQL commands.
+   bash# createlang plpgsql -d template1
+Create the database evegreen.
+   bash# createdb -E UNICODE evergreen
+Add plperl and plperlu languages to evergreen.  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.
+   bash# createlang plperl -d evergreen
+   bash# 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# dropdb evergreen
+    bash# createdb -E UNICODE evergreen
+    bash# createlang plperl -d evergreen
+    bash# createlang plperlu -d evergreen
+----
+==== Change db user password ====
+   bash# psql
+   bash# alter user postgres password 'my password';
+   bash# \q
+<<[[Installing_Prerequisites_on_Debian|Prev]]|[[Server_Installation|Index]]|[[Installing_Apache2_and_mod_perl2_on_Debian|Next]]>>