Steve Baldwin <steve.bald...@gmail.com> writes: > I'm guessing I'm doing something wrong here. I've used postgres_fdw before > to connect between servers, but in this instance I'm trying to use it > to connect back to itself.
What are your pg_hba.conf settings for local connections? > 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 or > password_required=false set in the user mapping attributes. This suggests that you're using trust, peer, or something else in which the password isn't actually relevant. regards, tom lane