From: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
---|---|
To: | "Petr" <pjsoft(at)volny(dot)cz>, <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Detaching database |
Date: | 2005-12-28 01:06:46 |
Message-ID: | D425483C2C5C9F49B5B7A41F8944154757D3BE@postal.corporate.connx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
This sounds like a dangerous line to walk, to me.
If the schemas for the two database systems are diverging, then trying
to synchronize them is sure to have problems. I do not think that there
is any miracle cure (using PostgreSQL or any other database system).
If you know of a sure subset of tables that are guaranteed not to
change, then perhaps you can create a table by table script for those.
> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Petr
> Sent: Tuesday, December 27, 2005 4:00 PM
> To: pgsql-general(at)postgresql(dot)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_dump makes a SQL
script.
> Ok.
> It's nice, but when i'm trying to run this script on customer's
machine,
> then i have many errors, because any views are not in his database,
and
> script trying to drop it. When i'm set to don't make drop functions
(in
> export), then i have other errors, with existing views (view allready
> exists).
>
> Petr
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
From | Date | Subject | |
---|---|---|---|
Next Message | Florian G. Pflug | 2005-12-28 02:05:56 | Re: Adding columns to a view |
Previous Message | George Pavlov | 2005-12-28 01:04:05 | windows xp install problem ("failed to set permissions on the installed files...") |