pgAdmin and Postgres_fdw needing superuser access

From: Adam Pearson <Adam(dot)Pearson(at)4finance(dot)com>
To: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: pgAdmin and Postgres_fdw needing superuser access
Date: 2015-12-03 11:16:16
Message-ID: A09FF13F31F4184D8DDD607B8197B98C3C369025@dcm1-exm-002.ofg.local
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello All,
Has anyone encountered a quirk with PGAdmin and Postgres_fdw requiring superuser access?

For example.

Run the below under my useraccount, sudo and it returns a record set.

select id from foreign_address limit 10;

Run the same code in PGAdmin, my normal user account and it reports

ERROR: password is required
DETAIL: Non-superuser cannot connect if the server does not request a password.
HINT: Target server's authentication method must be changed.
********** Error **********

ERROR: password is required
SQL state: 2F003
Detail: Non-superuser cannot connect if the server does not request a password.
Hint: Target server's authentication method must be changed.

However, if I just run a normal select on a non-foreign table it works.

Also, if I change my account to be a superuser it works. Confuses me slightly, since when setting up Postgres_fdw you specify the connection details in the user mapping.

Is this a problem with pgAdmin, or Postgres_fdw? Seems to indicate an issue with pgAdmin?

Thanks & Regards,
Adam Pearson

Browse pgadmin-support by date

  From Date Subject
Next Message Adam Pearson 2015-12-03 15:35:30 Re: pgAdmin and Postgres_fdw needing superuser access
Previous Message Dave Page 2015-12-03 10:14:20 Re: Greenplum warning message