Обсуждение: Is it possible to convert WAL's between architectures?

Поиск
Список
Период
Сортировка

Is it possible to convert WAL's between architectures?

От
Marcin Kasperski
Дата:
As in the title - is it possible to convert WAL for another architecture?

(source database on Linux/i386, contemplating chances to restore
backup on Linux/amd64)

Re: Is it possible to convert WAL's between architectures?

От
Alvaro Herrera
Дата:
Marcin Kasperski wrote:
>
> As in the title - is it possible to convert WAL for another architecture?
>
> (source database on Linux/i386, contemplating chances to restore
> backup on Linux/amd64)

No.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Re: Is it possible to convert WAL's between architectures?

От
"Scott Marlowe"
Дата:
On Thu, Jun 5, 2008 at 9:19 AM, Alvaro Herrera
<alvherre@commandprompt.com> wrote:
> Marcin Kasperski wrote:
>>
>> As in the title - is it possible to convert WAL for another architecture?
>>
>> (source database on Linux/i386, contemplating chances to restore
>> backup on Linux/amd64)
>
> No.

Technically it really IS possible, but I can't imagine investing the
time to be able to do so.

Re: Is it possible to convert WAL's between architectures?

От
"Kevin Grittner"
Дата:
>>> On Thu, Jun 5, 2008 at  5:18 PM, in message
<dcc563d10806051518w64a1833w269ecc2b377a1519@mail.gmail.com>, "Scott
Marlowe"
<scott.marlowe@gmail.com> wrote:
> On Thu, Jun 5, 2008 at 9:19 AM, Alvaro Herrera
> <alvherre@commandprompt.com> wrote:
>> Marcin Kasperski wrote:
>>>
>>> As in the title - is it possible to convert WAL for another
architecture?
>>>
>>> (source database on Linux/i386, contemplating chances to restore
>>> backup on Linux/amd64)
>>
>> No.
>
> Technically it really IS possible, but I can't imagine investing the
> time to be able to do so.

We did this by installing the 32 bit libraries and making a 32 bit
build which ran under the 64 bit OS.

-Kevin

Re: Is it possible to convert WAL's between architectures?

От
"Scott Marlowe"
Дата:
On Thu, Jun 5, 2008 at 4:27 PM, Kevin Grittner
<Kevin.Grittner@wicourts.gov> wrote:
>>>> On Thu, Jun 5, 2008 at  5:18 PM, in message
> <dcc563d10806051518w64a1833w269ecc2b377a1519@mail.gmail.com>, "Scott
> Marlowe"
> <scott.marlowe@gmail.com> wrote:
>> On Thu, Jun 5, 2008 at 9:19 AM, Alvaro Herrera
>> <alvherre@commandprompt.com> wrote:
>>> Marcin Kasperski wrote:
>>>>
>>>> As in the title - is it possible to convert WAL for another
> architecture?
>>>>
>>>> (source database on Linux/i386, contemplating chances to restore
>>>> backup on Linux/amd64)
>>>
>>> No.
>>
>> Technically it really IS possible, but I can't imagine investing the
>> time to be able to do so.
>
> We did this by installing the 32 bit libraries and making a 32 bit
> build which ran under the 64 bit OS.

True.  But that would only work on 64/32 split OSes where the chipsets
have a 32 bit compatibility mode.  You couldn't do that from i386 to
sparc64 for instance.