Re: restoring database

Поиск
Список
Период
Сортировка
От Theodore Petrosky
Тема Re: restoring database
Дата
Msg-id 20031222164352.28683.qmail@web41006.mail.yahoo.com
обсуждение исходный текст
Ответ на restoring database  (Lucas Lain <lainl@aconectarse.com>)
Ответы Re: restoring database  ("scott.marlowe" <scott.marlowe@ihs.com>)
Список pgsql-sql
As I am not someone with a lot of experience....
(depending on the size of the 'dumpall') I would
create a new database to suck up the 'all' then
pg_dump the table I really cared about. 

Obviously, if the dump_all is a terabyte database this
method is inconvenient.... (to say the least).

However it will work.

Ted

--- Lucas Lain <lainl@aconectarse.com> wrote:
> Hi everybody ... i need to restore only one database
> from a pg_dumpall backup 
> file... how can i do it?
> 
> Thanks a lot !
> 
> ---------------------------(end of
> broadcast)---------------------------
> TIP 8: explain analyze is your friend

__________________________________
Do you Yahoo!?
New Yahoo! Photos - easier uploading and sharing.
http://photos.yahoo.com/


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

Предыдущее
От: Lucas Lain
Дата:
Сообщение: restoring database
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: restoring database