Thread: PostgreSQL Database Transfer between machines

PostgreSQL Database Transfer between machines

From
"Brian J. Erickson"
Date:
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?

Brian



Re: PostgreSQL Database Transfer between machines

From
Chris Browne
Date:
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/>