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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: pg_reload_conf()
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump'ed file contains "DROP DATABASE"