Skip site navigation (1) Skip section navigation (2)

Re: PG equivalent of "mysqlhotcopy"?

From: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>
To: Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com>
Cc: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: PG equivalent of "mysqlhotcopy"?
Date: 2009-07-31 17:30:20
Message-ID: 418D70F0-298A-47B4-B991-6FB236D877B6@hi-media.com (view raw or flat)
Thread:
Lists: pgsql-general
Hi,

Le 30 juil. 09 à 15:34, Phoenix Kiula a écrit :
> I know about pg_dumpall, which creates a humongous SQL file, but is
> there something equivalent in the postgresql world, like a
> "pgsqlhotcopy" which copies data folders in a similar way as
> mysqlhotcopy?


Copying the raw data files of a live database only works under certain  
conditions with PostgreSQL, in short you have to tell it about what  
you're going to do for it to cooperate. That's pg_start_backup()  
function and friends.

Now, the generic technique provided by PostgreSQL is called PITR,  
Point In Time Recovery. You'll find ready to go software to drive  
this, in order of personal preference :

  - walmgr from Skytools
     http://wiki.postgresql.org/wiki/Skytools#walmgr
     http://skytools.projects.postgresql.org/doc/walmgr.html
     https://developer.skype.com/SkypeGarage/DbProjects/SkyTools/WalMgr

  - pitrtools
     http://projects.commandprompt.com/public/pitrtools/

  - pg_standby (read carefully the 8.3 era behavior of this one)
     it's in the contribs

Those 3 solutions are packaged in debian and maybe some other  
distributions or OS.

Regards,
-- 
dim

In response to

pgsql-general by date

Next:From: Raymond O'DonnellDate: 2009-07-31 17:45:58
Subject: Re: Limiting records in pg_dump
Previous:From: Oliver Kohll - Mailing ListsDate: 2009-07-31 17:27:41
Subject: Division by zero

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group