From: | pf(at)pfortin(dot)com |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | pg_dump'ed file contains "DROP DATABASE" |
Date: | 2023-02-20 18:27:05 |
Message-ID: | 20230220132705.3a81a48f.pfortin@pfortin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2023-02-20 18:35:57 | Re: pg_dump'ed file contains "DROP DATABASE" |
Previous Message | David G. Johnston | 2023-02-20 17:21:00 | Re: pg_reload_conf() |