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

Re: Production Backup and Recovery

From: "John Moore" <NOSPAMnews(at)NOSPAMtinyvital(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Production Backup and Recovery
Date: 2001-07-02 22:23:43
Message-ID: Pv607.11379$ck5.1203016@newsread2.prod.itd.earthlink.net (view raw or flat)
Thread:
Lists: pgsql-hackers
"Doug McNaught" <doug(at)wireboard(dot)com> wrote in message
news:m38zi7dyfl(dot)fsf(at)belphigor(dot)mcnaught(dot)org(dot)(dot)(dot)
> "P. Dwayne Miller" <dmiller(at)espgroup(dot)net> writes:
>
> > Is it documented somewhere how to do on-line backups and then how to
> > recover from some event using those backups with no (or minimum) loss of
> > data?
>
> Right now there is no PIT recovery.  All you can do is run pg_dump
> whenever you want to make a backup.  This  will take a consistent
> snapshot of the database and write it out as SQL code that will
> recreate the database..

By consistent... does that mean that committed transactions are completely
there, and uncommitted are not there at all?





In response to

pgsql-hackers by date

Next:From: Alex PilosovDate: 2001-07-02 22:31:50
Subject: selecting from cursor
Previous:From: Alex PilosovDate: 2001-07-02 21:27:37
Subject: Re: Re: New data type: uniqueidentifier

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