Re: Need some help on PG database transfer

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: Steeles <steeles(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Need some help on PG database transfer
Date: 2010-07-22 20:13:01
Message-ID: AANLkTil7uzljDhGYpwe_ZuURo120PQ0cSYQ_ppZlHuM0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Jul 22, 2010 at 2:08 PM, Steeles <steeles(at)gmail(dot)com> wrote:
> Hi all,
>
> I am doing some tests on the file level copying for one of database in
> windows platform. Here is what I want to achieve.
>
> copy files within PG tablespace folder where PG database resides to target
> machine. I want to attache the copied data to target PG database.

That won't work. You have to pg_dump out the tables / tablespace and
then psql or pg_restore it to the other db.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Gary Fu 2010-07-22 21:03:29 psql problem
Previous Message Steeles 2010-07-22 20:08:06 Need some help on PG database transfer