Hello,
I have a fairly large DB to dump and restore as fast as possible. I'm moving
from 8.0.3 to 8.2.3! :)
I normally dump with these options:
-d MyDB --clean --inserts --column-inserts --format=P
But the last time I tried that, the restore took foreever. So I'm
looking for t
[EMAIL PROTECTED] wrote:
> Hello,
>
> I have a fairly large DB to dump and restore as fast as possible. I'm moving
> from 8.0.3 to 8.2.3! :)
>
> I normally dump with these options:
>
> -d MyDB --clean --inserts --column-inserts --format=P
>
> But the last time I tried that, the restore took
Consider leaving all indicies off until the load finishes...
Naomi
[EMAIL PROTECTED] wrote:
> Hello,
>
> I have a fairly large DB to dump and restore as fast as possible. I'm moving
> from 8.0.3 to 8.2.3! :)
>
> I normally dump with these options:
>
> -d MyDB --clean --inserts --column-insert
[EMAIL PROTECTED] writes:
> I normally dump with these options:
> -d MyDB --clean --inserts --column-inserts --format=P
> But the last time I tried that, the restore took foreever.
--inserts is pretty expensive.
> So I'm looking for the fastest way to import data from the old DB to
- Original Message
From: Tom Lane <[EMAIL PROTECTED]>
[EMAIL PROTECTED] writes:
> I normally dump with these options:
> -d MyDB --clean --inserts --column-inserts --format=P
> But the last time I tried that, the restore took foreever.
--inserts is pretty expensive.
OG: rig
[EMAIL PROTECTED] wrote:
> > -d MyDB --format=c --ignore-version
>
> Don't use --ignore-version; it's a good way to shoot yourself in the foot.
>
> OG: even when upgrading (8.0.3 -> 8.2.3)? I'll dump with pg_dump from 8.0.3
> and them import with pg_restore from the newly installed 8.2.3.
On 2/22/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Hello,
I have a fairly large DB to dump and restore as fast as possible. I'm moving
from 8.0.3 to 8.2.3! :)
I normally dump with these options:
-d MyDB --clean --inserts --column-inserts --format=P
But the last time I tried that, th
- Original Message
From: Marco Bizzarri <[EMAIL PROTECTED]>
Cc: pgsql-admin@postgresql.org
Sent: Thursday, February 22, 2007 3:47:37 PM
Subject: Re: [ADMIN] Fastest DB restore options
On 2/22/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I have a fa
If you are just looking for the least down time between stopping one server
and starting the new one you could try Slony see
http://gborg.postgresql.org/project/slony1/projdisplay.php
Regards,
Ben
<[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hello,
>
> I have a fairly large D