pg_dump'ed file contains "DROP DATABASE"
От | pf@pfortin.com |
---|---|
Тема | pg_dump'ed file contains "DROP DATABASE" |
Дата | |
Msg-id | 20230220132705.3a81a48f.pfortin@pfortin.com обсуждение исходный текст |
Ответы |
Re: pg_dump'ed file contains "DROP DATABASE"
Re: pg_dump'ed file contains "DROP DATABASE" |
Список | pgsql-general |
[Still a newbie; but learning fast...] Hi, A remote team member is helping out by dumping some of his tables via pgAdmin4 on Windows. My DB is on Linux. The other day, I restored his first file with: pg_restore --host "localhost" --port "5432" --username "postgres" --no-password --dbname "myname" --create --clean --verbose "dumpfile" when I saw this: pg_restore: dropping DATABASE myname Command was: DROP DATABASE myname; pg_restore: error: could not execute query: ERROR: cannot drop the currently open database Digging into the pg_dump'ed files, I see: CREATE DATABASE myname WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE_PROVIDER = libc LOCALE = 'English_United States.1252'; DROP DATABASE myname; ^^^^^^^^^^^^^^^^^^^^^ Was my 134 table[1] myname DB saved because it was open? If the dump file contains the above statements, how can I be absolutely certain I won't lose the DB? I'm obviously quite paranoid now... [1] 3 types of tables: ~40%=8.5M rows; ~40%=33M rows; ~20%=varying sizes Thanks, Pierre
В списке pgsql-general по дате отправления: