From: | Julio Cesar Sánchez González <knowhow(at)sistemasyconectividad(dot)com(dot)mx> |
---|---|
To: | Rainer Bauer <usenet(at)munnin(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Copy the database.. |
Date: | 2007-11-04 11:24:29 |
Message-ID: | 1194175469.10940.3.camel@andromeda.gateway.2wire.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
El dom, 04-11-2007 a las 02:16 +0100, Rainer Bauer escribió:
> Abandoned wrote:
>
> >I tryed pg_dump but it is very slowly. Are there any faster way to
> >copy database?
>
> Actually, I was looking for something along the same line.
>
> I often want to test some functionality in my program based on the same
> dataset. However, dump/restore takes too long to be of any use.
>
> Wouldn't it be possible to copy the database folder and somehow instruct the
> postmaster to include the copied data after a restart?
>
> Rainer
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
Hi for all,
Try with de PITR
(http://www.postgresql.org/docs/8.1/static/backup-online.html) should
be help you...
--
Regards,
Julio Cesar Sánchez González.
--
Ahora me he convertido en la muerte, destructora de mundos.
Soy la Muerte que se lleva todo, la fuente de las cosas que vendran.
www.sistemasyconectividad.com.mx http://darkavngr.blogspot.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Tolley | 2007-11-04 13:59:10 | Re: COPY ... FROM and index usage |
Previous Message | Reg Me Please | 2007-11-04 10:22:19 | COPY ... FROM and index usage |