ResolutionTo 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 http://www.postgresql.org/docs/8.1/static/backup.html
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.|8.0' and you should change it to '7.|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.