Re: Server goes to Recovery Mode when run a SQL

2019-02-04 Thread PegoraroF10
Nothing was change, Postgres 10, Ubuntu 16.04 and Schema was the same, before and after that problem. Well, that database is replicated and on replicated server that problem doesn´t occur. -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

Need details on 9.6 version of postgres

2019-02-04 Thread A H S Phanindra
Hi, I am using Jboss EAP 6.1 version. For Database i am using the postgres 9.3 version. Can i upgrade to postgres 9.6 without any issue. I am also considering to implement BDR 2.0, please let me know how i can get the licensing details. -- with regards A H S Phanindra

Re: Need details on 9.6 version of postgres

2019-02-04 Thread Adrian Klaver
On 2/4/19 2:10 AM, A H S Phanindra wrote: Hi,     I am using Jboss EAP 6.1 version.  For Database i am using the postgres 9.3 version. Can i upgrade to postgres 9.6 without any issue. I Don't know. A place you might find out: https://developer.jboss.org/en/products/eap am also considering

Re: Server goes to Recovery Mode when run a SQL

2019-02-04 Thread Adrian Klaver
On 2/4/19 3:13 AM, PegoraroF10 wrote: Nothing was change, Postgres 10, Ubuntu 16.04 and Schema was the same, before and after that problem. Well something changed or you would not be having a problem. Well, that database is replicated and on replicated server that problem doesn´t occur. Def

Re: Need details on 9.6 version of postgres

2019-02-04 Thread Andreas Kretschmer
Am 04.02.19 um 11:10 schrieb A H S Phanindra: Hi,     I am using Jboss EAP 6.1 version.  For Database i am using the postgres 9.3 version. Can i upgrade to postgres 9.6 without any issue. should work, but you should test it. I am also considering to implement BDR 2.0, please let me know ho

Re: Server goes to Recovery Mode when run a SQL

2019-02-04 Thread PegoraroF10
About replication ... Logical Replication with CREATE PUBLICATION/SUBSCRIPTION. Yes, some DDL commands were ran on that server but none of them were related with that select. Let me explain better. We have a single server with a single database on it. Each customer has its own schema and connects

Re: Server goes to Recovery Mode when run a SQL

2019-02-04 Thread Adrian Klaver
On 2/4/19 7:33 AM, PegoraroF10 wrote: About replication ... Logical Replication with CREATE PUBLICATION/SUBSCRIPTION. Yes, some DDL commands were ran on that server but none of them were related with that select. Let me explain better. We have a single server with a single database on it. Each c

Re: JSONB Array of Strings (with GIN index) versus Split Rows (B-Tree Index)

2019-02-04 Thread Ian Zimmerman
On 2019-02-04 05:34, Syed Jafri wrote: > |-|--|-|--| > | Receiver | Event | Date| > Location| > |-|--|-|--

Re: JSONB Array of Strings (with GIN index) versus Split Rows (B-Tree Index)

2019-02-04 Thread David G. Johnston
On Sun, Feb 3, 2019 at 10:35 PM Syed Jafri wrote: > · Receiver names are of the type (a-z, 1-5, .) > > · 95% of all queries currently look like this: SELECT * FROM table > WHERE Receiver = Alpha, with the new format this would be SELECT * FROM table > WHERE receivers @> '"Alpha"'

Re: Server goes to Recovery Mode when run a SQL

2019-02-04 Thread rob stone
Olá Marcos, On Mon, 2019-02-04 at 08:33 -0700, PegoraroF10 wrote: > About replication ... Logical Replication with CREATE > PUBLICATION/SUBSCRIPTION. > > Yes, some DDL commands were ran on that server but none of them were > related > with that select. > Let me explain better. We have a single se