Search Postgresql Archives

Re: pitr question

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

 



On 14/10/10 00:18, Joshua D. Drake wrote:
> On Wed, 2010-10-13 at 11:40 -0400, Geoffrey Myers wrote:
>> On 10/13/2010 11:30 AM, zhong ming wu wrote:
>>> On Wed, Oct 13, 2010 at 11:17 AM, Geoffrey Myers
>>> <lists@xxxxxxxxxxxxxxxxxxxxx <mailto:lists@xxxxxxxxxxxxxxxxxxxxx>> wrote:
>>>  > Excuse the ignorance, but I see the following in the docs:
>>>  >
>>>  > 'In any case the hardware architecture must be the same â shipping from,
>>>  > say, a 32-bit to a 64-bit system will not work.'
>>>
>>> postgres only sees the OS. It does not care what hardware you got. So
>>> you must use the same type of OS: both 32 bit or both 64 bit.
>>
>> As I expected, thus the document should possibly be rephrased to 
>> indicate it's the OS not the physical hardware that is the issue.
> 
> No. Because PostgreSQL itself must also be the same architecture.

No it doesn't. As Tom Lane pointed out, plenty plenty of 64-bit OSes on
64-bit hardware will run 32-bit binaries. Additionally, most 64-bit
hardware will run 32-bit OSes with 32-bit binaries.

So long as Pg has the same word sizes, endianness, etc, it won't care.
This means that you can't log-ship from 32-bit Intel to 32-bit
big-endian PPC and expect it to work, but you can log-ship from 32-bit
Pg running on 64-bit Intel to 32-bit Pg running on 32-bit Intel and
that'll be fine.

-- 
Craig Ringer

Tech-related writing: http://soapyfrogs.blogspot.com/

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[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