From: Theodore Petrosky <tedpet5@yahoo.com>
To: Lucas Lain <lainl@aconectarse.com>
To: pgsql-sql@postgresql.org
Subject: Re: restoring database
Date: Mon, 22 Dec 2003 08:43:52 -0800 (PST)
Message-ID: <20031222164352.28683.qmail@web41006.mail.yahoo.com> (raw)
In-Reply-To: <200312221158.48918.lainl@aconectarse.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tedpet5@yahoo.com, lainl@aconectarse.com
Subject: Re: restoring database
In-Reply-To: <20031222164352.28683.qmail@web41006.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox