| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | "Gregory S(dot) Williamson" <gsw(at)globexplorer(dot)com> |
| Cc: | Petr <pjsoft(at)volny(dot)cz>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Detaching database |
| Date: | 2005-12-29 07:32:01 |
| Message-ID: | 20051229073201.GB2815@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Dec 27, 2005 at 15:49:43 -0800,
"Gregory S. Williamson" <gsw(at)globexplorer(dot)com> wrote:
> Petr,
>
> As long as the new server is the same operating system, and the versions of postgres are the same, you can do a binary copy of the data directory and move it to the new machine, point the new server's postgres to the copied and data and start it up. Indexes, statistics, etc. all are intact and ready to go. On the negative side I think you need to idle the source database during the initial copy.
As a clarification, 'versions are the same' needs to be more strict than the
version number (e.g. 8.1.1) and should include the build options, as some
build options (notably --enable-integer-datetimes) change the format used
for data.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Browne | 2005-12-29 07:35:09 | Re: I want to know how to improve the security of postgresql |
| Previous Message | Matthew Hixson | 2005-12-29 07:23:34 | Re: importing an Oracle database into Postgres |