Search Postgresql Archives

Re: PostgreSQL Database Transfer between machines

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



ericksbr@xxxxxxxxxxxxxxx ("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/>


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux