[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 x110On 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