Re: copy data between database

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Qingqing Zhou <zhouqq(at)cs(dot)toronto(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: copy data between database
Date: 2005-10-10 19:03:02
Message-ID: 1128970981.29961.74.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 2005-10-10 at 13:53, Qingqing Zhou wrote:
> "Scott Marlowe" <smarlowe(at)g2switchworks(dot)com> wrote
> >
> > Under no circumstances should you do this with a database that has any
> > data in it that you value. pg_dump / pg_restore / psql are the
> > preferred way of doing this.
> >
>
> Oh yeah, sorry for the miss leading information. My method is dangerous and
> can not cover all the cases (say you have an external stored column, etc).
>
> Sorry about it,
> Qingqing

No need to apologize. I do that same kind of thing all the time. Just
not on production servers is all.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Chris Browne 2005-10-10 19:06:24 Re: Oracle buys Innobase
Previous Message Qingqing Zhou 2005-10-10 18:53:18 Re: copy data between database