pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgreSQL file system based restore from Linux to Windows
6+ messages / 4 participants
[nested] [flat]
* PostgreSQL file system based restore from Linux to Windows
@ 2014-12-31 05:33 girish R G peetle <giri.anamika0@gmail.com>
2014-12-31 06:28 ` Re: PostgreSQL file system based restore from Linux to Windows Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 6+ messages in thread
From: girish R G peetle @ 2014-12-31 05:33 UTC (permalink / raw)
To: pgsql-admin
Hi all,
PostgreSQL file system based restore, ( copy database files from linux to
windows) from Linux to Windows is supported ?
I couldn't find any reference to this information in PostgreSQL
documentation.
Thanks
Girish
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL file system based restore from Linux to Windows
2014-12-31 05:33 PostgreSQL file system based restore from Linux to Windows girish R G peetle <giri.anamika0@gmail.com>
@ 2014-12-31 06:28 ` Tom Lane <tgl@sss.pgh.pa.us>
2014-12-31 09:12 ` Re: PostgreSQL file system based restore from Linux to Windows girish R G peetle <giri.anamika0@gmail.com>
2015-01-02 10:56 ` Re: PostgreSQL file system based restore from Linux to Windows Craig Ringer <craig@2ndquadrant.com>
0 siblings, 2 replies; 6+ messages in thread
From: Tom Lane @ 2014-12-31 06:28 UTC (permalink / raw)
To: girish R G peetle <giri.anamika0@gmail.com>; +Cc: pgsql-admin
girish R G peetle <giri.anamika0@gmail.com> writes:
> PostgreSQL file system based restore, ( copy database files from linux to
> windows) from Linux to Windows is supported ?
> I couldn't find any reference to this information in PostgreSQL
> documentation.
No. The general project policy is that data files are only compatible
across one platform, ie, one OS and machine architecture. (I'm pretty
sure this is stated somewhere in the docs, but am too tired to go
looking for chapter and verse.)
It might happen to work, if you're talking the same Intel-ish CPU type
on both ends ... but if it fails, don't call us.
regards, tom lane
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL file system based restore from Linux to Windows
2014-12-31 05:33 PostgreSQL file system based restore from Linux to Windows girish R G peetle <giri.anamika0@gmail.com>
2014-12-31 06:28 ` Re: PostgreSQL file system based restore from Linux to Windows Tom Lane <tgl@sss.pgh.pa.us>
@ 2014-12-31 09:12 ` girish R G peetle <giri.anamika0@gmail.com>
1 sibling, 0 replies; 6+ messages in thread
From: girish R G peetle @ 2014-12-31 09:12 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
Thanks a lot for the information Tom.
Thanks
Girish
On Wed, Dec 31, 2014 at 11:58 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> girish R G peetle <giri.anamika0@gmail.com> writes:
> > PostgreSQL file system based restore, ( copy database files from linux to
> > windows) from Linux to Windows is supported ?
> > I couldn't find any reference to this information in PostgreSQL
> > documentation.
>
> No. The general project policy is that data files are only compatible
> across one platform, ie, one OS and machine architecture. (I'm pretty
> sure this is stated somewhere in the docs, but am too tired to go
> looking for chapter and verse.)
>
> It might happen to work, if you're talking the same Intel-ish CPU type
> on both ends ... but if it fails, don't call us.
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL file system based restore from Linux to Windows
2014-12-31 05:33 PostgreSQL file system based restore from Linux to Windows girish R G peetle <giri.anamika0@gmail.com>
2014-12-31 06:28 ` Re: PostgreSQL file system based restore from Linux to Windows Tom Lane <tgl@sss.pgh.pa.us>
@ 2015-01-02 10:56 ` Craig Ringer <craig@2ndquadrant.com>
2015-01-02 16:54 ` Re: PostgreSQL file system based restore from Linux to Windows Bruce Momjian <bruce@momjian.us>
1 sibling, 1 reply; 6+ messages in thread
From: Craig Ringer @ 2015-01-02 10:56 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; girish R G peetle <giri.anamika0@gmail.com>; +Cc: pgsql-admin
On 12/31/2014 02:28 PM, Tom Lane wrote:
> It might happen to work, if you're talking the same Intel-ish CPU type
> on both ends ... but if it fails, don't call us.
It might for 32-bit, but I'm pretty sure it's not going to for 64-bit
because Windows is LLP64 and Linux is LP64, so sizeof(long) differs. See
http://en.wikipedia.org/wiki/64-bit_computing .
(Yet another area where Windows is annoyingly and pointlessly different,
like use of UTF16 instead of UTF-8, though at least there they have the
excuse of doing it first.)
Just use a Linux box or a virtual machine to start a copy of the
database, then pg_dump -Fc it and pg_restore to a new instance on the
Windows box.
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL file system based restore from Linux to Windows
2014-12-31 05:33 PostgreSQL file system based restore from Linux to Windows girish R G peetle <giri.anamika0@gmail.com>
2014-12-31 06:28 ` Re: PostgreSQL file system based restore from Linux to Windows Tom Lane <tgl@sss.pgh.pa.us>
2015-01-02 10:56 ` Re: PostgreSQL file system based restore from Linux to Windows Craig Ringer <craig@2ndquadrant.com>
@ 2015-01-02 16:54 ` Bruce Momjian <bruce@momjian.us>
0 siblings, 0 replies; 6+ messages in thread
From: Bruce Momjian @ 2015-01-02 16:54 UTC (permalink / raw)
To: Craig Ringer <craig@2ndquadrant.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; girish R G peetle <giri.anamika0@gmail.com>; pgsql-admin
On Fri, Jan 2, 2015 at 06:56:47PM +0800, Craig Ringer wrote:
> On 12/31/2014 02:28 PM, Tom Lane wrote:
> > It might happen to work, if you're talking the same Intel-ish CPU type
> > on both ends ... but if it fails, don't call us.
>
> It might for 32-bit, but I'm pretty sure it's not going to for 64-bit
> because Windows is LLP64 and Linux is LP64, so sizeof(long) differs. See
> http://en.wikipedia.org/wiki/64-bit_computing .
>
> (Yet another area where Windows is annoyingly and pointlessly different,
> like use of UTF16 instead of UTF-8, though at least there they have the
> excuse of doing it first.)
>
> Just use a Linux box or a virtual machine to start a copy of the
> database, then pg_dump -Fc it and pg_restore to a new instance on the
> Windows box.
I would also worry about collation differences between Linux and
Windows. We have seen index problems with OS upgrades causing
mismatches, so I assume Windows and Linux might have even larger
mismatches. We have discussed a way to test for mismatches but have
no solution yet.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ Everyone has their own god. +
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: PostgreSQL file system based restore from Linux to Windows
@ 2015-01-02 23:30 Craig Ringer <craig@2ndquadrant.com>
0 siblings, 0 replies; 6+ messages in thread
From: Craig Ringer @ 2015-01-02 23:30 UTC (permalink / raw)
To: Bruce Momjian <bruce@momjian.us>; +Cc: pgsql-admin; girish R G peetle <giri.anamika0@gmail.com>; Tom Lane <tgl@sss.pgh.pa.us>
On 3 Jan 2015 12:54 am, Bruce Momjian <bruce@momjian.us> wrote:
>
> On Fri, Jan 2, 2015 at 06:56:47PM +0800, Craig Ringer wrote:
> > On 12/31/2014 02:28 PM, Tom Lane wrote:
> > > It might happen to work, if you're talking the same Intel-ish CPU type
> > > on both ends ... but if it fails, don't call us.
> >
> > It might for 32-bit, but I'm pretty sure it's not going to for 64-bit
> > because Windows is LLP64 and Linux is LP64, so sizeof(long) differs. See
> > http://en.wikipedia.org/wiki/64-bit_computing .
> >
> > (Yet another area where Windows is annoyingly and pointlessly different,
> > like use of UTF16 instead of UTF-8, though at least there they have the
> > excuse of doing it first.)
> >
> > Just use a Linux box or a virtual machine to start a copy of the
> > database, then pg_dump -Fc it and pg_restore to a new instance on the
> > Windows box.
>
> I would also worry about collation differences between Linux and
> Windows. We have seen index problems with OS upgrades causing
> mismatches, so I assume Windows and Linux might have even larger
> mismatches. We have discussed a way to test for mismatches but have
> no solution yet.
Good point. In fact, the encoding names on Windows are different, as is the set of available encodings. That'd probably scuttle any attempt to use a *nix DB on Windows at least if it wasn't utf-8.
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2015-01-02 23:30 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-12-31 05:33 PostgreSQL file system based restore from Linux to Windows girish R G peetle <giri.anamika0@gmail.com>
2014-12-31 06:28 ` Tom Lane <tgl@sss.pgh.pa.us>
2014-12-31 09:12 ` girish R G peetle <giri.anamika0@gmail.com>
2015-01-02 10:56 ` Craig Ringer <craig@2ndquadrant.com>
2015-01-02 16:54 ` Bruce Momjian <bruce@momjian.us>
2015-01-02 23:30 Re: PostgreSQL file system based restore from Linux to Windows Craig Ringer <craig@2ndquadrant.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox