Re: [urgent]need help transferring database to another server

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-general(at)postgresql(dot)org
Cc: Andrew Sullivan <andrew(at)libertyrms(dot)info>
Subject: Re: [urgent]need help transferring database to another server
Date: 2003-02-25 15:02:49
Message-ID: 20030225100249.C23754@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kolus Maximiliano 2003-02-25 15:09:21 Re: how do i avoid multiple sessions from inserting the
Previous Message Tom Lane 2003-02-25 15:02:16 Re: reindex