Re: Move a database from one server to other

Поиск
Список
Период
Сортировка
От ptjm@interlog.com (Patrick TJ McPhee)
Тема Re: Move a database from one server to other
Дата
Msg-id 138139q27gemo9e@corp.supernews.com
обсуждение исходный текст
Ответ на Move a database from one server to other  (Adrián Ribao Martínez <aribao@gmail.com>)
Список pgsql-general
In article <24916.62.244.190.66.1182786241.squirrel@www.chuckie.co.uk>,
Nicholas Barr <nicky@chuckie.co.uk> wrote:

% Only copy the data directory if both servers are offline and not running
% and if both servers use the same version of postgres. This method is not
% recommended AFAIK.

It _is_ recommended for setting up a warm-standby server (it's the only way).

I copy database clusters around all the time. If the database is shut down,
there's no harm in it and it's usually faster and always simpler than
dump/restore. Copying a snapshot of a running system only has a teenly
little bit of harm in it and you don't even have to shut down the db.
--

Patrick TJ McPhee
North York  Canada
ptjm@interlog.com

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Interval overflow?
Следующее
От: don romanos
Дата:
Сообщение: ...