[ale] Speaking of Postgresql...

Geoffrey Myers lists at serioustechnology.com
Thu Sep 22 16:43:40 EDT 2011


Lightner, Jeff wrote:
> We had setup a couple of installs last year but never setup backup jobs 
> for them.
> 
>  
> 
> Does postgresql have a hot backup mode similar to Oracles wherein one 
> can backup files while the DB is still running?    (In Oracle this means 
> transactions are being logged rather than committed and then get 
> committed after it is taken out of hot backup mode.) 

check out pg_dump and pg_dumpall

Then check out pg_restore

What you mention above sounds like slony replication for postgresql.

> 
>  
> 
> If not how are people doing backups of their postgresql databases?   
> Shutting it down completely and backing up the filesystem?   Data dumps 
> and backing up the dumps?  Something similar to Oracle RMAN? 
> 
>  
> 
>   
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
>  
> 
> Proud partner. Susan G. Komen for the Cure.
> 
>  
> 
>  /Please consider our environment before printing this e-mail or 
> attachments./
> 
> ----------------------------------
> CONFIDENTIALITY NOTICE: This e-mail may contain privileged or 
> confidential information and is for the sole use of the intended 
> recipient(s). If you are not the intended recipient, any disclosure, 
> copying, distribution, or use of the contents of this information is 
> prohibited and may be unlawful. If you have received this electronic 
> transmission in error, please reply immediately to the sender that you 
> have received the message in error, and delete it. Thank you.
> ----------------------------------
> 
>  
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Ale mailing list
> Ale at ale.org
> http://mail.ale.org/mailman/listinfo/ale
> See JOBS, ANNOUNCE and SCHOOLS lists at
> http://mail.ale.org/mailman/listinfo


-- 
Until later, Geoffrey

"I predict future happiness for America if they can prevent
the government from wasting the labors of the people under
the pretense of taking care of them."
- Thomas Jefferson


More information about the Ale mailing list