Re: [PLUG] postgres data loading

[sean finney <seanius@seanius.net>]

On Fri, Apr 02, 2010 at 02:53:54PM -0400, John Karr wrote:
> Any ideas on how to do this load faster? Normally this load would occur
> about once every 3 months, but in times peak activity it could be weekly and
> it wouldn't be acceptable to have the application down for a day for every
> load.

what postgres version?  8.3 or 8.4 offers PITR recovery which would probably
be the fastest way to replace one large dataset with another (think of it
like transferring a journalled version of the datadir between hosts).


	sean

Attachment: signature.asc
Description: Digital signature

___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug