Thread: [GENERAL] 64 and 32 bit libpq

[GENERAL] 64 and 32 bit libpq

From
Jerry LeVan
Date:
Hello, I am trying to upgrade my postgresql ‘stuff’ to 64 bits from 32 bits.

I am running MaxOS Sierra.

I have built the 64 bit version of the server and have loaded
my database into the new server ( 9.6.2 ). Everything seems to be working.

I have some legacy apps that are 32 bit and talk to the server
via libpq.dylib. They no longer work with a complaint about
not finding a libpq with the right architecture.

Can I go back and do a 32 bit rebuild of everything and then
take the 32 bit libpq and the 64 bit libpq and use lipo to
glue them together and create a ‘fat’ libpq and replace the
installed libpq?

Is this a safe thing to do?

Thanks

Jerry






Re: [GENERAL] 64 and 32 bit libpq

From
Steve Atkins
Date:
> On Feb 12, 2017, at 5:03 PM, Jerry LeVan <jerry.levan@gmail.com> wrote:
>
> Hello, I am trying to upgrade my postgresql ‘stuff’ to 64 bits from 32 bits.
>
> I am running MaxOS Sierra.
>
> I have built the 64 bit version of the server and have loaded
> my database into the new server ( 9.6.2 ). Everything seems to be working.
>
> I have some legacy apps that are 32 bit and talk to the server
> via libpq.dylib. They no longer work with a complaint about
> not finding a libpq with the right architecture.
>
> Can I go back and do a 32 bit rebuild of everything and then
> take the 32 bit libpq and the 64 bit libpq and use lipo to
> glue them together and create a ‘fat’ libpq and replace the
> installed libpq?
>
> Is this a safe thing to do?

I've done it in the past (http://labs.wordtothewise.com/postgresql-osx/) and it
seemed to work fine.

Cheers,
  Steve