From: | Chris Johnson <cmj(at)inline-design(dot)com> |
---|---|
To: | M(dot)Boekhold(at)et(dot)tudelft(dot)nl |
Cc: | Jeffrey Napolitano <jnapoli(at)setech(dot)com>, General Questions for PostgreSQL <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] Moving Databases |
Date: | 1998-07-13 14:10:48 |
Message-ID: | Pine.LNX.4.00.9807131009140.23712-100000@boreus.bedfo.ma.tiac.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
If you can access postgres on the second machine from the first (ie on
machine a you can type "psql -h b database" and properly issue queries)
you can just do the following from machine a
pg_dump database | psql -h b database
Chris
On Fri, 10 Jul 1998, Maarten Boekhold wrote:
> On Thu, 9 Jul 1998, Jeffrey Napolitano wrote:
>
> > I have two Postgresql databases - one on machine a, one on machine b.
> > Both are currently running. I want to put a copy of the database on a
> > onto machine b. I know I have to stop the postmaster (obviously) on
> > database b, but what else is there to do? Which directories do I have to
> > move (if that's what I have to do). Sorry - I know this is probably
> > simple, but I'm rushing to meet a deadline.
>
> On machine a:
>
> pg_dump database > db.out
>
> on machine b:
>
> cat db.out | psql template1
>
> (both as postgres superuser). Maybe you gave to create the database first
> on machine b.
>
> At least, I think this should work.... And no need to stop any postmasters..
>
> Maarten
>
> _____________________________________________________________________________
> | TU Delft, The Netherlands, Faculty of Information Technology and Systems |
> | Department of Electrical Engineering |
> | Computer Architecture and Digital Technique section |
> | M(dot)Boekhold(at)et(dot)tudelft(dot)nl |
> -----------------------------------------------------------------------------
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Joon Chung | 1998-07-13 15:47:55 | I am looking for an example about JDBC-postgreSQL usages. |
Previous Message | Pascal DAYRE | 1998-07-13 13:04:22 | liste generale PostgreSQL de diffusion |