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.
