Postgres Pro
Downloads
Home   >   mailing lists

Thread: pg_dump

pg_dump

From
Dipankar Chakrabarti
Date:
Is it possible to do hot backup in PostgreSQL, i.e. is
it possible to issue pg_dump or pg_dump_all when the
databse is up and databse activities are going on?

I am trying to give a facility to dbAdmin through GUI
to perform backup-recovery online.

Need info.

Dipankar
===

DIPANKAR CHAKRABARTI
Have a Nice Time............
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

Re: [SQL] pg_dump

From
Bruce Momjian
Date:
> 
> Is it possible to do hot backup in PostgreSQL, i.e. is
> it possible to issue pg_dump or pg_dump_all when the
> databse is up and databse activities are going on?
> 
> I am trying to give a facility to dbAdmin through GUI
> to perform backup-recovery online.
> 

In 6.5, yes!

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026

replication

From
Fabio Silvestri
Date:
How can i do replication with postgres databases?
-- 
Veja tudo, aprenda tudo, naum toque em nada !

|o Fabio Silvestri
|o fabio@informatec.com.br
|o Informatec Informatica Ltda.
|o ICQ: 1667351
|o http://www.informatec.com.br
|o Tubarao - Santa Catarina - Brazil
|o +55 48 6264161
|o                  _   _   _   _   _   /`-'`-'
|o _   _   _   _   / `-' `-' `-' `-' `-'
`-' `-' `-' `-' `-'
" Linux on the other hand takes the best from both  worlds:
System V (AT&T/East Coast) and BSD (Berkeley/West Coast). "

Remember: "Time is the best teacher; Unfortunately it kills all its
students!"