Re: Recover by Log

Lists: pgsql-general
From: "T(dot)J(dot) Adami" <adamitj(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Recover by Log
Date: 2008-01-31 16:02:20
Message-ID: 34bbebe5-7fcd-4a8c-9186-7e21d76332c1@e10g2000prf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

How I can recover data (or replicate data to another) based on
postgresql logs?
Where they are, and how I do it?


From: Erik Jones <erik(at)myemma(dot)com>
To: T(dot)J(dot) Adami <adamitj(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Recover by Log
Date: 2008-01-31 19:26:24
Message-ID: 9361E38D-9D44-45B6-8BCA-E9F97B5416A8@myemma.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-general

On Jan 31, 2008, at 10:02 AM, T.J. Adami wrote:

> How I can recover data (or replicate data to another) based on
> postgresql logs?
> Where they are, and how I do it?

See the chapters 23, 24 and 27 (at least) of the manual. For one
example of the process once you've read through all of that, see my
response just now to Steve Clark's question about warm standby servers.

Erik Jones

DBA | Emma®
erik(at)myemma(dot)com
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com