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

Hi all, I have encountered a problem related to LDAP authenticated session with Postgres foreign data wrapper (postgres_fdw). The server crashed with following errors and other active server processes are terminated as well: 2019-02-20 14:53:30.496 SGT [PID=1353 application="" user_name= database=

RE: Implementing pgaudit extension on Microsoft Windows

Joe, and others I did not submit an issue. Instead, I read your input on another existing issue. In that, you recommended to place pgaudit source in contrib in a PostgreSQL source tree and build the whole thing. I did just that this morning using 11.2 (my first compile of PostgreSQL (which su

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

Mike Yeap wrote: > I have encountered a problem related to LDAP authenticated session with > Postgres foreign data wrapper (postgres_fdw). > > The server crashed with following errors and other active server processes > are terminated as well: > 2019-02-20 14:53:30.496 SGT [PID=1353 application=

Re: Implementing pgaudit extension on Microsoft Windows

On 2/20/19 5:58 AM, Niels Jespersen wrote: > I did not submit an issue. Instead, I read your input on another > existing issue. In that, you recommended to place pgaudit source in > contrib in a PostgreSQL source tree and build the whole thing. I was hoping you would see that -- it looked pretty m

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

Laurenz Albe writes: > Mike Yeap wrote: >> I have encountered a problem related to LDAP authenticated session with >> Postgres foreign data wrapper (postgres_fdw). > Are the "postgres" executable and libpq linked with the same version of > OpenLDAP? And which version is that? (And which versi

Plpythonu extension

hi I have PostgreSQL 11.1 installed on MacOS X Mojave and I used brew to do the install. It appears that the extension plpython was not included in the default installation and I would like to know how to install it. Thanks…

Re: Channel binding not supported using scram-sha-256 passwords

On 2019-02-18 02:06, Michael Paquier wrote: > Now, the error message "channel binding not supported by this build" > would show up by either the backend or the frontend if > X509_get_signature_nid() is not present in the version of OpenSSL your > version of libpq (for the frontend) or your backend

Re: Plpythonu extension

On 2019-02-19 14:40, Vincent Predoehl wrote: > I have PostgreSQL 11.1 installed on MacOS X Mojave and I used brew to do the > install. It appears that the extension plpython was not included in the > default installation and I would like to know how to install it. Apparently, it was removed her

Re: Plpythonu extension

On 2/20/19 6:46 AM, Vincent Predoehl wrote: hi I have PostgreSQL 11.1 installed on MacOS X Mojave and I used brew to do the install. It appears that the extension plpython was not included in the default installation and I would like to know how to install it. All I can find is: https://st

Re: Plpythonu extension

Ok, thanks guys. I already tried: brew install postgres --with-python With no success… > On Feb 20, 2019, at 10:01 AM, Adrian Klaver wrote: > > On 2/20/19 6:46 AM, Vincent Predoehl wrote: >> hi >> I have PostgreSQL 11.1 installed on MacOS X Mojave and I used brew to do the >> install. It ap

Re: procedures and transactions

On 2019-02-19 22:48, Rob Nikander wrote: > I thought if I had some application logic that needed a certain kind of > transaction (maybe a non-default isolation level), I could hide that > fact in a procedure. App code (Java/Python/whatever) could remain > unaware of transactions (except maybe needi

Re: Plpythonu extension

On 2/20/19 8:06 AM, Vincent Predoehl wrote: Ok, thanks guys.  I already tried: brew install postgres --with-python With no success… See Peters post and it's link to: https://github.com/Homebrew/homebrew-core/pull/36074 Seems options are no longer allowed in Homebrew. On Feb 20, 2019, at

Long statement execution. Data fetch by client

Hi, OS: 7.5.1804 PG version: 9.6.12 Client: Java application (jdbc 42.0.0) I have the issue with unexpectedly long statements: LOG: duration: 9284.887 ms parse : SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL READ COMMITTED LOG: duration: 12739.364 ms parse : SHOW TRANSACTION ISO

Re: procedures and transactions

> On Feb 20, 2019, at 10:07 AM, Peter Eisentraut > wrote: > > You can run SET TRANSACTION ISOLATION LEVEL in a procedure. I tried that before but I get this error: create or replace procedure t_test(n integer) as $$ begin set transaction isolation level serializable;

Re: Plpythonu extension

Consider using Postgres.app instead? On Wed, Feb 20, 2019 at 11:13 AM Adrian Klaver wrote: > On 2/20/19 8:06 AM, Vincent Predoehl wrote: > > Ok, thanks guys. I already tried: > > > > brew install postgres --with-python > > > > With no success… > > See Peters post and it's link to: > > https://g

adding more space to the existing 9.6 cluster

Hello, we are almost out of space on our main data directory, and about to introduce new directory to our cluster. We cannot use multiple physical disks as a single volume, so we are thinking about creation new tablespace. Our current data_directory shows as follows: /data/postgresql/9.6/main po

Re: adding more space to the existing 9.6 cluster

On 2/19/19 5:02 PM, Julie Nishimura wrote: Hello, we are almost out of space on our main data directory, and about to introduce new directory to our cluster. We cannot use multiple physical disks as a single volume, so we are thinking about creation new tablespace. Our current data_directory sh

Re: Copy entire schema A to a different schema B

Hi Adrian, I managed to backup my table in parallel using -Fd but I'm back to my original issue where I could not restore the table to a different schema. For example, I would like to backup testuser1.mytable and restore it to testuser2.mytable. pg_dump -U testuser1 -Fd -f c:\temp\testuser1 -j 8

Re: Plpythonu extension

> On Feb 20, 2019, at 10:13 AM, Adrian Klaver wrote: > > On 2/20/19 8:06 AM, Vincent Predoehl wrote: >> Ok, thanks guys. I already tried: >> brew install postgres --with-python >> With no success… > > See Peters post and it's link to: > > https://github.com/Homebrew/homebrew-core/pull/36074

Re: Copy entire schema A to a different schema B

On 2/20/19 3:22 PM, Tiffany Thang wrote: Hi Adrian, I managed to backup my table in parallel using -Fd but I'm back to my original issue where I could not restore the table to a different schema. For example, I would like to backup testuser1.mytable and restore it to testuser2.mytable. pg_

Re: Copy entire schema A to a different schema B

Hi Ron, How would that work if I'm only interested in importing/refreshing a single table in a target schema that contains several other tables? Thanks. Tiff On Wed, Feb 20, 2019 at 5:36 PM Rob Sargent wrote: > > On 2/20/19 3:22 PM, Tiffany Thang wrote: > > Hi Adrian, > I managed to backup my

Re: Copy entire schema A to a different schema B

On 2/20/19 4:21 PM, Tiffany Thang wrote: Hi Ron, How would that work if I'm only interested in importing/refreshing a single table in a target schema that contains several other tables? Thanks. Tiff On Wed, Feb 20, 2019 at 5:36 PM Rob Sargent > wrote: On

Re: Copy entire schema A to a different schema B

On 2/20/19 2:22 PM, Tiffany Thang wrote: Hi Adrian, I managed to backup my table in parallel using -Fd but I'm back to my original issue where I could not restore the table to a different schema. For example, I would like to backup testuser1.mytable and restore it to testuser2.mytable. pg_d

Re: Plpythonu extension

On 2/20/19 2:28 PM, Vincent Predoehl wrote: postgresql --with-python/ I am not really sure how the Brew system works, but it appears it is possible to request a fork or branch from the main project that will have the —with-python option enabled by default.  All I’m trying to do is learn

Re: Copy entire schema A to a different schema B

On 2/20/19 6:16 PM, Adrian Klaver wrote: On 2/20/19 2:22 PM, Tiffany Thang wrote: Hi Adrian, I managed to backup my table in parallel using -Fd but I'm back to my original issue where I could not restore the table to a different schema. For example, I would like to backup testuser1.mytable an

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

> Are the "postgres" executable and libpq linked with the same version of OpenLDAP? How should I check whether they are linked? My Postgres version is 10.6 and I have this output for "yum list | grep ldap | sort": $ yum list | grep ldap | sort apr-util-ldap.x86_641.5.2-6.e

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

Mike Yeap writes: >> Are the "postgres" executable and libpq linked with the same version of >> OpenLDAP? > How should I check whether they are linked? "ldd" should show the dependencies of whatever executable or library you point it at. regards, tom lane

Re: Plpythonu extension

> On Feb 20, 2019, at 6:26 PM, Adrian Klaver > wrote: > > On 2/20/19 2:28 PM, Vincent Predoehl wrote: > >> postgresql --with-python/ >> I am not really sure how the Brew system works, but it appears it is >> possible to request a fork or branch from the main

Connection string for Java to connect to PostgreSQL, using client certificates

I am having hard time to connect to PostgreSQL server using client certificate from within a Java program. Any insight would be helpful. I can connect to the server using psql command line from a client machine(192.168.56.101) (psql -h 192.168.56.102 -U user1 -d testdb) [192.168.56.102 is "post

Re: Copy entire schema A to a different schema B

Hi Tiffany, Isn't it possible for you to do: 1) rename temporarily schema testuser1 to testuser2 2) dump that schema into binary format 3 rename back schema testuser2 to testuser1 4 restore backup to testuser2 schema on other DB? Jura. On Wed, 20 Feb 2019 at 23:23, Tiffany Thang wrote: > > Hi A

Re: Connection string for Java to connect to PostgreSQL, using client certificates

Hello, On Thu, 2019-02-21 at 13:10 +0900, s4...@yahoo.co.jp wrote: > I am having hard time to connect to PostgreSQL server using client > certificate from within a Java program. > Any insight would be helpful. > > I can connect to the server using psql command line from a client > machine(192.168

Re: Channel binding not supported using scram-sha-256 passwords

On Wed, Feb 20, 2019 at 04:53:32PM +0100, Peter Eisentraut wrote: > I think there is a bug in the frontend code. If the server offers > SCRAM-SHA-256-PLUS, the client will choose it if SSL is in use, but it > will later fail with this error message if not > HAVE_PGTLS_GET_PEER_CERTIFICATE_HASH. G

Re: Plpythonu extension

On 2/20/19 6:49 PM, Vincent Predoehl wrote: On Feb 20, 2019, at 6:26 PM, Adrian Klaver > wrote: On 2/20/19 2:28 PM, Vincent Predoehl wrote: postgresql --with-python/ I am not really sure how the Brew system works, but it appears it is possible to request a

Re: Plpythonu extension

> On Feb 20, 2019, at 11:12 PM, Adrian Klaver wrote: > > I am not a Mac user and therefore do not use Homebrew, so take the below with > that in mind. Have you tried?: > > brew install petere/postgresql/postgresql@11 --with-python Great idea!! It works. This didn’t work: brew install pe

Barman disaster recovery solution

Does anyone use this solution? any recommenations? Thanks!

Re: Barman disaster recovery solution

On 21/2/19 9:17 π.μ., Julie Nishimura wrote: Does anyone use this solution? any recommenations? Thanks! Barman will fit most requirements. PgBackRest excels when WAL traffic goes on 10 files/day or more. I have written an article, not yet publised, on a comparison on the 3 most known solut