Thread: 9.1 replication on different arch
I have two servers, one a x86 32bit server, and the other one is a x86 64 bit server. We want to use synchronous replication and make the 32 bit be a master and the 64bit be a read-only stand-by. Do I have to install 32bit postgresql on the 64bit server to be able to use wal replication? -- Martín Marqués select 'martin.marques' || '@' || 'gmail.com' DBA, Programador, Administrador
2011/11/2 Martín Marqués <martin.marques@gmail.com>
I have two servers, one a x86 32bit server, and the other one is a x86
64 bit server.
We want to use synchronous replication and make the 32 bit be a master
and the 64bit be a read-only stand-by.
Do I have to install 32bit postgresql on the 64bit server to be able
to use wal replication?
--
Martín Marqués
select 'martin.marques' || '@' || 'gmail.com'
DBA, Programador, Administrador
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Native replication is only available on systems with the same architecture, so the short answer is no.
But I'm pretty sure you can still use other replication tools like Slony or Bucardo, although neither is synchronous.
-Adam
Don't worry, they are both x86 arch, so I'll just install 32bit postgresql on the 64 bit server. That should make it work, right? El día 2 de noviembre de 2011 14:55, Adam Cornett <adam.cornett@gmail.com> escribió: > > 2011/11/2 Martín Marqués <martin.marques@gmail.com> >> >> I have two servers, one a x86 32bit server, and the other one is a x86 >> 64 bit server. >> >> We want to use synchronous replication and make the 32 bit be a master >> and the 64bit be a read-only stand-by. >> >> Do I have to install 32bit postgresql on the 64bit server to be able >> to use wal replication? >> >> -- >> Martín Marqués >> select 'martin.marques' || '@' || 'gmail.com' >> DBA, Programador, Administrador >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@postgresql.org) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general > > > Native replication is only available on systems with the same architecture, > so the short answer is no. > But I'm pretty sure you can still use other replication tools like Slony or > Bucardo, although neither is synchronous. > -Adam -- Martín Marqués select 'martin.marques' || '@' || 'gmail.com' DBA, Programador, Administrador
On 11/02/11 11:21 AM, Martín Marqués wrote: > Don't worry, they are both x86 arch, so I'll just install 32bit > postgresql on the 64 bit server. That should make it work, right? yes, that should work fine. -- john r pierce N 37, W 122 santa cruz ca mid-left coast
2011/11/2 John R Pierce <pierce@hogranch.com>: > On 11/02/11 11:21 AM, Martín Marqués wrote: >> >> Don't worry, they are both x86 arch, so I'll just install 32bit >> postgresql on the 64 bit server. That should make it work, right? > > yes, that should work fine. Sad thing is that it's not so easy on Debian. With Fedora all I had to do is select the arch type and that's all. -- Martín Marqués select 'martin.marques' || '@' || 'gmail.com' DBA, Programador, Administrador
El 02/11/11 22:40, Martín Marqués escribió: > 2011/11/2 John R Pierce<pierce@hogranch.com>: >> On 11/02/11 11:21 AM, Martín Marqués wrote: >>> Don't worry, they are both x86 arch, so I'll just install 32bit >>> postgresql on the 64 bit server. That should make it work, right? >> yes, that should work fine. > Sad thing is that it's not so easy on Debian. With Fedora all I had to > do is select the arch type and that's all. > I am not completely sure about this....but you should be able to use dpkg --force-architecture to install it
El día 3 de noviembre de 2011 09:18, Rodrigo Gonzalez <rjgonzale@estrads.com.ar> escribió: > El 02/11/11 22:40, Martín Marqués escribió: >> >> 2011/11/2 John R Pierce<pierce@hogranch.com>: >>> >>> On 11/02/11 11:21 AM, Martín Marqués wrote: >>>> >>>> Don't worry, they are both x86 arch, so I'll just install 32bit >>>> postgresql on the 64 bit server. That should make it work, right? >>> >>> yes, that should work fine. >> >> Sad thing is that it's not so easy on Debian. With Fedora all I had to >> do is select the arch type and that's all. >> > I am not completely sure about this....but you should be able to use dpkg > --force-architecture to install it Yes, but I would have to download the postgresql-9.1 for i386 package and all the dependencies. With Fedora, all I do is: # yum install portgresql-server.i386 -- Martín Marqués select 'martin.marques' || '@' || 'gmail.com' DBA, Programador, Administrador
On ons, 2011-11-02 at 22:40 -0300, Martín Marqués wrote: > 2011/11/2 John R Pierce <pierce@hogranch.com>: > > On 11/02/11 11:21 AM, Martín Marqués wrote: > >> > >> Don't worry, they are both x86 arch, so I'll just install 32bit > >> postgresql on the 64 bit server. That should make it work, right? > > > > yes, that should work fine. > > Sad thing is that it's not so easy on Debian. With Fedora all I had to > do is select the arch type and that's all. Put it in a chroot.
Am 2011-11-03 02:40, schrieb Martín Marqués:
>
> Sad thing is that it's not so easy on Debian. With Fedora all I had to
> do is select the arch type and that's all.
Have a look at "dpkg --force-architecture" .
-hannes
2011/11/4 Hannes Erven <h.e@gmx.at>: > Am 2011-11-03 02:40, schrieb Martín Marqués: >> >> Sad thing is that it's not so easy on Debian. With Fedora all I had to >> do is select the arch type and that's all. > > Have a look at "dpkg --force-architecture" . I'm having a lot of trouble with this. The server has an application written in perl, which connects to the master PG server. The thing is that perl needs libdbd-pg-perl to connect, which needs libpq5, all this in amd64, but the i386 of postgresql-9.1 needs an i386 version of libpq5 (which debian doesn't distinguish between packages of different archs), and I can't install both versions. What a mess! -- Martín Marqués select 'martin.marques' || '@' || 'gmail.com' DBA, Programador, Administrador
2011-11-04 16:24, Martín Marqués: >> Have a look at "dpkg --force-architecture" . > > The thing is that perl needs libdbd-pg-perl to connect, which needs > libpq5, all this in amd64, but the i386 of postgresql-9.1 needs an > i386 version of libpq5 Oh, I see, that's a mess. Probably there really isn't a way to solve this... maybe you could do a parallel install of a complete 32bit Perl? Or run your Perl app on a different machine? In my case, I forced a 32bit libpq5 onto the system, which is required for the postgresql-client to work, which in turn is used by the init scripts to detect successful starting. But I don't need DBD and thus do not have other depencies on libpq... -hanney
2011/11/4 Hannes Erven <h.e@gmx.at>: > 2011-11-04 16:24, Martín Marqués: >>> Have a look at "dpkg --force-architecture" . >> >> The thing is that perl needs libdbd-pg-perl to connect, which needs >> libpq5, all this in amd64, but the i386 of postgresql-9.1 needs an >> i386 version of libpq5 > > Oh, I see, that's a mess. Probably there really isn't a way to solve > this... maybe you could do a parallel install of a complete 32bit Perl? > Or run your Perl app on a different machine? > > In my case, I forced a 32bit libpq5 onto the system, which is required > for the postgresql-client to work, which in turn is used by the init > scripts to detect successful starting. But I don't need DBD and thus do > not have other depencies on libpq... > I'd install postgresql in a 32 bit VM then.
El día 4 de noviembre de 2011 13:15, Scott Marlowe <scott.marlowe@gmail.com> escribió: > > I'd install postgresql in a 32 bit VM then. > We're looking into it. Look's like the only option available for now, at least for using WAL replication. -- Martín Marqués select 'martin.marques' || '@' || 'gmail.com' DBA, Programador, Administrador