Re: BUG #16550: Problem with pg_service.conf

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Michał Lis <fcs1(at)poczta(dot)onet(dot)pl>
Cc: pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #16550: Problem with pg_service.conf
Date: 2020-07-22 15:29:52
Message-ID: CAMkU=1zRFqQjbHZ0KRVMQTsidG4w41ELTCPV2BvKJC20skHAfg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Jul 22, 2020 at 4:05 AM Michał Lis <fcs1(at)poczta(dot)onet(dot)pl> wrote:

> On the local machine the connection will be established but on remote
> machine the error:
>
> definition of service "test4" not found
>

The service file is read by the client, not the server. So the remote
machine will use the service file local to it. Did you copy your
pg_service.conf to the proper directory on the remote machine?

Cheers,

Jeff

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Juan José Santamaría Flecha 2020-07-22 16:58:00 Re: pg_dump's "--exclude-table" and "--exclude-table-data" options are ignored and/or cause the dump to fail entirely unless both the schema and table name use 1950s-era identifiers.
Previous Message tutiluren 2020-07-22 15:17:27 Re: pg_dump's "--exclude-table" and "--exclude-table-data" options are ignored and/or cause the dump to fail entirely unless both the schema and table name use 1950s-era identifiers.