Re: how to replicate database

Поиск
Список
Период
Сортировка
От Nigel J. Andrews
Тема Re: how to replicate database
Дата
Msg-id Pine.LNX.4.21.0309111354160.21912-100000@ponder.fairway2k.co.uk
обсуждение исходный текст
Ответ на how to replicate database  (Caroline Yong <tarabas1978@yahoo.com>)
Список pgsql-general
On Thu, 11 Sep 2003, Caroline Yong wrote:

> Is there a way to replicate one-off(a copy of
> duplicate) of an existing Postgres database.
>
> regards,
> caroline

There's obviously the pg_dump utility (or pg_dumpall which also gets all the
global info like db users). You could also try:

    createdb -T old-db new-db

as an interesting exercise, if you just want another copy in the same
cluster. I've not done that myself but I don't see why it wouldn't work,
someone else might know differently.

--
Nigel Andrews



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

Предыдущее
От: "Mattias Kregert"
Дата:
Сообщение: Re: I need a SQL...
Следующее
От: Bjørn T Johansen
Дата:
Сообщение: Re: I need a SQL...