Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #16550: Problem with pg_service.conf - Mailing list pgsql-bugs

From Jeff Janes
Subject Re: BUG #16550: Problem with pg_service.conf
Date
Msg-id CAMkU=1zRFqQjbHZ0KRVMQTsidG4w41ELTCPV2BvKJC20skHAfg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #16550: Problem with pg_service.conf  (Michał Lis <fcs1@poczta.onet.pl>)
Responses Re: BUG #16550: Problem with pg_service.conf
List pgsql-bugs
Tree view
On Wed, Jul 22, 2020 at 4:05 AM Michał Lis <fcs1@poczta.onet.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

pgsql-bugs by date:

Previous
From: tutiluren@tutanota.com
Date:
Subject: 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.
Next
From: Juan José Santamaría Flecha
Date:
Subject: 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.