PostgreSQL Database Transfer between machines

Started by Brian J. Ericksonover 19 years ago2 messagesgeneral
Jump to latest
#1Brian J. Erickson
ericksbr@infocon-inc.com

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

#2Chris Browne
cbbrowne@acm.org
In reply to: Brian J. Erickson (#1)
Re: PostgreSQL Database Transfer between machines

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/&gt;