Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have debian lenny with intall postgresql 8.3 and I need update it to 8.4 I have install it from repository deb lenny-backports main contrib non-free But now I have two postgre servers. Do I need to buckup DB from 8.3 and import it to 8.4? I tring it but have problem:

  • su postgres
  • psql -d template1 and get error psql: FATAL: Ident authentication failed for user "postgres" it's correct for server postgre 8.3 How can I login to postgre console in server 8.4?
share|improve this question
up vote 0 down vote accepted

check "man pg_wrapper". All the postgres commands (like psql) are run through this wrapper, so "psql --cluster 8.3/main templat1" would talk to your 8.3 install and "psql --cluster 8.4/main template1" would talk to your 8.4 cluster.

If all your data is in the 8.3 cluster and nothing is in the 8.4 cluster, you may just want to delete the 8.4 cluster and upgrade the 8.3 cluster to 8.4:

$ pg_dropcluster 8.4 main
$ pg_upgradecluster 8.3 main

It would, of course, be wise to backup both clusters first.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.