postgresql problem after update debian etch to lenny

[danliker]

after the update from debian etch to lenny the Services management page shows PostgreSQL as not running and if i try to start it it gives this error:

Error: Unable to make action: Unable to manage service by pg_manage: Error: Unable to detect posgres version () or cluste name ()
3 ('--start', 'postgresql')

but postgresql is running ....

 

[IgorG]

Make sure with

# dpkg -l | grep postgre

that you have installed only one postgresql version there.
For resolving this problem I suggest you remove all postgresql packages, configuration file postgresql.conf and reinstall it with something like:

# apt-get remove --purge postgresql-7.4 postgresql-client postgresql-client-7.4 postgresql-client-common postgresql-common
rm -rf /etc/postgresql/7.4/main/postgresql.conf
# apt-get install postgresql-7.4

After that configure PostgreSQL with credentials through Parallels Plesk Panel :

Home -> Database Servers -> Local PostgreSQL server

 

[danliker]

this do not work and by the way lenny has 8.3.8 not 7.4

dpkg -l |grep postgres
ii postgresql 8.3.8-0lenny1 object-relational SQL database (supported ve
ii postgresql-8.3 8.3.8-0lenny1 object-relational SQL database, version 8.3
ii postgresql-client 8.3.8-0lenny1 front-end programs for PostgreSQL (supported
ii postgresql-client-8.3 8.3.8-0lenny1 front-end programs for PostgreSQL 8.3
ii postgresql-client-common 94lenny1 manager for multiple PostgreSQL client versi
ii postgresql-common 94lenny1 PostgreSQL database-cluster manager

 

[IgorG]

It was just sample. Try this for your version of Postgresql.

 

[danliker]

ok "Services management page" is now ok, but under databese servers i get now this error:

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

 

[IgorG]

Try to add database server with something like

/usr/local/psa/bin/database-server.sh --create-server hostname:5432 -type postgresql -admin admin -passwd setup