[repost] pg_restore doesn't work with custom format?
От | Allan Engelhardt |
---|---|
Тема | [repost] pg_restore doesn't work with custom format? |
Дата | |
Msg-id | 3BD0408E.2090908@cybaea.com обсуждение исходный текст |
Ответы |
Re: [repost] pg_restore doesn't work with custom format?
|
Список | pgsql-admin |
This looks like a bug, or can somebody explain how I'm supposed to restore a custom archive dump? $ createdb foo CREATE DATABASE $ psql foo foo=# create table users (id serial); NOTICE: CREATE TABLE will create implicit sequence 'users_id_seq' for SERIAL column 'users.id' NOTICE: CREATE TABLE/UNIQUE will create implicit index 'users_id_key' for table 'users' CREATE foo=# \q $ pg_dump --blobs --clean --create --file=/tmp/foo.dump --format=c --compress=9 foo $ dropdb foo DROP DATABASE $ pg_restore --create -d test /tmp/foo.dump Archiver(db): Could not execute query. Code = 7. Explanation from backend: 'ERROR: ProcedureCreate: procedure pltcl_call_handler already exists with same arguments '. $ pg_restore --create --clean -d test /tmp/foo.dump Archiver(db): Could not execute query. Code = 7. Explanation from backend: 'ERROR: index "users_id_key" does not exist '. What's the magic command that I am looking for?? Allan
В списке pgsql-admin по дате отправления: