I have debian lenny with intall postgresql 8.3 and I need update it to 8.4 I have install it from repository deb http://backports.debian.org/debian-backports 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?