Re: Incremental Refresh - PostgreSQL 9.2

Поиск
Список
Период
Сортировка
От drum.lucas@gmail.com
Тема Re: Incremental Refresh - PostgreSQL 9.2
Дата
Msg-id CAE_gQfXDYSJBZppMW2T8HNF1-K2dPfsg8aOz0g_73GfCgmu6UA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Incremental Refresh - PostgreSQL 9.2  ("David G. Johnston" <david.g.johnston@gmail.com>)
Список pgsql-admin

​You cannot accomplish incremental updates if your choice of tool is pg_dump.  The only way to do a true incremental would be to rely upon something like rsync on the data directory while the master server is offline.

So, assuming that is not an option, you should probably look at the various true replication solutions that are available and see which of those might serve as an alternative.

​David J.


The point is: I don't want a slave server - I want a full copy from my MASTER server.

So replication wouldn't be a nice solution...


Can I do a rsync from /data folder from my SLAVE into my TEST server?
To do that, both postgres process should be stopped, right?

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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Incremental Refresh - PostgreSQL 9.2
Следующее
От: Scott Whitney
Дата:
Сообщение: Re: Incremental Refresh - PostgreSQL 9.2