Re: PostgreSQL Database Transfer between machines - Mailing list pgsql-general

From Chris Browne
Subject Re: PostgreSQL Database Transfer between machines
Date
Msg-id 60mz8dgw1i.fsf@dba2.int.libertyrms.com
Whole thread Raw
In response to PostgreSQL Database Transfer between machines  ("Brian J. Erickson" <ericksbr@infocon-inc.com>)
List pgsql-general
ericksbr@infocon-inc.com ("Brian J. Erickson") writes:
> Problem:
> PostgreSQL "Service" is not runing on a Linux Box,
> but I have a database on the Linux Box, that I want
> to relocate to another machine, Windows or Linux.
>
> Question:
> What files do I need to transfer to get this to work?

The raw database files cannot be expected to be interoperable between
operating systems.

You'll need to dump the database (say, using pg_dump) and load that
into a database on the other machine.
--
(reverse (concatenate 'string "gro.mca" "@" "enworbbc"))
http://linuxdatabases.info/info/nonrdbms.html
Rules of  the Evil  Overlord #153.  "My Legions of  Terror will  be an
equal-opportunity employer. Conversely, when  it is prophesied that no
man  can defeat  me, I  will  keep in  mind the  increasing number  of
non-traditional gender roles." <http://www.eviloverlord.com/>

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: memory issues when running with mod_perl
Next
From: arsi@aranzo.netg.se
Date:
Subject: Need help with a function from hell..