| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Steve Baldwin <steve(dot)baldwin(at)gmail(dot)com> |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Using a 'loopback' FDW |
| Date: | 2021-03-10 03:42:23 |
| Message-ID: | 2060366.1615347743@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Steve Baldwin <steve(dot)baldwin(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Steve Baldwin | 2021-03-10 04:04:00 | Re: Using a 'loopback' FDW |
| Previous Message | Steve Baldwin | 2021-03-10 03:17:54 | Using a 'loopback' FDW |