Re: libpq read/write

2019-03-30 Thread Samuel Williams
Tom, you seem to know everything related to Postgres, so thanks for your time and answers. I'm blown away by your dedication and knowledge. Regarding PQisBusy, and similar, even for "non-blocking" behaviour, you are essentially expecting the user to have their own event loop, and only invoke the r

Re: stale WAL files?

2019-03-30 Thread Gmail
> On Mar 30, 2019, at 10:54 AM, Gmail wrote: > > On Mar 29, 2019, at 6:58 AM, Michael Paquier wrote: >>> >>> On Thu, Mar 28, 2019 at 09:53:16AM -0600, Rob Sargent wrote: >>> This is pg10 so it's pg_wal. ls -ltr >>> >>> >>> -rw---. 1 postgres postgres 16777216 Mar 16 16:33 >>> 00

Re: CVE-2019-9193 about COPY FROM/TO PROGRAM

2019-03-30 Thread Tom Lane
"Daniel Verite" writes: > I've noticed this post being currently shared on social media: > https://www.trustwave.com/en-us/resources/blogs/spiderlabs-blog/cve-2019-9193-authenticated-arbitrary-command-execution-on-postgresql-9-3/ > The claim that COPY FROM PROGRAM warrants a CVE seems groundless

CVE-2019-9193 about COPY FROM/TO PROGRAM

2019-03-30 Thread Daniel Verite
Hi, I've noticed this post being currently shared on social media: https://www.trustwave.com/en-us/resources/blogs/spiderlabs-blog/cve-2019-9193-authenticated-arbitrary-command-execution-on-postgresql-9-3/ The claim that COPY FROM PROGRAM warrants a CVE seems groundless because you need to be

Re: stale WAL files?

2019-03-30 Thread Gmail
> On Mar 29, 2019, at 6:58 AM, Michael Paquier wrote: > >> On Thu, Mar 28, 2019 at 09:53:16AM -0600, Rob Sargent wrote: >> This is pg10 so it's pg_wal. ls -ltr >> >> >> -rw---. 1 postgres postgres 16777216 Mar 16 16:33 >> 00010CEA00B1 >> -rw---. 1 postgres postgres 167772

Re: Regarding pgaudit log_directory

2019-03-30 Thread David Steele
On 3/29/19 3:32 PM, Durgamahesh Manne wrote:   I could not find parameter related to pgaudit log_directory  . pgAudit does not support logging outside the standard PostgreSQL logging facility and there are no plans for such a feature. The general solution is to use Splunk, ELK, etc. to do

Re: libpq read/write

2019-03-30 Thread Tom Lane
Samuel Williams writes: > I've been doing some profiling and I was surprised to see that libpq uses > epoll when handling what essentially amounts to blocking reads/writes. Yup. > I was just wondering why it needed to be so complicated? So that we can also support nonblocking behavior (cf PQisB

Re: Required postgreSQL 10.4 version for Suse enterprise

2019-03-30 Thread Adrian Klaver
On 3/30/19 4:09 AM, Ankit Trivedi wrote: Dear Team, I want to install postgreSQL 10.4 version in my suse linux Enterprise but i am not able to find repo file for version 10.4. Did you look here?: https://zypp.postgresql.org/howtozypp.php Please help me for the same. Thanks & Regards, *An

Re: stale WAL files?

2019-03-30 Thread Gmail
> On Mar 29, 2019, at 6:58 AM, Michael Paquier wrote: > >> On Thu, Mar 28, 2019 at 09:53:16AM -0600, Rob Sargent wrote: >> This is pg10 so it's pg_wal. ls -ltr >> >> >> -rw---. 1 postgres postgres 16777216 Mar 16 16:33 >> 00010CEA00B1 >> -rw---. 1 postgres postgres 16777

Required postgreSQL 10.4 version for Suse enterprise

2019-03-30 Thread Ankit Trivedi
Dear Team, I want to install postgreSQL 10.4 version in my suse linux Enterprise but i am not able to find repo file for version 10.4. Please help me for the same. Thanks & Regards, *Ankit Trivedi,* Sysem Admin - IT ankit.triv...@nascentinfo.com +91-9408771306 [image: Nascent Info Technologies Pv

libpq read/write

2019-03-30 Thread Samuel Williams
I've been doing some profiling and I was surprised to see that libpq uses epoll when handling what essentially amounts to blocking reads/writes. https://github.com/postgres/postgres/blob/fc22b6623b6b3bab3cb057ccd282c2bfad1a0b30/src/backend/libpq/pqcomm.c#L207-L227 https://github.com/postgres/post