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