Re: Large Database Restore - Mailing list pgsql-general

From Ron Johnson
Subject Re: Large Database Restore
Date
Msg-id 464CDD02.4060403@cox.net
Whole thread Raw
In response to Re: Large Database Restore  ("Michael Nolan" <htfoot@gmail.com>)
Responses Re: Large Database Restore
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 05/17/07 16:49, Michael Nolan wrote:
> I don't know if my database is typical (as there probably is no such
> thing), but to restore a full dump (pg_dumpall) takes over 4 hours on my
> backup server, but to restore a low level backup (about 35GB)

Meaning a tarball of $PGDATA?

>                                                               and then
> process 145 WAL files (since Tuesday morning when the last low level
> backup was run) took me around 2 hours today

- --
Ron Johnson, Jr.
Jefferson LA  USA

Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFGTN0BS9HxQb37XmcRArY4AKCzTzoe2XP1COyjpdWD+wGp5ACYoACfd9fx
336CjyTBXkgu/lXZewagcOA=
=+/58
-----END PGP SIGNATURE-----

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: 8.0, UTF8, and CLIENT_ENCODING
Next
From: "Robert James"
Date:
Subject: Privs on deleted objects