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
--
Angular momentum makes the world go 'round.
