Re: Inserts restricted to a trigger

On 6/20/19 3:30 PM, Miles Elam wrote: Thanks for the reply, Adrian. 1. The audit tables (plural) are recording the historical data for a table, ie., updates and deletes. All the same data as found in a given table along with the role that performed the operation, the transaction id, and the

Re: Index with new opclass not used for sorting

On 21/06/2019 15:36, Tom Lane wrote: > Ancoron Luciferis writes: >> I am creating a new operator class for version 1 UUID's with an >> extension and thought I was almost done by implementing everything >> including SortSupport and creating a new opclass as follows: > >> CREATE OPERATOR CLASS

Re: got stuck in pglogical upgrade on FreeBSD

Yes, I did install via source using gmake as make command was not working. I also need to include some (.h) header file as gmake throwing some dependency error. On Fri, 21 Jun, 2019, 9:41 PM Adrian Klaver, wrote: > On 6/21/19 9:07 AM, Rahul Chordiya wrote: > > Yes and yes. > > Also tried to

Re: got stuck in pglogical upgrade on FreeBSD

Yes and yes. Also tried to completely clear slave data directory and setup fresh subscribe & subscription. On Fri, 21 Jun, 2019, 9:35 PM Adrian Klaver, wrote: > On 6/21/19 8:45 AM, Rahul Chordiya wrote: > > Yes, > > Both machine in same network and I'm able to connect using psql from one > >

Logical decoding plus streaming replication fail-over

Hello, Did anybody solve a problem of logical replication slot fail-over on a streaming replication cluster? I have a logical decoding on a logical replication slot set up on a streaming replication master. Streaming replication does not propagate the replication slot state. In case of

Re: got stuck in pglogical upgrade on FreeBSD

On 6/21/19 9:25 AM, Rahul Chordiya wrote: Yes, I did install via source using gmake as make command was not working. I also need to include some (.h) header file as gmake throwing some dependency error. The errors and the header files are? On Fri, 21 Jun, 2019, 9:41 PM Adrian Klaver,

Re: got stuck in pglogical upgrade on FreeBSD

On 6/21/19 9:07 AM, Rahul Chordiya wrote: Yes and yes. Also tried to completely clear slave data directory and setup fresh subscribe & subscription. I assume you compiled it from source. Where there any errors in the make and/or install stops? Does the system log show anything relevant?

Re: got stuck in pglogical upgrade on FreeBSD

On 6/21/19 8:45 AM, Rahul Chordiya wrote: Yes, Both machine in same network and I'm able to connect using psql from one machine to another. Log only show that it is starting pglogical manager on database. On both clusters right? I tried to set log servirity to debug but I don't think it

Re: got stuck in pglogical upgrade on FreeBSD

Yes, Both machine in same network and I'm able to connect using psql from one machine to another. Log only show that it is starting pglogical manager on database. I tried to set log servirity to debug but I don't think it is set properly. On Fri, 21 Jun, 2019, 7:45 PM Adrian Klaver, wrote: >

Re: How can generate alter sequence and drop constraints statements via ora2pg

On 6/19/19 11:38 PM, Daulat Ram wrote: Hi All, Any one can give me an idea how we can generate the alter sequence and drop constraints scripts /statements for a schema tables using ora2pg.conf To clarify you want to run ora2pg against an Oracle install and have it only pull out the alter

Re: Builds of 11.4 for CentOS/RHEL 7 missing

On 6/21/19 7:33 AM, Gabríel Arthúr Pétursson wrote: Huh, that changed while I trying to figure it out:) Now it is there: https://yum.postgresql.org/testing/11/redhat/rhel-7-x86_64/ postgresql11-server-11.4-1PGDG.rhel7.x86_64.rpm Perfect. Thank you very much! The thanks are due to whoever

Re: Builds of 11.4 for CentOS/RHEL 7 missing

> Huh, that changed while I trying to figure it out:) > > Now it is there: > > https://yum.postgresql.org/testing/11/redhat/rhel-7-x86_64/ > > postgresql11-server-11.4-1PGDG.rhel7.x86_64.rpm Perfect. Thank you very much!

Re: Builds of 11.4 for CentOS/RHEL 7 missing

> Are you sure?: > > https://yum.postgresql.org/testing/11/redhat/rhel-7-x86_64/repoview/postgresql11-server.html Yes, I'm sure. The RPM link there for 11.4 gives a 404 Not Found error.

Re: R: Problem with row-level lock

On 6/21/19 1:40 AM, Job wrote: Dear Adrian, thank you for the reply! i am struggling with a problem due, sometime, to a double concurrent update on the same row of a table. What is the error message you get? We have no error, but the two queries, in "Lock wait", keep stucked for some

Re: Builds of 11.4 for CentOS/RHEL 7 missing

On 6/21/19 7:12 AM, Gabríel Arthúr Pétursson wrote: Are you sure?: https://yum.postgresql.org/testing/11/redhat/rhel-7-x86_64/repoview/postgresql11-server.html Yes, I'm sure. The RPM link there for 11.4 gives a 404 Not Found error. Huh, that changed while I trying to figure it out:) Now

Re: got stuck in pglogical upgrade on FreeBSD

On 6/21/19 6:42 AM, Rahul Chordiya wrote: Hi, I'm trying to replicate data using pglogical https://2ndquadrant.com/en/resources/pglogical/pglogical-docs/ In my testing on local network machine and amazon linux test machine

Re: Builds of 11.4 for CentOS/RHEL 7 missing

On 6/21/19 4:26 AM, Gabríel Arthúr Pétursson wrote: Hi, It appears that the RPM packages for PostgreSQL 11.4 are missing for CentOS/RHEL 7. They are not showing up in the repository's directory listing [1], nor when running `yum update`. Are you sure?:

R: Problem with row-level lock

Dear Adrian, thank you for the reply! >> i am struggling with a problem due, sometime, to a double concurrent update >> on the same row of a table. >What is the error message you get? We have no error, but the two queries, in "Lock wait", keep stucked for some minutes before completed. Are

got stuck in pglogical upgrade on FreeBSD

Hi, I'm trying to replicate data using pglogical https://2ndquadrant.com/en/resources/pglogical/pglogical-docs/ In my testing on local network machine and amazon linux test machine I have successfully setup the replication,

Builds of 11.4 for CentOS/RHEL 7 missing

Hi, It appears that the RPM packages for PostgreSQL 11.4 are missing for CentOS/RHEL 7. They are not showing up in the repository's directory listing [1], nor when running `yum update`. Is it possible to get them uploaded? Thanks in advance, Gabríel [1]

Re: Why does the pg_dumpall command have a database option?

On 6/21/19 6:32 AM, Espresso Beanies wrote: Will it still dump all of the databases or just the one it connects to? It will dump all the databases. It is just that pg_dumpall is a client to the server and therefore needs to connect to a database within the cluster to do it's work. That is

Re: Why does the pg_dumpall command have a database option?

On 21/06/2019 14:32, Espresso Beanies wrote: Will it still dump all of the databases or just the one it connects to? On Thu, Jun 20, 2019 at 4:13 PM Adrian Klaver > wrote: On 6/20/19 1:03 PM, Espresso Beanies wrote: > I'm trying to see if someone

Re: Index with new opclass not used for sorting

Ancoron Luciferis writes: > I am creating a new operator class for version 1 UUID's with an > extension and thought I was almost done by implementing everything > including SortSupport and creating a new opclass as follows: > CREATE OPERATOR CLASS uuid_timestamp_ops FOR TYPE uuid > USING

Re: Why does the pg_dumpall command have a database option?

Will it still dump all of the databases or just the one it connects to? On Thu, Jun 20, 2019 at 4:13 PM Adrian Klaver wrote: > On 6/20/19 1:03 PM, Espresso Beanies wrote: > > I'm trying to see if someone could answer to me why the pg_dumpall > > command has a database option when it's designed

'too many range table entries' error with partitioned tables and aggregations

Hi all, Recently we hit a strange 'too many range table entries' error for some particular queries in our database. Some googling revealed that it's an uncommon error usually occurring due to strange database design [1]. However, I feel like the case in which it occurs this time, although

Re: Row data is reflected in DETAIL message when constraints fail on insert/update

On Thu, Jun 20, 2019 at 12:16:53PM -0400, Tom Lane wrote: > Admittedly, in your example there's a difference between what "the app" > should know and what "the user using the app" should know. But I'm not > really seeing how Postgres could usefully model that situation. We have > no idea about

Active connections are terminated because of small wal_sender_timeout

Hello PostgreSQL Community! Not long ago I opened an issue regarding the problem about: "terminating walsender process due to replication timeout" problem: https://www.postgresql.org/message-id/OF85C33E30.171C1C23-ON432583F9.003F5B16-432583F9.003FBAD7%40iba.by Thanks Everyone for your

Index with new opclass not used for sorting

Hi, I am creating a new operator class for version 1 UUID's with an extension and thought I was almost done by implementing everything including SortSupport and creating a new opclass as follows: CREATE OPERATOR CLASS uuid_timestamp_ops FOR TYPE uuid USING btree AS OPERATOR1