>
> "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.
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
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
@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
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
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.
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]
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