Re: [GENERAL] Moving Postgres Database

2006-05-31 Thread Tom Lane
Chris <[EMAIL PROTECTED]> writes: > Jim Nasby wrote: >> Actually, as long as you're not changing major versions (ie: 8.0.x to >> 8.1.x) you'll be fine. > I wasn't sure if changes like 8.1.x to 8.1.4 would cause a problem here: We have a project policy that we *never* force initdb in a minor rel

Re: [GENERAL] Moving Postgres Database

2006-05-31 Thread Chris
Jim Nasby wrote: On May 31, 2006, at 9:18 PM, Chris wrote: Edward Coyle wrote: I want to move a windows server 2003 based postgres database from one server to another server, can I just copy and paste the base folder or do I have to do a backup and restore? If so what options work best for cr

Re: [GENERAL] Moving Postgres Database

2006-05-31 Thread Bruno Wolff III
On Wed, May 31, 2006 at 15:34:46 -0500, Edward Coyle <[EMAIL PROTECTED]> wrote: > I want to move a windows server 2003 based postgres database from one server > to another server, can I just copy and paste the base folder or do I have to > do a backup and restore? If so what options work best for

Re: [GENERAL] Moving Postgres Database

2006-05-31 Thread Jim Nasby
On May 31, 2006, at 9:18 PM, Chris wrote: Edward Coyle wrote: I want to move a windows server 2003 based postgres database from one server to another server, can I just copy and paste the base folder or do I have to do a backup and restore? If so what options work best for creating a file t

Re: [GENERAL] Moving Postgres Database

2006-05-31 Thread Chris
Edward Coyle wrote: I want to move a windows server 2003 based postgres database from one server to another server, can I just copy and paste the base folder or do I have to do a backup and restore? If so what options work best for creating a file to move? I think if you shut down postgresql

[GENERAL] Moving Postgres Database

2006-05-31 Thread Edward Coyle
I want to move a windows server 2003 based postgres database from one server to another server, can I just copy and paste the base folder or do I have to do a backup and restore? If so what options work best for creating a file to move?   Edward Coyle Intellecare, Inc. Phone-972-919-900