Comments on: Postgresql_fdw Authentication Changes in PostgreSQL 13 https://www.percona.com/blog/postgresql_fdw-authentication-changes-in-postgresql-13/ Fri, 17 Sep 2021 06:47:22 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: Benny George https://www.percona.com/blog/postgresql_fdw-authentication-changes-in-postgresql-13/#comment-10973319 Fri, 17 Sep 2021 06:47:22 +0000 https://www.percona.com/blog/?p=71546#comment-10973319 CREATE server myserver foreign data wrapper postgres_fdw options (dbname ‘xxx’, host ‘xx.xx.xx.xx’, port ‘5555’, sslcert ‘/tmp/client/client.crt’, sslkey ‘/tmp/client/client.key’, sslrootcert ‘/tmp/client/root.crt’);
CREATE USER MAPPING FOR xxxx SERVER myserver;
create foreign table abcd (name text) server myserver;

$psql ‘host=localhost port=5555 dbname=postgres user=ibrar sslmode=verify-full sslcert=/tmp/postgresql.crt sslkey=/tmp/postgresql.key sslrootcert=/tmp/root.crt’
working fine…

but through postgresql_fdw its not working
select count(*) from abcd;
ERROR: could not connect to server “myserver”
(DETAIL: FATAL: connection requires a valid client certificate)

i am using postgresql-13..
Thanks

]]> By: Ibrar Ahmed https://www.percona.com/blog/postgresql_fdw-authentication-changes-in-postgresql-13/#comment-10972824 Wed, 04 Nov 2020 19:33:32 +0000 https://www.percona.com/blog/?p=71546#comment-10972824 @leiyanliang yes last word of the command is missing.
openssl req -new -key /tmp/postgresql.key -out /tmp/postgresql.csr

]]> By: leiyanliang https://www.percona.com/blog/postgresql_fdw-authentication-changes-in-postgresql-13/#comment-10972819 Tue, 03 Nov 2020 04:23:37 +0000 https://www.percona.com/blog/?p=71546#comment-10972819 openssl req -new -key /tmp/postgresql.key -out 
—->>>This command is not correct！

]]> By: Md Athar Ishteyaque https://www.percona.com/blog/postgresql_fdw-authentication-changes-in-postgresql-13/#comment-10972784 Mon, 19 Oct 2020 17:08:32 +0000 https://www.percona.com/blog/?p=71546#comment-10972784 Ibrar Ahmed.. I saw your videos on index even some more articles on PostgreSQL.. Its amazing and the way you explain is also perfect..
I also wants to make some articles on EDB PostgreSQL. Like BART, EFM, Cascading Replication, pg_backrest, pg_receivewal even some topics because that articles are not available from scratch.. Is it possible to connect with you..

]]>