Jean-Marc Lessard <Jean-Marc.Lessard@xxxxxxxxxxxx> writes: > A nice way to meet security requirements would be to provide single sign on support for the postgres_fdw. > As long as you have defined a user in the source and destination databases, and configure the Kerberos authentication you should be able to use postgres_fdw. It's not really that easy, because postgres_fdw (like the server in general) is running as the database-owner operating system user. How will you associate a Postgres role that's responsible for a particular connection request with some Kerberos credentials, while keeping it away from credentials that belong to other roles? This is certainly something that'd be useful to have, but it's not clear how to do it in a secure fashion. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
