From: | "Donald Catanzaro, PhD" <dgcatanzaro(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Moving postgresql data to another computer |
Date: | 2010-05-11 20:16:48 |
Message-ID: | 4BE9BB30.2000008@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Good Day All,
I am a newbie to PostgreSQL and I recently installed it on my desktop
(Windows XP) I created a database fine and worked a bunch of queries. I
am traveling now and I needed access to my database on my laptop
(Windows Vista). So before I left, I installed PosgreSQL on the laptop
and then copied the data in the PostgreSQL data directory over to my
laptop.
I put the data directory from my desktop in a different place on my
laptop and now I would like to access the data but I can not seem to
figure out how to do this.
I naively tried to just replace all the files in the data directory on
my laptop with the files from the data directory of the desktop but when
I do so, I get the following error: "could not connect to server:
Connection refused (0x0000274D/10061) Is the server running on host
"127.0.0.1" and accepting TCP/IP connections on port 5432? "
I figure I have at least two options
Option 1) Point PostgreSQL on laptop to the directory that desktop data
lives in
Option 2) Replace the data directory on the laptop with the data
directory that came from the desktop.
While I am travelling now (about a month) I eventually will want to move
my database BACK to the desktop so a solution that makes that transition
simple would be ideal.
I've tried searching the documentation, archives, and the FAQs but to no
avail. I either found it and did not understand how to do it or I could
not find it properly. Could someone point me in the correct direction ?
Thanks in advance !
-Don
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Broersma | 2010-05-11 20:44:32 | Re: Moving postgresql data to another computer |
Previous Message | Donald Catanzaro | 2010-05-11 20:00:38 | Moving postgresql data to another computer |