Trouble Connecting to DB After PGAdmin3 1.2.2 pgsql 7.45 Backup and 8.03 Restore

From: <operationsengineer1(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Trouble Connecting to DB After PGAdmin3 1.2.2 pgsql 7.45 Backup and 8.03 Restore
Date: 2005-10-03 21:17:05
Message-ID: 20051003211705.75430.qmail@web33304.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

i used pgadmin3 to back up a 7.4.5 database and
restore it to an 8.03 database. it can't connect to
the database using using

host: quality.mydomain.com
user: postgres
password: pass
db name: edb

(the above should be right)

when i enable adodb's error reporting, i see the the
db tries to run the query an returns 0 results. the
data is there and the query is simple - select
some_data from some table order by some data asc.

i had 70 errors ignored - it appears the error were
related "Owner" being the owner of my laptop db and
not existing in the new db. when i check the new
owner in the new db, "postgres" is listed - and that
is what i want.

here is an example of the returned output...

pg_restore.exe -i -h quality.mydomain.com -p 5432 -U
postgres -d "edb" -v "C:\Documents and
Settings\Owner\Desktop\pgsql_backup.backup"
pg_restore: connecting to database for restore
pg_restore: creating SCHEMA public
pg_restore: creating COMMENT SCHEMA public
pg_restore: creating FUNCTION plpgsql_call_handler()
pg_restore: [archiver (db)] Error while PROCESSING
TOC:
pg_restore: [archiver (db)] Error from TOC entry 9;
1255 140168 FUNCTION plpgsql_call_handler() Owner
pg_restore: [archiver (db)] could not execute query:
ERROR: user "Owner" does not exist
Command was: ALTER FUNCTION
public.plpgsql_call_handler() OWNER TO "Owner";

i'd appreciate a heads up as to what i have messed up
or what i might test / check to get this working.

note: i'm using adodb's "postgresql8" in order to
tell adob what db i'm using. hwoever, adodb debug
puts postgresql7 before the select statements that it
displays. i'm not sure if this is important or not.


__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2005-10-03 23:02:20 Re: Trouble Connecting to DB After PGAdmin3 1.2.2 pgsql 7.4.5 Backup and 8.03 Restore - SOLVED w/ QUESTION
Previous Message aviar cmms 2005-10-03 17:06:50 Missing file LIBC06P1