Re: CRON BACKUP

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

Peripheral Links

Text Size: Normal / Large
Donate
Contact

Header And Logo

PostgreSQL

|

The world's most advanced open source database.

Site Navigation

Re: CRON BACKUP

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Daniel Ferrer <daniel(dot)ferrer(at)ctd(dot)com(dot)ar>
Cc: "'Fabio Arias'" <fharias(at)gmail(dot)com>, pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: CRON BACKUP
Date: Tue, 29 Apr 2008 13:19:50 -0400
Message-id: <20080429171950.GF5652@alvh.no-ip.org> <text/plain>

Daniel Ferrer escribió:

> su -l postgres -c "(pg_dump -D $d |gzip -9) > $archive" 

FWIW es harto mala idea usar pg_dump -D.  Restaurar esos respaldos es
mucho mas lento que un dump normal.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

References:
- RE: CRON BACKUP
  - From: Daniel Ferrer

Prev by Date: RE: CRON BACKUP
Next by Date: Sumar columnas calculadas
Previous by thread: RE: CRON BACKUP
Next by thread: Re: CRON BACKUP
Indexes:
- Main
- Thread

Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group