From: Markus Bertheau <twanger@bluetwanger.de>
To: scott.marlowe <scott.marlowe@ihs.com>
Cc: Theodore Petrosky <tedpet5@yahoo.com>
Cc: Lucas Lain <lainl@aconectarse.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: restoring database
Date: Tue, 23 Dec 2003 11:18:17 +0100
Message-ID: <1072174696.4901.0.camel@yarrow.bertheau.de> (raw)
In-Reply-To: <Pine.LNX.4.33.0312221052260.30417-100000@css120.ihs.com>
References: <Pine.LNX.4.33.0312221052260.30417-100000@css120.ihs.com>
В Пнд, 22.12.2003, в 18:53, scott.marlowe пишет:
> On Mon, 22 Dec 2003, Theodore Petrosky wrote:
>
> > 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.
>
> In the past I've used
>
> 'cat -n filename'|grep -4 database
>
> to find the starting points of individual databases etc... and then used
> split to break it into the exact right size pieces to do this.
That sounds like something pg_dump / pg_dumpall should be able to do
itself, don't you think?
--
Markus Bertheau <twanger@bluetwanger.de>
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: twanger@bluetwanger.de, scott.marlowe@ihs.com, tedpet5@yahoo.com, lainl@aconectarse.com
Subject: Re: restoring database
In-Reply-To: <1072174696.4901.0.camel@yarrow.bertheau.de>
* 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