pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Godfrin, Philippe E <philippe.godfrin@nov.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: [EXTERNAL] Re: FDW, connections, master v replica
Date: Tue, 18 May 2021 18:27:50 +0200
Message-ID: <e710b9cf36ab776d74ff83a1baf21a656bdd2797.camel@cybertec.at> (raw)
In-Reply-To: <SA0PR15MB393394768B6A3F3B6EF17CD5822C9@SA0PR15MB3933.namprd15.prod.outlook.com>
References: <SA0PR15MB3933C775A0B3D498741C22B2822C9@SA0PR15MB3933.namprd15.prod.outlook.com>
	<49ed5b6a7a44f245676db39d8c6c2b1f55035eac.camel@cybertec.at>
	<SA0PR15MB393394768B6A3F3B6EF17CD5822C9@SA0PR15MB3933.namprd15.prod.outlook.com>

On Tue, 2021-05-18 at 16:13 +0000, Godfrin, Philippe E wrote:
> That seems very promising, though I’m not certain how I’d code that in the create
>  foreign server syntax. My testbed is not quire ready right now, so I’ll ask instead of testing.
> Is this what you mean:
> 
> CREATE SERVER FDW001 FOREIGN DATA WRAPPER POSTGES_FDW
> OPTIONS (HOST ‘FOORW, FOORO’, DBNAME ‘FOODB,FOODB’, PORT ‘5432,6432’,
>    TARGET_SESSION_ATTRS ‘ANY,READ-ONLY’

Pretty much, yes.  Except you can only specify a single setting for
"target_session_attrs".

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com






view thread (9+ messages)  latest in thread

Message-ID: <e710b9cf36ab776d74ff83a1baf21a656bdd2797.camel@cybertec.at>
Permalink:  ../e710b9cf36ab776d74ff83a1baf21a656bdd2797.camel@cybertec.at/
Also on:    postgresql.org/message-id/e710b9cf36ab776d74ff83a1baf21a656bdd2797.camel@cybertec.at

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: laurenz.albe@cybertec.at, philippe.godfrin@nov.com, pgsql-admin@lists.postgresql.org
  Subject: Re: [EXTERNAL] Re: FDW, connections, master v replica
  In-Reply-To: <e710b9cf36ab776d74ff83a1baf21a656bdd2797.camel@cybertec.at>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox