From: | Maarten Boekhold <maartenb(at)dutepp2(dot)et(dot)tudelft(dot)nl> |
---|---|
To: | Jeffrey Napolitano <jnapoli(at)setech(dot)com> |
Cc: | General Questions for PostgreSQL <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] Moving Databases |
Date: | 1998-07-10 07:51:34 |
Message-ID: | Pine.SUN.3.91.980710095006.18023A-100000@dutepp2.et.tudelft.nl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | Sferacarta Software | 1998-07-10 10:38:18 | Re: [GENERAL] What to do with no foreign keys |
Previous Message | Brian | 1998-07-10 03:32:11 | Re: [GENERAL] Triggers: options besides compiled code? |