pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: scott.marlowe <scott.marlowe@ihs.com>
To: Theodore Petrosky <tedpet5@yahoo.com>
Cc: Lucas Lain <lainl@aconectarse.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: restoring database
Date: Mon, 22 Dec 2003 10:53:23 -0700 (MST)
Message-ID: <Pine.LNX.4.33.0312221052260.30417-100000@css120.ihs.com> (raw)
In-Reply-To: <20031222164352.28683.qmail@web41006.mail.yahoo.com>

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.




view thread (5+ messages)  latest in thread

Message-ID: <Pine.LNX.4.33.0312221052260.30417-100000@css120.ihs.com>
Permalink:  ../Pine.LNX.4.33.0312221052260.30417-100000@css120.ihs.com/
Also on:    postgresql.org/message-id/Pine.LNX.4.33.0312221052260.30417-100000@css120.ihs.com

 · 

reply

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: scott.marlowe@ihs.com, tedpet5@yahoo.com, lainl@aconectarse.com
  Subject: Re: restoring database
  In-Reply-To: <Pine.LNX.4.33.0312221052260.30417-100000@css120.ihs.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