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@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
#
# Connection configuration file
#
# A service is a set of named connection parameters. You may specify
# multiple services in this file. Each starts with a service name in
# brackets. Subsequent lines have connection configuration parameters of
# the pattern "param=value". A sample configuration for template1 is
# included in this file. If no database name is specified, it is assumed
# to match the service name. Lines beginning with '#' are comments.
#
# Copy this to your sysconf directory (typically /usr/local/pgsql/etc) and
# rename it pg_service.conf.
#
#
#[template1]
#user=postgres
