Re: Reload only specific databases from pg_dumpall

From: Guido Neitzer <lists(at)event-s(dot)net>
To: Gurjeet Singh <singh(dot)gurjeet(at)gmail(dot)com>
Cc: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Reload only specific databases from pg_dumpall
Date: 2008-02-05 01:10:54
Message-ID: D08A9C57-D4F8-4A2F-BDD4-7E110C9FD869@event-s.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 04.02.2008, at 18:00, Gurjeet Singh wrote:

> I understand it all needs a little bit of 'vi' wizardry, (or
> whichever editor you are using). Also, as with all open-source
> suggestions, do not rely on this procedure until you understand what
> and how it does what it does.

Sure, the only problem is, I'm talking about a laaaarge file. Maybe I
just import the whole bunch and drop some of the databases after that.
Seems to be less hazzle, but takes probably an hour or two longer, so
I'll take a service window next night ...

Thanks for the hints.

cug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-02-05 01:24:41 Re: Universal libpq.a ?
Previous Message Gurjeet Singh 2008-02-05 01:00:46 Re: Reload only specific databases from pg_dumpall