PostgreSQL no administrative privileges

[Hal9000]

When trying to manage the database servers, i get this error for postgresql:

Warning: The last attempt to control this database server failed because the supplied account does not possess administrative privileges.

How can I know the password? Or how can I reset it?
I even tried uninstalling and reinstalling, but no avail...

Thanks for your help

Hal

 

[danliker]

as i rembemer you are on debian, right?

you need to use the old postgresql version 7.4.17 and it works, but not with the newer versions, i have an open ticket for that ...

 

[Hal9000]

root@fonzie:~# dpkg -l | grep postgre
ii  postgresql                     7.5.22                              object-relational SQL database management sy
ii  postgresql-7.4                 7.4.17-0etch1                       object-relational SQL database, version 7.4
ii  postgresql-client              7.5.22                              front-end programs for PostgreSQL (transitio
ii  postgresql-client-7.4          7.4.17-0etch1                       front-end programs for PostgreSQL 7.4
ii  postgresql-client-common       71                                  manager for multiple PostgreSQL client versi
ii  postgresql-common              71                                  manager for PostgreSQL database clusters

I have 7.4.17 right now, but yes, I upgraded to 8.1 before and it's ****ed up since then! Now 7.4 won't work either

 

[danliker]

try to set the "Administrator's login name " in plesk for postgresql to root an my server this fixed the problem ...

 

[Hal9000]

thanks mate, fixed here as well

 

[Hal9000]

btw, i set it back to 'admin', and it works fine now

 

[danliker]

i run now 8.1.9 the swsoft support helped me:

I have just successfully configured postgresql server through the panel at Server > Database servers > Add Database Server. I have specified postmaster port number and used '127.0.0.1' instead of 'localhost' in host.

and...

I have reported the hostname issue for postgresql database server to our developers for closer investigation.

it should also work on debian 3.1:
http://kb.swsoft.com/en/1188