postgresql 8.1 on Ubuntu

[feristhia]

Hi,

I've succeeded in installing postgresql 8.1 and PLESK 8.1 on Ubuntu. But when I logged in into PLESK's Component Info it says that postgresql-server was not installed.

And when I try to connect to it directly via database section and have localhost entry, it cannot connect. Then I changed it to 127.0.0.1 and it returns

=====================================
FATAL: 28000: password authentication failed for user "postgres"
LOCATION: auth_failed, auth.c:337
=====================================

as far as I know... I already has the correct password for postgresql.

Is there any instruction on how to setup postgresql 8.1 on Ubuntu 6.06 ?

Regards,

Feris

 

[breun]

I don't know about Ubuntu, but normally you just select PostgreSQL support in the Plesk Updater or autoinstaller and after that all is ready to go.

 

[BakArdY]

Hello,

It's been a long time since this issue has been opened, but maybe this can help any other person...

I think this issue appears when you install postgresql from official distros repository, and you must install it from SwSoft's.

From shell, you must become "postgres" user,
[root]:~#su postgres
Later, log in in psql to manage it...
-bash-3.00$psql

And you must create "admin" user...
CREATE USER admin SUPERUSER CREATEDB CREATEUSER LOGIN PASSWORD "XXXX";

And grant "postgres" group privileges...
GRANT postgres TO admin;

And later, you must be able to configure postgres in Plesk. The first password you assign in Plesk I guess must be the one you assignated in "psql".

This worked for me, hope this helps any one else.