Dump and Restore in postgresql-8.3.6-1PGDG
От | suresh adapa |
---|---|
Тема | Dump and Restore in postgresql-8.3.6-1PGDG |
Дата | |
Msg-id | 0213965108DEAD48960CE83455E07DFF0234BC84@maa-exchmb.maa.corp.collab.net обсуждение исходный текст |
Ответы |
Re: Dump and Restore in postgresql-8.3.6-1PGDG
|
Список | pgsql-bugs |
=20 I am on Linux using postgresql-8.3.6-1PGDG =20 Taking Dump using =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D export PGPASSWORD=3Dsuresha && pg_dump -b -c -C --format=3Dc -h localhost -p 5432 -U suresha -f /tmp/dump/db/suresha.sql suresha =20 Trying to Restore the same like =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D [root@cu018 scripts]# pg_restore -c --format=3Dc -h localhost -p 5432 -U suresha -d suresha /tmp/dump/db/suresha.sql Password: pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 6; 2615 2200 SCHEMA public postgres pg_restore: [archiver (db)] could not execute query: ERROR: must be owner of schema public Command was: DROP SCHEMA public; 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 2663; 0 0 COMMENT SCHEMA public postgres 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'; pg_restore: WARNING: no privileges could be revoked for "public" pg_restore: WARNING: no privileges could be revoked for "public" pg_restore: WARNING: no privileges were granted for "public" pg_restore: WARNING: no privileges were granted for "public" WARNING: errors ignored on restore: 3 =20 Wondering how can I suppress the Error and other messages seen above. =20 =20 Thanks SureshA
В списке pgsql-bugs по дате отправления: