From: | Chris Browne <cbbrowne(at)acm(dot)org> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PostgreSQL Database Transfer between machines |
Date: | 2006-10-03 17:15:53 |
Message-ID: | 60mz8dgw1i.fsf@dba2.int.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
ericksbr(at)infocon-inc(dot)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/>
From | Date | Subject | |
---|---|---|---|
Next Message | shakahshakah@gmail.com | 2006-10-03 18:50:10 | Re: rule for inserting into partitions |
Previous Message | Tom Lane | 2006-10-03 16:43:49 | Re: memory issues when running with mod_perl |