Re: PgHosts

Actually, we do have that on the client end with pg_service.conf. It
wasn't documented in current releases but will be in 7.4. Documentation
is:

<term><literal>service</literal></term>
<listitem>
<para>
Service name to use for additional parameters. It specifies a service
name in pg_service.conf that holds additional connection parameters.
This allows applications to specify only a service name so connection parameters
can be centrally maintained. See
<filename><replaceable>PREFIX</>/share/pg_service.conf.sample</> for
information on how to set up the file.
</para>

I am attaching the pg_services.conf.sample file that will appear in 7.4.
It only does connection params, not schema/table stuff.

---------------------------------------------------------------------------

Medi Montaseri wrote:
> I posted this question a few days ago when people were talking about PG
> 7.4 (or later)
> features....but I guess it was not posted (processed, etc)...so here it
> is again...
>
> I am wondering if it is possible for Pg to support a feature (as in
> Informix) where
> I can have a host mapping configuration file such that
>
> db = { host, database }
> or
> schema = { host, database, schema}
> or
> table = { host, database, schema, table }
>
> Currently one has to resolve (or switch) at connect time where to
> connect to, but with this
> switching layer, the application can help out a bit on the HA...
>
> Thanks
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073