[GENERAL] tx canceled on standby despite infinite max_standby_streaming_delay

I'm seeing long-running transactions (pg_dump) canceled on the standby when there are a lot of inserts happening on the master. This despite my having set max_standby_streaming_delay to -1 on the standby. Why might that happen? This is pg 9.3.12. When it happens I see: pg_dump: Dumping the con

[GENERAL] Foreign key triggers

Hi, I was trying to clean a database by deleting records of some of its tables. But in our model we have a table that is heavily referenced, that is, many tables reference this particular table by foreign key constraints. We don't have foreign key indexes, so executing a delete from mytable takes

Re: [GENERAL] EINTR causes panic (data dir on btrfs)

On 13-05-2016 19:04, Alvaro Herrera wrote: I happened to notice this report from 15 months ago, which didn't get any response. Did you find a solution to this problem? I would first blame btrfs, mostly because I've never heard of anyone with this problem on more mainstream filesystems. As I r

Re: [GENERAL] EINTR causes panic (data dir on btrfs)

Alvaro Herrera writes: > Gustavo Lopes wrote: >> ... Why wouldn't postgres retry on EINTR or even >> allow return values of write() lower than nbytes (and then continue in a >> loop). > I happened to notice this report from 15 months ago, which didn't get > any response. Did you find a solution

Re: [GENERAL] Using both ident and password in pg_hba.conf

On Tue, 10 May 2016 11:20:05 -0400 "D'Arcy J.M. Cain" wrote: > On Tue, 10 May 2016 10:46:39 -0400 > George Neuner wrote: > > On Linux (or Unix) you'd set up a forwarding record in iptables that > > redirects a second port to Postgresql. > > Forwarding to a different host is bad enough without e

Re: [GENERAL] EINTR causes panic (data dir on btrfs)

Gustavo Lopes wrote: > Every few weeks, I'm getting a error like this: > > > 2015-02-11 15:31:00 CET PANIC: could not write to log file > > 00010007007D at offset 1335296, length 8192: Interrupted system > > call > > 2015-02-11 15:31:00 CET STATEMENT: COMMIT > > 2015-02-11 15:31:17 C

Re: [GENERAL] Update or Delete causes canceling of long running slave queries

Hi, Thank you for the explanation. The slave queries are mostly reporting queries,which sometimes would take 30+ running time due to complex joins and criteria. We haven't tried running these queries on master before splitting, and it is possible that there will be heavy updates and deletes on mast

Re: [GENERAL] Share my experience and Thank you !

Hello, I think that you can safely add the PostgreSQL repository to your system, so that you can get the latest packages for your Debian. See there how to do it: https://wiki.postgresql.org/wiki/Apt Regards, Pierre Le 13 mai 2016 09:14:28 GMT+02:00, JingYuan Chen a écrit : >I use Debian Whe

Re: [GENERAL] Share my experience and Thank you !

I use Debian Wheezy and PostgreSQL 9.1 is the default package. On Fri, May 13, 2016 at 3:13 PM, JingYuan Chen wrote: > I use Debian Wheezy and PostgreSQL 9.1 is the default package. > > On Fri, May 13, 2016 at 3:06 PM, Arthur Silva wrote: > >> Any specific reason for choosing this old version o

Re: [GENERAL] Share my experience and Thank you !

Any specific reason for choosing this old version of postgres? On May 13, 2016 8:46 AM, "JingYuan Chen" wrote: > Hello, > > I want to share my experience about one of my projects and say thank you > to the community. > > Scenario : > My company's ERP system is SAP and rent a procurement system fo