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

Re: pg_dump y pg_restore

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Oscar Argueta <oscar(dot)argueta(at)transtel(dot)com(dot)gt>
Cc: Ayuda <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Re: pg_dump y pg_restore
Date: 2008-07-11 18:38:22
Message-ID: 20080711183822.GD4166@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
Oscar Argueta wrote:
> <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
> <html>
> <head>
>   <meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1">
>   <title></title>
> </head>
> <body text="#000000" bgcolor="#ffffff">
> Te comento, que por lo inexperto para realizar manteinimiento a bases
> de datos, en una ocasion corrimos VACUUM a una DB en produccion y
> provoco desintegracion en los datos, por eso ahora realizo
> rudimentariamente en la noche cada 3 meses un DUMP -&gt; DROP -&gt;
> CREATE -&gt; RESTORE.<br>

Eso lo explica todo.  Vacuum no es opcional.  Lee esto

http://www.postgresql.org/docs/8.3/static/maintenance.html

Por favor no escribas en HTML, y asegurate de tener siempre a la lista
en CC:.

-- 
Alvaro Herrera                  http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"The important things in the world are problems with society that we don't
understand at all. The machines will become more complicated but they won't
be more complicated than the societies that run them."    (Freeman Dyson)

In response to

Responses

pgsql-es-ayuda by date

Next:From: Fabio AriasDate: 2008-07-11 19:00:12
Subject: ERROR EN COMPILACION FUNCTION
Previous:From: Alvaro HerreraDate: 2008-07-11 17:50:15
Subject: Re: pg_dump y pg_restore

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group