Article ID: 1188, created on Oct 6, 2008, last review on May 11, 2014

  • Applies to:
  • Plesk for Linux/Unix


To install PosgreSQL on Debian 3.1 with Plesk 8 you should follow these steps:

1) first of all you need to dump all existing databases. This can be done two ways:
- through phpPgAdmin (DB Webadmin in Plesk CP)
- or with 'pg_dumpall' utility. More info on pg_dump and pg_dumpall utilities usage you can find on

2) install PostgreSQL 8.1.

3) open pg_manage script (/opt/psa/admin/sbin/pg_manage) and find case statements which checks pgsql version:

case "$pg_real_ver" in

and add your version to the first match (e.g. was '7.[34]|8.0' and you should change it to '7.[34]|8.0|8.1').

4) Then create following symlinks:

ln -s /var/lib/postgresql/8.1/main /var/lib/postgres/data

for conf in /etc/postgresql/8.1/*.conf ; do
ln -s $conf /var/lib/postgres/data/$(basename $conf)

Those symlinks are necessary because configs and data pool locations has been changed from PgSQL version 7.x to 8.x.

5) Start PgSQL server, login into Plesk CP and configure PgSQL server admin's username and password.

6) Upload all databases which were dumped on step 1 (with phpPgAdmin or 'psql' utility).

Also, it is unknown if config files format has been changed from 7.x to 8.x. Currently, we haven't heard anything about it and all seems to be working fine.

29d1e90fd304f01e6420fbe60f66f838 a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF