Thread: [urgent]need help transferring database to another server
our postgres server died yesterday and i need to retrieve the data from that server to another one. the server was running postgres 6.5 and i need to move it to another server also using postgres 6.5. i am unable to do a pg_dumpall for some reason, so i was wondering if i copy the data directory from server to another, will the new server be able to read the data and i can dump the data? any help would be appreciated. Peter Choe
On Tue, Feb 25, 2003 at 08:12:50AM -0500, Peter Choe wrote:
> i am unable to do a pg_dumpall for some reason, so i was wondering if i
> copy the data directory from server to another, will the new server be able
> to read the data and i can dump the data?
It _should_ work.
Note, however, that pre-WAL versions of PostgreSQL are not really
crash safe. There is a possibility that your data is in an
inconsistent state.
Are you _really_ stuck with 6.5? I'd strongly suggest you
investigate upgrading after you recover your data, if you can.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110
On Tue, Feb 25, 2003 at 08:35:47AM -0500, Andrew Sullivan wrote:
> On Tue, Feb 25, 2003 at 08:12:50AM -0500, Peter Choe wrote:
> > copy the data directory from server to another, will the new server be able
> > to read the data and i can dump the data?
>
> It _should_ work.
I should have qualified that: assuming the endian-ness and other such
attributes of the systems are the same. You can't do that from, say,
Linux to Solaris. Your best bet is to go to a system as similar as
possible.
A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110