Re: [GENERAL] Detaching database

2005-12-28 Thread Gregory S. Williamson
> > "Gregory S. Williamson" <[EMAIL PROTECTED]> wrote: > > Petr, > > > > As long as the new server is the same operating system, and the versions of > > postgres are the same, > <...> > > As a clarification, 'versions are the same' needs to be more strict than the > version number (e.g. 8.1.

Re: [GENERAL] Detaching database

2005-12-28 Thread Bruno Wolff III
On Tue, Dec 27, 2005 at 15:49:43 -0800, "Gregory S. Williamson" <[EMAIL PROTECTED]> 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

Re: [GENERAL] Detaching database

2005-12-28 Thread Martijn van Oosterhout
On Wed, Dec 28, 2005 at 01:00:27AM +0100, Petr wrote: > I'm try to explain my problems. My customer have Postgre server with any > older version of my DB (without any new or modified views, functions etc.) > and when i create export (in pgAdmin3), then pg_dump makes a SQL script. Ok. > It's nice, b

Re: [GENERAL] Detaching database

2005-12-27 Thread Dann Corbit
@postgresql.org > Subject: Re: [GENERAL] Detaching database > > OK. > > I'm try to explain my problems. My customer have Postgre server with any > older version of my DB (without any new or modified views, functions etc.) > and when i create export (in pgAdmin3), then pg_d

Re: [GENERAL] Detaching database

2005-12-27 Thread Petr
OK. I'm try to explain my problems. My customer have Postgre server with any older version of my DB (without any new or modified views, functions etc.) and when i create export (in pgAdmin3), then pg_dump makes a SQL script. Ok. It's nice, but when i'm trying to run this script on customer's machi

Re: [GENERAL] Detaching database

2005-12-27 Thread Gregory S. Williamson
t what you want, a bit more information about the problem might be of help. HTH, Greg Williamson -Original Message- From: [EMAIL PROTECTED] on behalf of Petr Sent: Tue 12/27/2005 3:39 PM To: pgsql-general@postgresql.org Cc: Subject: [GENERAL] Detaching database Hi.

Re: [GENERAL] Detaching database

2005-12-27 Thread Dann Corbit
very hard to say from the brief description of what you want. > -Original Message- > From: [EMAIL PROTECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] On Behalf Of Petr > Sent: Tuesday, December 27, 2005 3:40 PM > To: pgsql-general@postgresql.org > Subject: [GENERAL]

[GENERAL] Detaching database

2005-12-27 Thread Petr
Hi. Is any way how to detach complete database, and attach it into other Postgre server (like MSSQL, Interbase etc. databases movability) ? Moving database via SQL export is crazy way for me (and for my customers). Thanks and forgive me for my poor english. Petr ---(end