Difference between revisions of "PostgreSQL on Debian"

From AOLserver Wiki
Jump to navigation Jump to search
Line 28: Line 28:
 
/etc/postgresql/
 
/etc/postgresql/
 
</pre>
 
</pre>
 +
 +
'''Recommended'''
 +
 +
While everyone has their own preferences for how to administer and customize their database installation, there are at least a couple of post-install steps that come in very handy:
 +
 +
* [http://www.debian-administration.org/articles/208] details importing the useful pgcrypto functions from postgresql-contrib into your template database:
 +
<pre>
 +
root @ box # su postgres
 +
postgres @ box $ psql template1 < /usr/share/postgresql/contrib/pgcrypto.sql
 +
</pre>
 +
 +
* [http://dev.panopticsearch.com/postgres_microhowto.html] details setting a database password for the postgres user, and setting up socket connection permissions (which allows, among other things, AOLServer to connect to the database).
  
 
'''Related'''
 
'''Related'''

Revision as of 22:36, 6 December 2005

While not always a part of an AOLServer installation, the fact that AOLServer is known almost foremost for its ability to support massively concurrent accesses to its database pools imply that it would be helpful to have such a database installed.

Some quick and easy steps to getting Postgresql up and running on Debian 3.1:

# install postgresql
apt-get install postgresql

# optional: to get some potentially useful documentation, should you choose to read it
apt-get install postgresql-doc

# optional: if you think you might be up for some postgresql hacking sometime
apt-get install postgresql-dev

# optional: useful contributed software includes some cryptographic hash functions
apt-get install postgresql-contrib

After installing the package(s) you want:

/etc/init.d/postgresql start

And you are running Postgresql. Congratulations. To make changes to your configuration files, visit:

/etc/postgresql/

Recommended

While everyone has their own preferences for how to administer and customize their database installation, there are at least a couple of post-install steps that come in very handy:

  • [1] details importing the useful pgcrypto functions from postgresql-contrib into your template database:
root @ box # su postgres
postgres @ box $ psql template1 < /usr/share/postgresql/contrib/pgcrypto.sql
  • [2] details setting a database password for the postgres user, and setting up socket connection permissions (which allows, among other things, AOLServer to connect to the database).

Related