From: | Steve Baldwin <steve(dot)baldwin(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
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 06:23:40 |
Message-ID: | CAKE1AiZVugKYCj3OhW354HK4SRpHcd-UJB=9jsUp8hDq2h5w9Q@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks so much Tom. That was indeed the problem. In hindsight the error
information makes perfect sense (at least after reading the docs on
pg_hba.conf).
Regards,
Steve
On Wed, Mar 10, 2021 at 3:04 PM Steve Baldwin <steve(dot)baldwin(at)gmail(dot)com>
wrote:
> Thanks Tom. I'm running postgres from the standard alpine docker container
> and haven't changed that file. I'm not at my laptop ATM but will check it
> out when I get home.
> Cheers, Steve
>
> On Wed, 10 Mar 2021, 14:42 Tom Lane, <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> 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 | Radoslav Nedyalkov | 2021-03-10 08:10:18 | Re: Logical Replication, CPU load and Locking contention |
Previous Message | Alvaro Herrera | 2021-03-10 05:24:57 | Re: unexpected character used as group separator by to_char |