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-generalNative 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 libpq5Oh, 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