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: 2008-04-29 17:19:50
Message-ID: 20080429171950.GF5652@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

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

In response to

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Arturo 2008-04-29 17:27:26 Sumar columnas calculadas
Previous Message Daniel Ferrer 2008-04-29 17:16:58 RE: CRON BACKUP