Re: backup and recovery

From: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
To: "Amin" <achavarria(at)ilusion(dot)com(dot)mx>
Cc: <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Re: backup and recovery
Date: 2004-07-05 22:26:21
Message-ID: 200407051926.21851.martin@bugs.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

El Lun 05 Jul 2004 18:25, Amin escribió:
> como hago un backup y recovery en postgresql sobre linux red hat as 2.1

$ pg_dumpall > archivo-bu.sql
$ psql -d template1 -f archivo-bu.sql

--
19:25:01 up 11:02, 1 user, load average: 0.38, 0.47, 0.57
-----------------------------------------------------------------
Martín Marqués | select 'mmarques' || '@' || 'unl.edu.ar'
Centro de Telematica | DBA, Programador, Administrador
Universidad Nacional
del Litoral
-----------------------------------------------------------------

In response to

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Martin Marques 2004-07-05 22:27:31 Re: backup and recovery
Previous Message Alvaro Herrera 2004-07-05 22:00:25 Re: Rendimiento