Re: Using a 'loopback' FDW

2021-03-09 Thread Steve Baldwin
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 wrote: > Thanks Tom. I'm running postgres from the standard alpine docker conta

Re: Using a 'loopback' FDW

2021-03-09 Thread Steve Baldwin
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, wrote: > Steve Baldwin writes: > > I'm guessing I'm doing something wrong

Re: Using a 'loopback' FDW

2021-03-09 Thread Tom Lane
Steve Baldwin 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 > DETAI