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

a question from robbie

From: 金龙(Robbie(dot)Xu)许 <jinlxu(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: a question from robbie
Date: 2006-01-24 02:44:14
Message-ID: 4ef9b86b0601231844q142f2d8end5fa0b7d188e6081@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
dear sir,
1.First Question :Under Linux I Use  pg_dump -Ft -h 192.168.0.2 -U
dbusername -d db > /home/pgsql/back.tar
 And Then  pg_restore -c -h 192.168.0.2 -U dbusername -d db
/home/pgsql/back.tar  The Error shows Like this...What Can  I Do??
 pg_restore: [archiver (db)] Error while PROCESSING TOC:
 pg_restore: [archiver (db)] Error from TOC entry 5318; 16386 6987405 FK
CONSTRAINT tbl_workuser_work_id janson
 pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner
of schema public
        Command was: DROP SCHEMA public;
 pg_restore: [archiver (db)] Error from TOC entry 5; 16672 2200 SCHEMA
public pgsql
 pg_restore: [archiver (db)] could not execute query: ERROR:  schema
"public" already exists
     Command was: CREATE SCHEMA public;
 pg_restore: [archiver (db)] Error from TOC entry 5974; 0 0 COMMENT SCHEMA
public pgsql
 pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner
of schema public
     Command was: COMMENT ON SCHEMA public IS 'Standard public schema';
2.Second Question:I use  pg_dump -Ft -h 192.168.0.2 -U dbusername -d db >
back.tar Under Windows
 And Then pg_restore -c -h 192.168.0.2 -U dbusername -d db back.tar And
Shows Error Like
 pg_restore: [archiver (db)] connection to database "dbusername" failed:
FATAL:  pass
 word authentication failed for user "dbusername"
 its telling me that the password is wrong,but im pretty sure that my
password is right,because when i use pg_dump,it ask me to put in
password,and everything works fine。
 −−−−−
 Its 8.0 database。but if i use server and use trust to check,everything
looks fine,after i changed my password, all the question show like above.
Hope you can reply my mail.
best regards
robbie.xu

pgsql-bugs by date

Next:From: agattikDate: 2006-01-24 03:23:43
Subject: BUG #2205: Compilation error on Tru64: socklen_t in pqcomm.c
Previous:From: Peter EisentrautDate: 2006-01-23 19:20:03
Subject: Re: BUG #2203: Group by, suggested "feature"

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