pg_restore to new database wants to wipe out the old database?
| От | Ron |
|---|---|
| Тема | pg_restore to new database wants to wipe out the old database? |
| Дата | |
| Msg-id | 4a6e3243-7fcd-e7b3-4279-ce57bc5cf5ac@gmail.com обсуждение исходный текст |
| Ответы |
Re: pg_restore to new database wants to wipe out the old database?
|
| Список | pgsql-general |
Hi,
v9.6.9
Why is pg_restore trying to drop my production database, when I (think I) am telling it to create the new database "Molson"?
$ cd /backup
$ pg_dump -d proddb -j 8 -Fd --no-synchronized-snapshots -Z0 -v -f proddb 2> proddb_pgdump.log
$ mv proddb Molson
$ pg_restore -vcC --if-exists --jobs=8 -d postgres Molson
pg_restore: connecting to database for restore
pg_restore: dropping DATABASE proddb
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 145485; 1262 16385 DATABASE proddb TAP
pg_restore: [archiver (db)] could not execute query: ERROR: database "proddb" is being accessed by other users
DETAIL: There are 3 other sessions using the database.
Command was: DROP DATABASE IF EXISTS "proddb";
pg_restore: processing item 145482 ENCODING ENCODING
pg_restore: processing item 145483 STDSTRINGS STDSTRINGS
pg_restore: processing item 145484 SEARCHPATH SEARCHPATH
pg_restore: processing item 145485 DATABASE proddb
pg_restore: creating DATABASE "proddb"
pg_restore: [archiver (db)] could not execute query: ERROR: database "proddb" already exists
Command was: CREATE DATABASE "proddb" WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';
Thanks
v9.6.9
Why is pg_restore trying to drop my production database, when I (think I) am telling it to create the new database "Molson"?
$ cd /backup
$ pg_dump -d proddb -j 8 -Fd --no-synchronized-snapshots -Z0 -v -f proddb 2> proddb_pgdump.log
$ mv proddb Molson
$ pg_restore -vcC --if-exists --jobs=8 -d postgres Molson
pg_restore: connecting to database for restore
pg_restore: dropping DATABASE proddb
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 145485; 1262 16385 DATABASE proddb TAP
pg_restore: [archiver (db)] could not execute query: ERROR: database "proddb" is being accessed by other users
DETAIL: There are 3 other sessions using the database.
Command was: DROP DATABASE IF EXISTS "proddb";
pg_restore: processing item 145482 ENCODING ENCODING
pg_restore: processing item 145483 STDSTRINGS STDSTRINGS
pg_restore: processing item 145484 SEARCHPATH SEARCHPATH
pg_restore: processing item 145485 DATABASE proddb
pg_restore: creating DATABASE "proddb"
pg_restore: [archiver (db)] could not execute query: ERROR: database "proddb" already exists
Command was: CREATE DATABASE "proddb" WITH TEMPLATE = template0 ENCODING = 'UTF8' LC_COLLATE = 'en_US.UTF-8' LC_CTYPE = 'en_US.UTF-8';
--
Angular momentum makes the world go 'round.
Angular momentum makes the world go 'round.
В списке pgsql-general по дате отправления: