Re: Change from 9.6 to 11?

On 12/20/18 5:51 PM, Chuck Martin wrote: Please reply to list also. Ccing list. On Thu, Dec 20, 2018 at 7:56 PM Adrian Klaver > wrote: On 12/20/18 12:35 PM, Chuck Martin wrote: > I hope someone here can see something that eludes me. I've recently

Re: Watching for view changes

On Thu, 20 Dec 2018 12:12:14 -0800, Mitar wrote: >On Thu, Dec 20, 2018 at 8:11 AM Mike Rylander wrote: >> If, as I assume, the FROM clause of the SELECT is essentially static, >> just with varying WHERE conditions, you could just use an AFTER >> INSERT/UPDATE/DELETE trigger on each of the table

Re: Change from 9.6 to 11?

On 12/20/18 12:35 PM, Chuck Martin wrote: I hope someone here can see something that eludes me. I've recently moved a database from PostgreSQL 9.6 to 11, and there are a few oddities. The following select statement returns zero rows when it should return one. This is one of a small number of re

Re: Multiple LDAP Servers for ldap Authentication

On Thu, 20 Dec 2018 at 16:17, Kumar, Virendra wrote: > > I figured it out, this is how it works: > -- > hostall all0.0.0.0/0 ldap > ldapserver=server1.com ldapserver=server2.com ldapprefix=PROD01\ > > So documentation need some update. Looking at

Re: Wals not recycling

2018年12月20日(木) 21:58 Rijo Roy : > > Thanks sk for replying Ian.. I have one inactive replication slot in the > database. I suspected that could be the cause but was not sure of it. Could > you please tell me what I should be doing in this case. Can I drop the > replication slot since it is no mo

RE: Multiple LDAP Servers for ldap Authentication

I figured it out, this is how it works: -- hostall all0.0.0.0/0 ldap ldapserver=server1.com ldapserver=server2.com ldapprefix=PROD01\ So documentation need some update. Regards, Virendra -Original Message- From: Alvaro Herrera [mailto:alv

RE: Multiple LDAP Servers for ldap Authentication

Hi Alvaro, Tried with a comma and a space but it timed out one more time: -- 2018-12-20 14:34:56.070 CST [64618] FATAL: canceling authentication due to timeout Okay, so how would I configure openldap to try another ldap server in x amount of time if first one is not working. Regards, Virendra

Re: Amazon Aurora

Glen, I think your question can be posted here for a better response: https://forums.aws.amazon.com/forum.jspa?forumID=227 Original Message On Thu, Dec 20, 2018, at 3:57 PM, Glenn Schultz wrote: > > I have a Postgres database of about 1.5 terabytes on amazon aurora.

Re: Change from 9.6 to 11?

Chuck Martin writes: > I hope someone here can see something that eludes me. I've recently moved a > database from PostgreSQL 9.6 to 11, and there are a few oddities. The > following select statement returns zero rows when it should return one. > This is one of a small number of records that exist

Re: Watching for view changes

On 12/20/18 2:20 PM, Mitar wrote: Hi! On Thu, Dec 20, 2018 at 12:07 PM Rob Sargent wrote: Are you hoping to see the difference in the returned values for successive calls to the same query? i would like to in as close to real-time as possible get notification when results of a query would ha

Amazon Aurora

I have a Postgres database of about 1.5 terabytes on amazon aurora. It runs super slow. Has anyone experienced this and if so how was the problem addressed? Glenn Sent from my iPhone

Re: Change from 9.6 to 11?

Hello, this seems as if some data was missing on a joined table ... could you compare the result of EXPLAIN ANALYZE for that statement between both databases ? and maybe share them ? Regards PAscal -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

RE: Watching for view changes

From: Mitar > On Thu, Dec 20, 2018 at 12:07 PM Rob Sargent wrote: > > Are you hoping to see the difference in the returned values for successive > > calls to the same query? > > i would like to in as close to real-time as possible get notification when > results of a query would have changed i

Change from 9.6 to 11?

I hope someone here can see something that eludes me. I've recently moved a database from PostgreSQL 9.6 to 11, and there are a few oddities. The following select statement returns zero rows when it should return one. This is one of a small number of records that exist, but are not returned by the

Re: Multiple LDAP Servers for ldap Authentication

On 2018-Dec-20, Kumar, Virendra wrote: > Comman separated doesn't work as well. Please separate by a comma and a space, not just a comma. My reading of the OpenLDAP source code, and some quick experiments comparing failure patterns, suggest that that exact combination may work. (OpenLDAP is not

Re: Watching for view changes

Hi! On Thu, Dec 20, 2018 at 12:07 PM Rob Sargent wrote: > Are you hoping to see the difference in the returned values for successive > calls to the same query? i would like to in as close to real-time as possible get notification when results of a query would have changed if I would do the same

Re: Watching for view changes

Hi! On Thu, Dec 20, 2018 at 8:11 AM Mike Rylander wrote: > If, as I assume, the FROM clause of the SELECT is essentially static, > just with varying WHERE conditions, you could just use an AFTER > INSERT/UPDATE/DELETE trigger on each of the tables involved to send a > NOTIFY whenever data that is

Re: Watching for view changes

> On Dec 20, 2018, at 1:04 PM, Mitar wrote: > > Hi! > > Ah, that was a thread about table changes. I am interested in data > changes (results from a query). > > Thanks. > Are you hoping to see the difference in the returned values for successive calls to the same query?

Re: Watching for view changes

Hi! Ah, that was a thread about table changes. I am interested in data changes (results from a query). Thanks. Mitar On Thu, Dec 20, 2018 at 8:01 AM Adrian Klaver wrote: > > On 12/20/18 7:54 AM, Mitar wrote: > > Hi! > > > > Thanks. Care for a link or at least thread subject? > > https://www.p

RE: Multiple LDAP Servers for ldap Authentication

[postgres@xxx ~]$ rpm -qf /lib64/libldap-2.4.so.2 openldap-2.4.44-20.el7.x86_64 Regards, Virendra -Original Message- From: Alvaro Herrera [mailto:alvhe...@2ndquadrant.com] Sent: Thursday, December 20, 2018 2:01 PM To: Kumar, Virendra Cc: pgsql-general@lists.postgresql.org Subject: Re:

RE: Multiple LDAP Servers for ldap Authentication

Comman separated doesn't work as well. Regards, Virendra -Original Message- From: Alvaro Herrera [mailto:alvhe...@2ndquadrant.com] Sent: Thursday, December 20, 2018 2:21 PM To: Kumar, Virendra Cc: pgsql-general@lists.postgresql.org Subject: Re: Multiple LDAP Servers for ldap Authenticati

Re: Multiple LDAP Servers for ldap Authentication

On 2018-Dec-20, Kumar, Virendra wrote: > I am going through ldap authentication documents in PostgreSQL and found that > we can specify multiple ldap servers but sure how. I have put two entries in > double quotes like below: > -- > hostall all0.0.0.0/0

Re: Multiple LDAP Servers for ldap Authentication

On 2018-Dec-20, Kumar, Virendra wrote: > This is what I see: > -- > [postgres@usdf24v0131 ~]$ which postgres > /opt/postgres/10/bin/postgres > [postgres@usdf24v0131 ~]$ ldd /opt/postgres/10/bin/postgres > linux-vdso.so.1 => (0x7ffee3fe8000) > libpthread.so.0 => /lib64/libpthre

RE: Multiple LDAP Servers for ldap Authentication

This is what I see: -- [postgres@usdf24v0131 ~]$ which postgres /opt/postgres/10/bin/postgres [postgres@usdf24v0131 ~]$ ldd /opt/postgres/10/bin/postgres linux-vdso.so.1 => (0x7ffee3fe8000) libpthread.so.0 => /lib64/libpthread.so.0 (0x7f9a7f125000) librt.so.1 => /li

Re: Multiple LDAP Servers for ldap Authentication

Hello Virendra On 2018-Dec-20, Kumar, Virendra wrote: > I am going through ldap authentication documents in PostgreSQL and found that > we can specify multiple ldap servers but sure how. I have put two entries in > double quotes like below: > -- > hostall all

Re: Watching for view changes

On Thu, Dec 20, 2018 at 4:17 AM Mitar wrote: > > Hi! > > I am trying to see how I could use NOTIFY/LISTEN to watch changes of a > complicated SELECT query which spans multiple tables. Ideally, I would > like to leave to PostgreSQL to determine when some data (and which > data) in the result of the

Multiple LDAP Servers for ldap Authentication

Hi, I am going through ldap authentication documents in PostgreSQL and found that we can specify multiple ldap servers but sure how. I have put two entries in double quotes like below: -- hostall all0.0.0.0/0 ldap ldapserver="server1.com server2

Re: Watching for view changes

On 12/20/18 7:54 AM, Mitar wrote: Hi! Thanks. Care for a link or at least thread subject? https://www.postgresql.org/message-id/CA%2BFnnTxqScf6mDw_7HLMfu7YTagPrsYUw-bc%3DOKsBQ0TqprvEA%40mail.gmail.com Also, Googling around this seems a pretty popular request. I am quite surprised that there

Re: Watching for view changes

Hi! Thanks. Care for a link or at least thread subject? Also, Googling around this seems a pretty popular request. I am quite surprised that there is not something out-of-box available for this, efficient and scalable. Mitar On Thu, Dec 20, 2018 at 7:33 AM Ron wrote: > > On 12/20/18 3:17 AM,

Re: Watching for view changes

On 12/20/18 3:17 AM, Mitar wrote: Hi! I am trying to see how I could use NOTIFY/LISTEN to watch changes of a complicated SELECT query which spans multiple tables. Ideally, I would like to leave to PostgreSQL to determine when some data (and which data) in the result of the SELECT query has chang

Re: libpq PQexecParams & value placeholders

On Fri, Dec 14, 2018 at 6:09 AM Oleg wrote: > > On Fri, Dec 14, 2018 at 02:47:12PM +0300, Dmitry Igrishin wrote: > > пт, 14 дек. 2018 г. в 14:33, Oleg : > > > > > > Hi, all. > > > > > > Do we really need a numeric value placeholders like $1 in command string? > > It's a syntax defined at the backe

Re: PostgreSQL version compatibility with RHEL7.6

2018年12月20日(木) 19:56 Deepti Sharma S : > Hello Team, > > > > Can you please let us know which version of PostgreSQL DB is compatible > with RHEL7.6 and if not available when we can expect the same. > Community packages for all community-supported PostgreSQL versions (at the time of writing: 9.4 ~

Re: Wals not recycling

2018年12月20日(木) 21:18 Rijo Roy : > > Hi All, > > I am facing an issue with wal recycling in one of my Postgresql servers > running ina rhel box and the PG version is 10. The issue is that wal files > are not recycling at all. Please note that its a qa server and the load is > quite high on it. It

Wals not recycling

Hi All,  I am facing an issue with wal recycling in one of my Postgresql servers running ina rhel box and the PG version is 10. The issue is that wal files are not recycling at all. Please note that its a qa server and the load is quite high on it. It is running in no archive mode with fsync o

PostgreSQL version compatibility with RHEL7.6

Hello Team, Can you please let us know which version of PostgreSQL DB is compatible with RHEL7.6 and if not available when we can expect the same. [Ericsson] DEEPTI SHARMA Specialist ITIL 2011 Foundation Certified BDGS, R&D Ericsson 3rd Floor, ASF Insignia - Block B Ki

Watching for view changes

Hi! I am trying to see how I could use NOTIFY/LISTEN to watch changes of a complicated SELECT query which spans multiple tables. Ideally, I would like to leave to PostgreSQL to determine when some data (and which data) in the result of the SELECT query has changed. So I am thinking that creating a