Skip site navigation (1) Skip section navigation (2)

Re: Trouble Connecting to DB After PGAdmin3 1.2.2 pgsql 7.4.5 Backup and 8.03 Restore - SOLVED w/ QUESTION

From: <operationsengineer1(at)yahoo(dot)com>
To: operationsengineer1(at)yahoo(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: Re: Trouble Connecting to DB After PGAdmin3 1.2.2 pgsql 7.4.5 Backup and 8.03 Restore - SOLVED w/ QUESTION
Date: 2005-10-03 23:02:20
Message-ID: 20051003230221.14652.qmail@web33310.mail.mud.yahoo.com (view raw or flat)
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.

i figured out why i couldn't get any data...

i use this adodb code to connect to my db...

$db->Connect($db_string,$db_owner,$db_pw,$db_name);

if $db_string has a value, it won't connect.  it i
don't give it a value, it connects.

eg, if i define $db_string = 'localhost' or
'quality.mydomain.com, the code won't connect. 

is this expected behavior?


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

In response to

pgsql-novice by date

Next:From: A GilmoreDate: 2005-10-04 05:16:01
Subject: Re: Comparing arrays
Previous:From: operationsengineer1Date: 2005-10-03 21:17:05
Subject: Trouble Connecting to DB After PGAdmin3 1.2.2 pgsql 7.45 Backup and 8.03 Restore

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group