From: | "Gurjeet Singh" <singh(dot)gurjeet(at)gmail(dot)com> |
---|---|
To: | "Guido Neitzer" <lists(at)event-s(dot)net> |
Cc: | "Postgresql General" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Reload only specific databases from pg_dumpall |
Date: | 2008-02-05 01:37:44 |
Message-ID: | 65937bea0802041737p6aec30dfhf141468fa719dacc@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Well... I assumed that'd be the case; production dumps are not small... this
calls for some scripting stuff; the script should basically the steps
mentioned above, and you will have a trimmed down version of the dump
file... :)
But again, the script should be fast enough to make this additional step
look smaller than the time required to restore+drop unwanted DBs.
Best regards,
On Feb 4, 2008 5:10 PM, Guido Neitzer <lists(at)event-s(dot)net> wrote:
> 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
>
--
gurjeet[(dot)singh](at)EnterpriseDB(dot)com
singh(dot)gurjeet(at){ gmail | hotmail | indiatimes | yahoo }.com
EnterpriseDB http://www.enterprisedb.com
17° 29' 34.37"N, 78° 30' 59.76"E - Hyderabad
18° 32' 57.25"N, 73° 56' 25.42"E - Pune
37° 47' 19.72"N, 122° 24' 1.69" W - San Francisco *
Mail sent from my BlackLaptop device
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Marlowe | 2008-02-05 02:03:52 | Re: Reload only specific databases from pg_dumpall |
Previous Message | Devrim GÜNDÜZ | 2008-02-05 01:30:19 | PostgreSQL 8.3.0 RPMs are available for download |