Re: How backup huge pgsql ?

I want to known how can I make backup of huge postgresql database (huge mean ~ 2To). I can stop the access of the database during N1 hours. Any idea about this ? I came around this particular problem by setting up a read only mirror of an Oracle instance using Oracle DataGuard. Of course

Re: How backup huge pgsql ?

I want to known how can I make backup of huge postgresql database (huge mean ~ 2To). I can stop the access of the database during N1 hours. Any idea about this ? pg_dump should work as usual. No need to stop database access since read-only access won't block anything else and it won't be

Re: How backup huge pgsql ?

On Thu, Jan 10, 2008 at 11:10:58PM +0100, Albert Shih wrote: Hi all I want to known how can I make backup of huge postgresql database (huge mean ~ 2To). I can stop the access of the database during N1 hours. Any idea about this ? Take a look at the PostgreSQL web site - they have a

How backup huge pgsql ?

Hi all I want to known how can I make backup of huge postgresql database (huge mean ~ 2To). I can stop the access of the database during N1 hours. Any idea about this ? Regards. -- Albert SHIH Observatoire de Paris Meudon SIO batiment 15 Heure local/Local time: Jeu 10 jan 2008 23:05:00 CET