Thread: Rép. : Re: [HACKERS] Hot Backup

Rép. : Re: [HACKERS] Hot Backup

From
"Erwan DUROSELLE"
Date:
What I understood from the Administrator's guide is:

  - Yes, PostgreSQL provides hot backup: it's the pg_dump utility. It'h hot because users can still be connected and
workwhil pg_dump is running ( though they will be slowed down). ( See Administrator's guide ch9) 

 -  No, PostgreSQL does NOT provide a way to restore a database up to the last commited transaction, with a reapply of
theWAL, as Oracle or SQL Server ( and others, I guess) do. That would be a VERY good feature. See Administrator's guide
ch11

So, with Pg, if you backup your db every night with pg_dump, and your server crashes during the day, you will loose up
toone day of work. 

Am I true?

Erwan


-------------------------------------------------------------------------------
Erwan DUROSELLE    //    SEAFRANCE DSI
Responsable Bases de Données  //  Databases Manager
Tel: +33 (0)1 55 31 59 70    //    Fax: +33 (0)1 55 31 85 28
email: eduroselle@seafrance.fr
-------------------------------------------------------------------------------


>>> Neil Conway <neilc@samurai.com> 07/10/2002 19:48 >>>
"Sandeep Chadha" <sandeep@newnetco.com> writes:
> Postgresql has been lacking this all along. I've installed postgres
> 7.3b2 and still don't see any archive's flushed to any other
> place. Please let me know how is hot backup procedure implemented in
> current 7.3 beta(2) release.

AFAIK no such hot backup feature has been implemented for 7.3 -- you
appear to have been misinformed.

That said, I agree that would be a good feature to have.

Cheers,

Neil

--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org