Re: LDAP authenticated session terminated by signal 11: Segmentation fault, PostgresSQL server terminates other active server processes

Hi Tom, when I run "ldd /usr/pgsql-10/bin/postmaster" I got this output: # ldd /usr/pgsql-10/bin/postmaster linux-vdso.so.1 => (0x7ffd4ec65000) libpthread.so.0 => /lib64/libpthread.so.0 (0x7eff8b5d3000) libxml2.so.2 => /lib64/libxml2.so.2 (0x7eff8b268000) libpam.so.0 => /lib64/libpam.

Re: Logical replication very slow

On 25/2/19 8:52 π.μ., Boris Sagadin wrote: Doing an initial replica and trying to find a bottleneck, Ubuntu 16.04, NVMe disks, PgSQL v10.7, AWS. With binary replication, DB is replicated at good speed, around 500MB/s. Trying LR now for a big table (about 1.4TB with 2 indexes) and the speed is onl

Logical replication very slow

Doing an initial replica and trying to find a bottleneck, Ubuntu 16.04, NVMe disks, PgSQL v10.7, AWS. With binary replication, DB is replicated at good speed, around 500MB/s. Trying LR now for a big table (about 1.4TB with 2 indexes) and the speed is only about 2MB/s. Checked disk util with iostat

Re: Recommended way to enable data-checksums on Centos 7?

On 2/24/19 2:39 PM, Ken Tanzer wrote: Hi.  I recently installed PG 11.2 on Centos 7, following the excellent directions at . I wanted to enable data-checksums.  I at first tried appending --data-checksums to the doc-specified command: /usr/pgsql-11/bin/postgresql-11-setup initdb --data-ch

Property Graph Query Language proposed for SQL:2020

Hi, Anyone aware and following this standardization activities? Forthcoming SQL:2020 seems to contain "Property Graph Query Extensions". See: * GQL: a standard for property graph querying https://www.gqlstandards.org/ * Property Graph Query Language (PGQL), an SQL-like query language for graphs, i

Recommended way to enable data-checksums on Centos 7?

Hi. I recently installed PG 11.2 on Centos 7, following the excellent directions at https://www.postgresql.org/download/linux/redhat/. I wanted to enable data-checksums. I at first tried appending --data-checksums to the doc-specified command: /usr/pgsql-11/bin/postgresql-11-setup initdb --data

Re: Future Non-server Windows support???

On 2/24/19 1:04 PM, Jeff Janes wrote: On Sun, Feb 24, 2019 at 3:10 PM Adrian Klaver > wrote: On 2/24/19 10:38 AM, Jeff Janes wrote: > On Sun, Feb 24, 2019 at 7:06 AM Bill Haught mailto:wlhaught4754...@att.net> >

Re: Future Non-server Windows support???

On Sun, Feb 24, 2019 at 3:10 PM Adrian Klaver wrote: > On 2/24/19 10:38 AM, Jeff Janes wrote: > > On Sun, Feb 24, 2019 at 7:06 AM Bill Haught > > wrote: > > > > I noticed that for 11.2, non-server versions of Windows are not > listed > > as supported platf

Re: Future Non-server Windows support???

On 2/24/19 10:38 AM, Jeff Janes wrote: On Sun, Feb 24, 2019 at 7:06 AM Bill Haught > wrote: I noticed that for 11.2, non-server versions of Windows are not listed as supported platforms. Listed where?  The only thing I see is "Windows (Win2000 SP4 and

Re: Future Non-server Windows support???

On Sun, Feb 24, 2019 at 7:06 AM Bill Haught wrote: > I noticed that for 11.2, non-server versions of Windows are not listed > as supported platforms. Listed where? The only thing I see is "Windows (Win2000 SP4 and later)", and that isn't a list and surely there are non-server versions of Windo

Re: Foreign table & Connection reset by peer

On 2/24/19 2:25 AM, Lukáš Sobotka wrote: Thanks for quick answer. I am feeling a little embarrassed that I did not find this before... The thread definitely helped me to understand more. When I execute query with foreign tables, the connection is created (according pg_stat_activity). The quest

Re: Future Non-server Windows support???

On 2/24/19 4:05 AM, Bill Haught wrote: I noticed that for 11.2, non-server versions of Windows are not listed as supported platforms.  Is support in the process of being dropped for Did you look here?: https://www.openscg.com/bigsql/postgresql/installers.jsp/ non-server editions of Windows w

Re: Future Non-server Windows support???

Bill Haught writes: > I noticed that for 11.2, non-server versions of Windows are not listed > as supported platforms. Is support in the process of being dropped for > non-server editions of Windows when 10.7 is no longer supported > (apparently years away though)? Or will such support be add

Re: Size estimation of postgres core files

On 2019-02-15 13:01:50 -0600, Jeremy Finzel wrote: > It doesn't write out all of RAM, only the amount in use by the > particular backend that crashed (plus all the shared segments attached > by that backend, including the main shared_buffers, unless you disable > that as previously

Future Non-server Windows support???

I noticed that for 11.2, non-server versions of Windows are not listed as supported platforms. Is support in the process of being dropped for non-server editions of Windows when 10.7 is no longer supported (apparently years away though)? Or will such support be added to 11.2 or some later ver

Re: Foreign table & Connection reset by peer

Thanks for quick answer. I am feeling a little embarrassed that I did not find this before... The thread definitely helped me to understand more. When I execute query with foreign tables, the connection is created (according pg_stat_activity). The question is what I should do for ending the connec

Re: WSL (windows subsystem on linux) users will need to turn fsync off as of 11.2

>> > Great. Thanks for testing, and for the fix! Well that all sounds >> > like good news: it corrects the behaviour from 11.2, and also improves >> > on the previous behaviour which I'd have accepted as a bug if anyone >> > had reported it. So the next problem is that we don't have a >> > conse