From: Alex Balashov <abalashov@evaristesys.com>
To: pgsql-admin@postgresql.org
Subject: Re: "Dynamic routing" to different databases
Date: Thu, 1 Oct 2015 13:19:09 -0400
Message-ID: <560D6B0D.1010806@evaristesys.com> (raw)
In-Reply-To: <EC55DC235432104F8255702A8D7344D95D246D28@G4W3206.americas.hpqcorp.net>
References: <560BFE58.9030201@evaristesys.com>
<560C6F2D.1090107@evaristesys.com>
<A76B25F2823E954C9E45E32FA49D70ECCD54D23C@mail.corp.perceptron.com>
<560D4772.4020002@evaristesys.com>
<EC55DC235432104F8255702A8D7344D95D246D28@G4W3206.americas.hpqcorp.net>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Brad,
On 10/01/2015 12:48 PM, Nicholson, Brad (Toronto, ON, CA) wrote:
> You can set the default search path on a per-role/user basis. What
> you could do is map a DB user (or set of users) to a specific schema,
> then set that users search path for the appropriate schema and the
> queries will automatically get routed to the appropriate schema.
> Segmenting your different applications user also allows you to use
> the role system to restrict access to the data between applications.
I'd love to, but unfortunately the service consuming the database is
very, very strictly limited to one connection string, which entails one
set of credentials, one server and one database, and more connections
cannot be created as-needed at runtime without restarting the service,
which in our industry is not acceptable.
So, unfortunately I cannot avail myself of such an elegant solution;
instead, I must access all the schemas via one role.
-- Alex
--
Alex Balashov | Principal | Evariste Systems LLC
303 Perimeter Center North, Suite 300
Atlanta, GA 30346
United States
Tel: +1-800-250-5920 (toll-free) / +1-678-954-0671 (direct)
Web: http://www.evaristesys.com/, http://www.csrpswitch.com/
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
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: abalashov@evaristesys.com
Subject: Re: "Dynamic routing" to different databases
In-Reply-To: <560D6B0D.1010806@evaristesys.com>
* 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