Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-18 Thread Adrian Klaver
On 05/18/2017 08:49 AM, Martin Goodson wrote: On 18/05/2017 15:20, Adrian Klaver wrote: If I remove that link then I can compile. Have no idea why. Hi! OP here, and here's the feedback on what I'm getting after unlinking as suggested yesterday: I tried removing/unlinking as suggested and,

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-18 Thread Martin Goodson
On 18/05/2017 15:20, Adrian Klaver wrote: If I remove that link then I can compile. Have no idea why. Hi! OP here, and here's the feedback on what I'm getting after unlinking as suggested yesterday: I tried removing/unlinking as suggested and, just like Adrian, it worked OK for me! :) T

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-18 Thread Adrian Klaver
On 05/17/2017 02:03 PM, Tom Lane wrote: > Adrian Klaver writes: >> I could build repmgr against Postgres source and on Ubuntu install of >> EDB Postgres. The issue seems to be a combination of RH and EDB Postgres >> installation. To me it looks like ld is finding >> /lib64/libldap_r-2.4.so.2 libra

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-17 Thread Tom Lane
Adrian Klaver writes: > I could build repmgr against Postgres source and on Ubuntu install of > EDB Postgres. The issue seems to be a combination of RH and EDB Postgres > installation. To me it looks like ld is finding > /lib64/libldap_r-2.4.so.2 library before the /opt/PostgreSQL/9.6/lib/ > o

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-17 Thread Adrian Klaver
On 05/17/2017 01:28 PM, Martin Goodson wrote: On 17/05/2017 20:11, Adrian Klaver wrote: I thought you where working on VM you had access/rights to. That is not the case? I have sudo access on the redhat box we're working on so technically I could do this, yup. But whilst our Unix team are

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-17 Thread Martin Goodson
On 17/05/2017 20:11, Adrian Klaver wrote: I thought you where working on VM you had access/rights to. That is not the case? I have sudo access on the redhat box we're working on so technically I could do this, yup. But whilst our Unix team are happy for us to do whatever the heck we like

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-17 Thread Adrian Klaver
On 05/17/2017 12:01 PM, Martin Goodson wrote: On 17/05/2017 17:19, Adrian Klaver wrote: Spun up a RH 7.3 instance and tried the compile and got the same error. Good to know it's reproducible, and not just me :) I'll have a word with our UNIX team about unlinking this (and relinking afterwa

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-17 Thread Martin Goodson
On 17/05/2017 17:19, Adrian Klaver wrote: Spun up a RH 7.3 instance and tried the compile and got the same error. Good to know it's reproducible, and not just me :) To fix, find the checking library in /lib64/libldap_r-2.4.so.2. [root@localhost repmgr-2.0]# cd /lib64/ [root@localhost lib64]#

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-17 Thread Martin Goodson
On 17/05/2017 16:15, Adrian Klaver wrote: On 05/17/2017 07:26 AM, Martin Goodson wrote: On 16/05/2017 18:46, Adrian Klaver wrote: Per Tom's suggestion try ldd /db_demo/app/postgres/9.6.2-3/lib/libldap_r-2.4.so.2 Hello. Apologies for the delay in replying - medical appointment this morning

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-17 Thread Adrian Klaver
On 05/17/2017 07:26 AM, Martin Goodson wrote: On 16/05/2017 18:46, Adrian Klaver wrote: Per Tom's suggestion try ldd /db_demo/app/postgres/9.6.2-3/lib/libldap_r-2.4.so.2 Hello. Apologies for the delay in replying - medical appointment this morning :) Anyway, executed that command as suggeste

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-17 Thread Adrian Klaver
On 05/17/2017 07:26 AM, Martin Goodson wrote: On 16/05/2017 18:46, Adrian Klaver wrote: Per Tom's suggestion try ldd /db_demo/app/postgres/9.6.2-3/lib/libldap_r-2.4.so.2 Hello. Apologies for the delay in replying - medical appointment this morning :) Anyway, executed that command as suggeste

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-17 Thread Martin Goodson
On 16/05/2017 18:46, Adrian Klaver wrote: Per Tom's suggestion try ldd /db_demo/app/postgres/9.6.2-3/lib/libldap_r-2.4.so.2 Hello. Apologies for the delay in replying - medical appointment this morning :) Anyway, executed that command as suggested and this is the output I got. pginst@testd

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-16 Thread Adrian Klaver
On 05/16/2017 08:39 AM, Martin Goodson wrote: On 16/05/2017 15:58, Adrian Klaver wrote: For completeness what does: ls -al /usr/lib64/libssl.so show? (Trimming things down a bit to keep things a little bit more readable, now we've got the package dependencies issue sorted. Hopefully. Hop

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-16 Thread Tom Lane
Martin Goodson writes: /bin/ld: warning: libssl.so.1.0.0, needed by /db_demo/app/postgres/9.6.2-3/lib/libpq.so, may conflict with libssl.so.10 /lib64/libldap_r-2.4.so.2: undefined reference to `ber_sockbuf_io_udp' collect2: error: ld returned 1 exit status > Drat. Didn'

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-16 Thread Martin Goodson
On 16/05/2017 16:39, Martin Goodson wrote: On 16/05/2017 15:58, Adrian Klaver wrote: /bin/ld: warning: libssl.so.1.0.0, needed by /db_demo/app/postgres/9.6.2-3/lib/libpq.so, may conflict with libssl.so.10 /lib64/libldap_r-2.4.so.2: undefined reference to `ber_sockbuf_io_udp' collect2: error: l

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-16 Thread Martin Goodson
On 16/05/2017 15:58, Adrian Klaver wrote: For completeness what does: ls -al /usr/lib64/libssl.so show? (Trimming things down a bit to keep things a little bit more readable, now we've got the package dependencies issue sorted. Hopefully. Hope that's OK?) I can see the following: $ ls -l

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-16 Thread Adrian Klaver
On 05/16/2017 07:22 AM, Martin Goodson wrote: On 16/05/2017 14:42, Adrian Klaver wrote: On 05/16/2017 04:36 AM, Martin Goodson wrote: On 15/05/2017 00:17, Martin Goodson wrote: That list would be: systemd libxslt-devel pam-devel openssl-devel readline-devel libmemcached-devel libicu-devel

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-16 Thread Martin Goodson
On 16/05/2017 14:42, Adrian Klaver wrote: On 05/16/2017 04:36 AM, Martin Goodson wrote: On 15/05/2017 00:17, Martin Goodson wrote: Tomorrow I'll have to see about getting that set-up on an RHEL 7 box :) Thank you so much, everybody, for your help! It's been invaluable! Regards, Martin.

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-16 Thread Adrian Klaver
On 05/16/2017 04:36 AM, Martin Goodson wrote: On 15/05/2017 00:17, Martin Goodson wrote: Tomorrow I'll have to see about getting that set-up on an RHEL 7 box :) Thank you so much, everybody, for your help! It's been invaluable! Regards, Martin. *Sigh*. And things were going so well. With

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 4 - compilation issues on RHEL 7.2

2017-05-16 Thread Martin Goodson
On 15/05/2017 00:17, Martin Goodson wrote: Tomorrow I'll have to see about getting that set-up on an RHEL 7 box :) Thank you so much, everybody, for your help! It's been invaluable! Regards, Martin. *Sigh*. And things were going so well. With Adrian and Devrim's help I was able to get re

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-14 Thread Martin Goodson
On 14/05/2017 21:49, Adrian Klaver wrote: I spun up an Ubuntu 16.04 instance and: RHUbuntu build-essential libxslt-devellibxslt1-dev(this also pulled in libicu-dev) pam-devel libpam0g-dev openssl-devel libssl-dev readline-devel

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-14 Thread John R Pierce
On 5/14/2017 2:20 PM, Joshua D. Drake wrote: A bit outdated but: http://raghavt.blogspot.com/2015/01/configuring-automatic-failover-using.html the advice on that page to unlink a library in /lib64 on an RPM managed system makes me very leery of the rest of the article. -- john r pierce,

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-14 Thread Joshua D. Drake
On 05/14/2017 02:38 PM, Adrian Klaver wrote: On 05/14/2017 02:20 PM, Joshua D. Drake wrote: On 05/14/2017 01:42 PM, Martin Goodson wrote: Do you happen to know if there's any documentation anywhere on installing/configuring repmgr with Enterprise DB PostgreSQL (community, *not* Advanced)? A b

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-14 Thread Adrian Klaver
On 05/14/2017 02:20 PM, Joshua D. Drake wrote: > On 05/14/2017 01:42 PM, Martin Goodson wrote: >> Do you happen to know if there's any documentation anywhere on >> installing/configuring repmgr with Enterprise DB PostgreSQL (community, >> *not* Advanced)? > > A bit outdated but: > > http://raghav

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-14 Thread Joshua D. Drake
On 05/14/2017 01:42 PM, Martin Goodson wrote: Do you happen to know if there's any documentation anywhere on installing/configuring repmgr with Enterprise DB PostgreSQL (community, *not* Advanced)? A bit outdated but: http://raghavt.blogspot.com/2015/01/configuring-automatic-failover-using.htm

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-14 Thread Joshua D. Drake
On 05/14/2017 11:22 AM, Devrim Gündüz wrote: Hi Josh, On Fri, 2017-05-12 at 08:18 -0700, Joshua D. Drake wrote: This is your problem. As Adrian already mentioned, you should be running the PGDG apt repos. I don't think this is a productive answer. Really? The OP has had a thread of 28 mes

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-14 Thread Adrian Klaver
On 05/14/2017 11:26 AM, Devrim Gündüz wrote: Hi Martin, On Fri, 2017-05-12 at 16:13 +0100, Martin Goodson wrote: /usr/bin/ld: cannot find -lselinux /usr/bin/ld: cannot find -lssl /usr/bin/ld: cannot find -lcrypto /usr/bin/ld: cannot find -lgssapi_krb5 /usr/bin/ld: cannot find -lz collect2: err

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-14 Thread Martin Goodson
On 14/05/2017 19:26, Devrim Gündüz wrote: Hi Martin, On Fri, 2017-05-12 at 16:13 +0100, Martin Goodson wrote: /usr/bin/ld: cannot find -lselinux /usr/bin/ld: cannot find -lssl /usr/bin/ld: cannot find -lcrypto /usr/bin/ld: cannot find -lgssapi_krb5 /usr/bin/ld: cannot find -lz collect2: error:

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 3 - libraries resolved, still can't compile :(

2017-05-14 Thread Adrian Klaver
On 05/14/2017 01:21 PM, Devrim Gündüz wrote: Hi, On Sun, 2017-05-14 at 12:59 -0700, Adrian Klaver wrote: We don't support OpenSuSE, that might be the reason. Who is we EnterpriseDB. and what don't you support? OpenSuSE, as I wrote in the previous email. You might need to rewrite this

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 3 - libraries resolved, still can't compile :(

2017-05-14 Thread Devrim Gündüz
Hi, On Sun, 2017-05-14 at 12:59 -0700, Adrian Klaver wrote: > > We don't support OpenSuSE, that might be the reason. > > Who is we EnterpriseDB. > and what don't you support? OpenSuSE, as I wrote in the previous email. Regards, -- Devrim Gündüz EnterpriseDB: http://www.enterprisedb.com Pos

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 3 - libraries resolved, still can't compile :(

2017-05-14 Thread Adrian Klaver
On 05/14/2017 11:31 AM, Devrim Gündüz wrote: Hi Adrian, On Sun, 2017-05-14 at 09:00 -0700, Adrian Klaver wrote: I understand. I just installed EDB Postgres 9.6.3 on my openSUSE Leap 42.2 machine and tried to compile repmgr against it. No joy. We don't support OpenSuSE, that might be the rea

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-14 Thread Adrian Klaver
On 05/14/2017 11:29 AM, Devrim Gündüz wrote: Hi again Martin, On Fri, 2017-05-12 at 16:13 +0100, Martin Goodson wrote: testdb@repm:/postgresql/software/repmgr/repmgr-3.3.1$ sudo make USE_PGXS=1 install BTW, please patch these two files first and change PG_CONFIG = pg_config to PG_CONFIG= /p

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 3 - libraries resolved, still can't compile :(

2017-05-14 Thread Devrim Gündüz
Hi Adrian, On Sun, 2017-05-14 at 09:00 -0700, Adrian Klaver wrote: > I understand. I just installed  EDB Postgres 9.6.3 on my openSUSE Leap  > 42.2 machine and tried to compile repmgr against it. No joy. We don't support OpenSuSE, that might be the reason. Regards, -- Devrim Gündüz Enterprise

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-14 Thread Devrim Gündüz
Hi again Martin, On Fri, 2017-05-12 at 16:13 +0100, Martin Goodson wrote: > testdb@repm:/postgresql/software/repmgr/repmgr-3.3.1$ sudo make  > USE_PGXS=1 install BTW, please patch these two files first and change PG_CONFIG = pg_config  to PG_CONFIG= /postgresql/software/pg/9.6.2/bin/config (ap

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-14 Thread Devrim Gündüz
Hi Martin, On Fri, 2017-05-12 at 16:13 +0100, Martin Goodson wrote: > /usr/bin/ld: cannot find -lselinux > /usr/bin/ld: cannot find -lssl > /usr/bin/ld: cannot find -lcrypto > /usr/bin/ld: cannot find -lgssapi_krb5 > /usr/bin/ld: cannot find -lz > collect2: error: ld returned 1 exit status > Make

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-14 Thread Devrim Gündüz
Hi Josh, On Fri, 2017-05-12 at 08:18 -0700, Joshua D. Drake wrote: > This is your problem. As Adrian already mentioned, you should be running  > the PGDG apt repos. I don't think this is a productive answer. I could just compile repmgr on my CentOS 7 box against EPAS 9.6. Someone with a few pack

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 3 - libraries resolved, still can't compile :(

2017-05-14 Thread Adrian Klaver
On 05/14/2017 02:43 AM, Martin Goodson wrote: On 12/05/2017 18:57, Adrian Klaver wrote: On 05/12/2017 09:19 AM, Martin Goodson wrote: On 12/05/2017 16:59, Adrian Klaver wrote: To make things easier I would remove the deb installed Postgres, it just adds complexity to the situation without

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 3 - libraries resolved, still can't compile :(

2017-05-14 Thread Adrian Klaver
On 05/14/2017 02:43 AM, Martin Goodson wrote: On 12/05/2017 18:57, Adrian Klaver wrote: On 05/12/2017 09:19 AM, Martin Goodson wrote: On 12/05/2017 16:59, Adrian Klaver wrote: Progress of a sort. Kinda. On a clean Ubuntu server 17.04 virtual machine I've installed PostgreSQL 9.6 using

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 3 - libraries resolved, still can't compile :(

2017-05-14 Thread Martin Goodson
On 12/05/2017 18:57, Adrian Klaver wrote: On 05/12/2017 09:19 AM, Martin Goodson wrote: On 12/05/2017 16:59, Adrian Klaver wrote: Configuring Automatic failover using Replication Manager 2.0 on PostgreSQL 9.3.5 http://raghavt.blogspot.com/2015/01/configuring-automatic-failover-using.html

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Adrian Klaver
On 05/12/2017 09:19 AM, Martin Goodson wrote: On 12/05/2017 16:59, Adrian Klaver wrote: Configuring Automatic failover using Replication Manager 2.0 on PostgreSQL 9.3.5 http://raghavt.blogspot.com/2015/01/configuring-automatic-failover-using.html "In this post, am demonstrating Replicatio

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Adrian Klaver
On 05/12/2017 09:14 AM, Martin Goodson wrote: On 12/05/2017 16:48, Adrian Klaver wrote: On 05/12/2017 08:30 AM, Martin Goodson wrote: On 12/05/2017 16:18, Joshua D. Drake wrote: The EDB installer allows you to specify where to install PostgreSQL, and uses /opt/PostgreSQL/ for the default.

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Martin Goodson
On 12/05/2017 16:59, Adrian Klaver wrote: Configuring Automatic failover using Replication Manager 2.0 on PostgreSQL 9.3.5 http://raghavt.blogspot.com/2015/01/configuring-automatic-failover-using.html "In this post, am demonstrating Replication Manager on single node(localhost) on RHEL 6.

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Martin Goodson
On 12/05/2017 16:48, Adrian Klaver wrote: On 05/12/2017 08:30 AM, Martin Goodson wrote: On 12/05/2017 16:18, Joshua D. Drake wrote: Thanks for the response. The problem is I'm kind of stuck with using EnterpriseDB's community edition installers. It's a company policy. I can't install Postg

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Adrian Klaver
On 05/12/2017 08:30 AM, Martin Goodson wrote: On 12/05/2017 16:18, Joshua D. Drake wrote: On 05/12/2017 08:13 AM, Martin Goodson wrote: Hello. Thanks for the response. The problem is I'm kind of stuck with using EnterpriseDB's community edition installers. It's a company policy. I can't in

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Adrian Klaver
On 05/12/2017 08:30 AM, Martin Goodson wrote: On 12/05/2017 16:18, Joshua D. Drake wrote: Thanks for the response. The problem is I'm kind of stuck with using EnterpriseDB's community edition installers. It's a company policy. I can't install PostgreSQL using repositories, I ** have ** to u

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Adrian Klaver
On 05/12/2017 08:13 AM, Martin Goodson wrote: Hello. Yesterday I had problems getting repmgr installed, since our PostgreSQL installs to a non-standard place, and doesn't use any postgresql repositories/packages. The responses I got generally seemed to be 'you need to compile it'. Time for

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Martin Goodson
On 12/05/2017 16:18, Joshua D. Drake wrote: On 05/12/2017 08:13 AM, Martin Goodson wrote: Hello. Yesterday I had problems getting repmgr installed, since our PostgreSQL installs to a non-standard place, and doesn't use any postgresql repositories/packages. The responses I got generally seemed

Re: [GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Joshua D. Drake
On 05/12/2017 08:13 AM, Martin Goodson wrote: Hello. Yesterday I had problems getting repmgr installed, since our PostgreSQL installs to a non-standard place, and doesn't use any postgresql repositories/packages. The responses I got generally seemed to be 'you need to compile it'. I'm running u

[GENERAL] EnterpriseDB installed PostgreSQL 9.6 vs. REPMGR. Round 2 - compilation issues.

2017-05-12 Thread Martin Goodson
Hello. Yesterday I had problems getting repmgr installed, since our PostgreSQL installs to a non-standard place, and doesn't use any postgresql repositories/packages. The responses I got generally seemed to be 'you need to compile it'. Time for round 2, trying to compile it with our own envi

Re: [GENERAL] EnterpriseDB install of Postgres on Ubuntu 10.04 library path issues - no version information available (required by /lib/libblkid.so.1)

2012-04-05 Thread Ashesh Vashi
(Please CC to the list... This could be useful to other people too..) On Thu, Apr 5, 2012 at 9:52 PM, Scott Chapman wrote: > Thanks! That worked great. > Nice to hear that it solved the issue. -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company

Re: [GENERAL] EnterpriseDB install of Postgres on Ubuntu 10.04 library path issues - no version information available (required by /lib/libblkid.so.1)

2012-04-04 Thread Ashesh Vashi
On Thu, Apr 5, 2012 at 4:11 AM, Scott Chapman wrote: > Downloaded > http://get.enterprisedb.com/postgresql/postgresql-9.1.3-1-linux.run > Ran it. Install went fine. > StackBuilder install of PostGIS 1.5 failed. No error given. I can't > find it in the logs. So I ran /tmp/edb_postgis_1_5_pg91.b

[GENERAL] EnterpriseDB install of Postgres on Ubuntu 10.04 library path issues - no version information available (required by /lib/libblkid.so.1)

2012-04-04 Thread Scott Chapman
Downloaded http://get.enterprisedb.com/postgresql/postgresql-9.1.3-1-linux.run Ran it. Install went fine. StackBuilder install of PostGIS 1.5 failed. No error given. I can't find it in the logs. So I ran /tmp/edb_postgis_1_5_pg91.bin by hand. Everything went fine there. Then I wanted to install

Re: [GENERAL] EnterpriseDB-xDBReplicationServer java process on OS X.

2011-06-06 Thread Vibhor Kumar
On Jun 5, 2011, at 4:02 PM, piscesboy wrote: > I have a process called "java" showing up in my Activity Monitor that > uses a good amount of CPU (4 - 8% average, 100 - 120% on occasion). It > reports that "launchd" is its parent process and that postgres is its > user. > > I did a ps axv|grep ja

Re: [GENERAL] EnterpriseDB-xDBReplicationServer java process on OS X.

2011-06-05 Thread Joshua D. Drake
On 06/05/2011 03:32 AM, piscesboy wrote: I have a process called "java" showing up in my Activity Monitor that uses a good amount of CPU (4 - 8% average, 100 - 120% on occasion). It reports that "launchd" is its parent process and that postgres is its user. I did a ps axv|grep java and found out

[GENERAL] EnterpriseDB-xDBReplicationServer java process on OS X.

2011-06-05 Thread piscesboy
I have a process called "java" showing up in my Activity Monitor that uses a good amount of CPU (4 - 8% average, 100 - 120% on occasion). It reports that "launchd" is its parent process and that postgres is its user. I did a ps axv|grep java and found out that it is the edb- repserver.jar doing so

[GENERAL] EnterpriseDB Apology

2007-01-18 Thread Denis Lussier
Hi All, EnterpriseDB recently sent out email advertising new support offerings. Unfortunately, the email was incorrectly sent to some people who should not have received it. We apologize for the error, and are taking steps to avoid such mistakes in the future. -Denis Lussier CTO & Founder http:

Re: [GENERAL] EnterpriseDB

2006-05-06 Thread Will Reese
It is my understanding that EnterpriseDB has many extensions built on top of PostgreSQL 8.1, and I doubt that an EnterpriseDB backup could be restored into the open source version of PostgreSQL. It would probably error out once it tried to create a stored procedure with the oracle compatib

Re: [GENERAL] EnterpriseDB

2006-05-05 Thread Guy Rouillier
Matthew Hixson wrote: > Just a normal, downloaded from www.postgresql.org, PostgreSQL 8.1 > database. I imagine Terry's question stems from what would appear to be a straightforward scenario, and hence the need to ask. For the second part of your question, are you asking simply if you can dump a

Re: [GENERAL] EnterpriseDB

2006-05-05 Thread Joshua D. Drake
Terry Fielder wrote: By "regular PostgreSQL" do you mean a PostgreSQL 7.x install? No he probably means the current Open Source release from the PostgreSQL Development group thus 8.1.3. Joshua D. Drake Terry Fielder [EMAIL PROTECTED] Associate Director Software Development and Deployment

Re: [GENERAL] EnterpriseDB

2006-05-05 Thread Matthew Hixson
Just a normal, downloaded from www.postgresql.org, PostgreSQL 8.1 database. -M@ On May 5, 2006, at 4:56 PM, Terry Fielder wrote: By "regular PostgreSQL" do you mean a PostgreSQL 7.x install? Terry Fielder [EMAIL PROTECTED] Associate Director Software Development and Deployment Great Gulf H

Re: [GENERAL] EnterpriseDB

2006-05-05 Thread Terry Fielder
By "regular PostgreSQL" do you mean a PostgreSQL 7.x install? Terry Fielder [EMAIL PROTECTED] Associate Director Software Development and Deployment Great Gulf Homes / Ashton Woods Homes Fax: (416) 441-9085 Matthew Hixson wrote: http://www.enterprisedb.com/news_events/press_releases/04_24_06.

[GENERAL] EnterpriseDB

2006-05-05 Thread Matthew Hixson
http://www.enterprisedb.com/news_events/press_releases/04_24_06.do Was wondering if anyone had used that to import an Oracle .dmp file and then export a Postgres 8.1 dump file for import into a regular PostgreSQL database. -M@ ---(end of broadcast)-

Re: [GENERAL] EnterpriseDB

2006-02-17 Thread Joshua D. Drake
Benjamin Arai wrote: Is the PL support in EnterpriseDB worth the money? Are there any specific benefits that I should specifically be aware of? It depends.. do you want plSQL/Oracle compatibility? If so... then probably. If not... then the base PostgreSQL pl support is more then enough conside

Re: [GENERAL] EnterpriseDB

2006-02-17 Thread Christopher Browne
[EMAIL PROTECTED] ("Benjamin Arai") wrote: > Is the PL support in EnterpriseDB worth the money?  Are there any > specific benefits that I should specifically be aware of? I dunno; this is a PostgreSQL list, and many (most?) of us have never used EnterpriseDB. The people that can answer your *seco

[GENERAL] EnterpriseDB

2006-02-17 Thread Benjamin Arai
Is the PL support in EnterpriseDB worth the money?  Are there any specific benefits that I should specifically be aware of?   Benjamin Arai [EMAIL PROTECTED] http://www.benjaminarai.com  

Re: [GENERAL] EnterpriseDB mentioned in eweek, and...

2005-08-10 Thread Joshua D. Drake
Klint Gore wrote: On Wed, 10 Aug 2005 21:54:45 -0500, Tony Caduto <[EMAIL PROTECTED]> wrote: I agree, SCO is vile, but Borland what the heck are they thinking. It's borland. Every few years they fly off in a bizarre direction. If kylix is anything to go by, they won't be doing mu

Re: [GENERAL] EnterpriseDB mentioned in eweek, and...

2005-08-10 Thread Klint Gore
On Wed, 10 Aug 2005 21:54:45 -0500, Tony Caduto <[EMAIL PROTECTED]> wrote: > I agree, SCO is vile, but Borland what the heck are they thinking. It's borland. Every few years they fly off in a bizarre direction. If kylix is anything to go by, they won't be doing much anyway. Perhaps someone f

Re: [GENERAL] EnterpriseDB mentioned in eweek, and...

2005-08-10 Thread Joshua D. Drake
Tony Caduto wrote: according to the article they "make postgresql" :-) http://www.eweek.com/article2/0,1895,1846635,00.asp Worse, they are partnering with SCO. Sorry Denis/Andy I just can't agree with that one. Sincerely, Joshua D. Drake ---(end of broadcast)-

Re: [GENERAL] EnterpriseDB mentioned in eweek, and...

2005-08-10 Thread Tony Caduto
I agree, SCO is vile, but Borland what the heck are they thinking. Tony Joshua D. Drake wrote: Tony Caduto wrote: according to the article they "make postgresql" :-) http://www.eweek.com/article2/0,1895,1846635,00.asp Worse, they are partnering with SCO. Sorry Denis/Andy I just can't

[GENERAL] EnterpriseDB mentioned in eweek, and...

2005-08-10 Thread Tony Caduto
according to the article they "make postgresql" :-) http://www.eweek.com/article2/0,1895,1846635,00.asp ---(end of broadcast)--- TIP 6: explain analyze is your friend