| From: | Theodore Petrosky <tedpet5(at)yahoo(dot)com> |
|---|---|
| To: | Lucas Lain <lainl(at)aconectarse(dot)com>, pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: restoring database |
| Date: | 2003-12-22 16:43:52 |
| Message-ID: | 20031222164352.28683.qmail@web41006.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)aconectarse(dot)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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2003-12-22 17:53:23 | Re: restoring database |
| Previous Message | Lucas Lain | 2003-12-22 14:58:48 | restoring database |