Re: Copy the database..

Поиск
Список
Период
Сортировка
От Julio Cesar Sánchez González
Тема Re: Copy the database..
Дата
Msg-id 1194175469.10940.3.camel@andromeda.gateway.2wire.net
обсуждение исходный текст
Ответ на Re: Copy the database..  (Rainer Bauer <usenet@munnin.com>)
Список 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@postgresql.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/



В списке pgsql-general по дате отправления:

Предыдущее
От: Reg Me Please
Дата:
Сообщение: COPY ... FROM and index usage
Следующее
От: mgainty@hotmail.com
Дата:
Сообщение: Re: What makes a Postgres DBA?