Re: [GENERAL] Pattern Matching question - PG 9.6

On Sunday, May 14, 2017, Patrick B wrote: > > I thought I have already explained it. Here it goes again. Demo page is: > http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=ea61e7e1859bdb > 7f297f853a9dc0e3d0 > > Now that you've posted the right link it becomes a bit easier to follow... > > To summar

Re: [GENERAL] Pattern Matching question - PG 9.6

2017-05-15 16:10 GMT+12:00 David G. Johnston : > On Sunday, May 14, 2017, Patrick B wrote: > >> >> Demo: http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=3c3a3f870eb4d0 >> 02c5b4200042b25669 >> >> >> The rows that I sho

Re: [GENERAL] Pattern Matching question - PG 9.6

On Sunday, May 14, 2017, Patrick B wrote: > > Demo: http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle= > 3c3a3f870eb4d002c5b4200042b25669 > > > The rows that I should be getting are: > > 5 /testfile/client/10/attachmen

Re: [GENERAL] Pattern Matching question - PG 9.6

2017-05-15 15:20 GMT+12:00 Patrick B : > Hi guys, > > Demo: http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle= > 3c3a3f870eb4d002c5b4200042b25669 > > > FYI - NEW LINK http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=ea61e7e1

[GENERAL] Pattern Matching question - PG 9.6

Hi guys, Demo: http://dbfiddle.uk/?rdbms=postgres_9.6&fiddle=3c3a3f870eb4d002c5b4200042b25669 AS you can see above, when performing this query: > SELECT * FROM test1 WHERE client_id = 10 AND path ~ > '^/testfile/cl

Re: [GENERAL] Top posting....

On Sat, May 13, 2017 at 7:48 PM, Bruce Momjian wrote: > On Thu, May 11, 2017 at 01:43:52PM -0400, Tom Lane wrote: >> Absolutely. The point of quoting previous messages is not to replicate >> the entire thread in each message; we have archives for that. The point >> is to *briefly* remind readers

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

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.

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.

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.

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.

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.

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.

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.

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 :(

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 :(

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 :(

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.

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 :(

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.

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.

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.

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 :(

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 :(

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 :(

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