PG_DUMP Question

Поиск
Список
Период
Сортировка
От Alex
Тема PG_DUMP Question
Дата
Msg-id 3F9FC3F3.2020509@meerkatsoft.com
обсуждение исходный текст
Список pgsql-admin
Hi,

I have a test system that is setup the same as a production system and
would like to frequently copy the database over.
pg_dump takes a few hours and even sometimes hangs.

Are there any reasons not to simply just copy the entire data directory
over to the test system? I could not find any postings on the net
suggesting otherwise. Is there anything to pay attention too ?

Thanks for any advise
Alex



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

Предыдущее
От: Gregg Lynch
Дата:
Сообщение: Employment Opportunity in San Jose, Ca
Следующее
От: Nathan Scott
Дата:
Сообщение: Re: [linux-lvm] RE: [PERFORM] backup/restore - another ar ea.