Re: Q: extract database name from directory dump

Поиск
Список
Период
Сортировка
От Melvin Davidson
Тема Re: Q: extract database name from directory dump
Дата
Msg-id CANu8FizFs954oSf1xUdTu_94EwBreXH7esUkJDFY=5eHx_cRcQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Q: extract database name from directory dump  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Ответы Re: Q: extract database name from directory dump  (Karsten Hilbert <Karsten.Hilbert@gmx.net>)
Список pgsql-general
hmmm, let's see. You haven't specified PostgreSQL version or O/S as is common sense and courtesy, so I will choose one for you.

You are using PostgreSQL version 8.4 on Ubuntu 14.04
Since pg_dump requires an output file, and the database you are dumping must be known, just just the db name in the path.
eg: pg_dump unknown_db > /dumpdir/unknown_db/whatever_filename_you_want.dmp

Then you can get the db name by lookiing at the directory you dumped to! At least that is what most dba's would do.

В списке pgsql-general по дате отправления:

Предыдущее
От: Karsten Hilbert
Дата:
Сообщение: Re: Q: extract database name from directory dump
Следующее
От: Karsten Hilbert
Дата:
Сообщение: Re: Q: extract database name from directory dump