Re: Multi-insert into a partitioned table with before insert row trigger causes server crash on latest HEAD

2018-10-20 Thread David Rowley
On 21 October 2018 at 04:03, Ashutosh Sharma wrote: >> Thanks for pushing that fix. >> >> Originally my patch in [1] only could set leafpart_use_multi_insert to >> true within the `if (insertMethod == CIM_MULTI_CONDITIONAL)` test, so >> wouldn't have suffered from this problem. >> > > The problem

Re: gemulon migration upcoming

2018-10-20 Thread Tom Lane
Stefan Kaltenbrunner writes: > On 10/20/18 6:15 PM, Tom Lane wrote: >> Stefan Kaltenbrunner writes: >> Maybe that's just me, but it's happening through two different ISPs. > hmm - please try again now... Ah, I get a connection now. >> I tried flushing local nameserver cache, but it doesn't

Re: gemulon migration upcoming

2018-10-20 Thread Stefan Kaltenbrunner
On 10/20/18 6:15 PM, Tom Lane wrote: > Stefan Kaltenbrunner writes: >> migration completed > > Hmm ... > > ssh: connect to host gitmaster.postgresql.org port 22: Network is unreachable > > Maybe that's just me, but it's happening through two different ISPs. hmm - please try again now... > >

Re: gemulon migration upcoming

2018-10-20 Thread Tom Lane
Stefan Kaltenbrunner writes: > migration completed Hmm ... ssh: connect to host gitmaster.postgresql.org port 22: Network is unreachable Maybe that's just me, but it's happening through two different ISPs. I tried flushing local nameserver cache, but it doesn't seem that gemulon's IP address

Re: gemulon migration upcoming

2018-10-20 Thread Stefan Kaltenbrunner
On 10/20/18 4:48 PM, Stefan Kaltenbrunner wrote: > Hi all! > > As mentioned in: > > https://www.postgresql.org/message-id/c29f7334-6695-512f-905a-919c1be676fd%40kaltenbrunner.cc > > we are will migrate gemulon (aka gitmaster) to a different datacenter > today (20.10.2018) at ~16:00 UTC. > >

Re: Multi-insert into a partitioned table with before insert row trigger causes server crash on latest HEAD

2018-10-20 Thread Ashutosh Sharma
> Thanks for pushing that fix. > > Originally my patch in [1] only could set leafpart_use_multi_insert to > true within the `if (insertMethod == CIM_MULTI_CONDITIONAL)` test, so > wouldn't have suffered from this problem. > The problem is reproducible even with the patch in [1] combined with the

gemulon migration upcoming

2018-10-20 Thread Stefan Kaltenbrunner
Hi all! As mentioned in: https://www.postgresql.org/message-id/c29f7334-6695-512f-905a-919c1be676fd%40kaltenbrunner.cc we are will migrate gemulon (aka gitmaster) to a different datacenter today (20.10.2018) at ~16:00 UTC. actualy downtime is expected to only last for ~15 minutes - will send a

Re: pgsql: Add TAP tests for pg_verify_checksums

2018-10-20 Thread Michael Paquier
On Sat, Oct 20, 2018 at 02:03:32AM -0400, Stephen Frost wrote: > On Sat, Oct 20, 2018 at 01:11 Andres Freund wrote: >> or the new checksum validation logic complaining about them, and such >>> when doing backups and I wonder if that is because people simply don’t >>> use the two together much,

Re: pgsql: Add TAP tests for pg_verify_checksums

2018-10-20 Thread Stephen Frost
Greetings, On Sat, Oct 20, 2018 at 01:11 Andres Freund wrote: > Hi, > > On 2018-10-20 01:07:43 -0400, Stephen Frost wrote: > > I have to say that I can’t recall hearing much in the way of complaints > > about pg_basebackup copying all the random cstore files > > Why would somebody complain