Hi Everybody, I found a solution for my problem.
What I did was to edit the pg_hba.conf and replaced 'md5' for user postgres with 'trust' which lets me execute: /usr/local/pgsql/bin/psql -d <dbname> -f saved_file It ran fine and then I put 'md5' back in place of 'trust.' Now all seems fine. I will spend a bit more time verifying that all tables are intact, but so far I have a good feelings. Many thanks. Regards, Tena Sakai [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] on behalf of Tena Sakai Sent: Sat 2/23/2008 6:57 PM To: pgsql-admin@postgresql.org Subject: [ADMIN] 8.3.0 postinstallation trouble Hi Everybody, I have gotten my postgres upgraded to 8.3.0 (from 8.2.4) or almost. I followed the steps in the manual, section 15.4. I was able to start 8.3.0 by: /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data via step 7. Now I am ready to restore from the saved file and typed: /usr/local/pgsql/bin/psql -d <dbname> -f saved_file and it asks me a password. I have been doing this all as user postgres and that password is rejected: password authentication failed for user "postgres" The pg_hba.conf, as well as postgresql.conf, is restored from 8.2.4. Can somebody please tell me what's going on and how to go about getting out of the trouble I am in? Regards, Tena Sakai [EMAIL PROTECTED]