reassign 353832 postgresql-common tag 353832 pending thanks Hi Martijn!
Martijn van Oosterhout [2006-02-21 11:10 +0100]: > You cannot use the pg_service.conf functionality present in the Debian > package. Example: > > $ PGDATABASE=test psql > Welcome to psql 7.4.7, the PostgreSQL interactive terminal. > <..snip...> > $ PGSERVICE=test psql > psql (pg_wrapper): No database specified > > If there was a service defined, then it would (possibly) define the > database to connect to. pg_wrapper should continue if the PGSERVICE > variable is defined. The unstable/testing packages do that already. > Next, if you provide a dummy dbname to get past pg_wrapper you get: > > $ PGSERVICE=test psql f > psql: ERROR: Service file '/usr/etc/postgresql/pg_service.conf' not found > > The path is obviously bogus, evidently a broken SYSCONFPATH somewhere. In testing/unstable: $ PGSERVICE=foo psql -l psql: ERROR: service file "/etc/postgresql/pg_service.conf" not found So it got slightly better; however, to achieve consistency with the related user_clusters file, global autovacuum settings, etc, the path should probably default to /etc/postgresql-common/. I fixed that in the current development version of postgresql-common: $ PGSERVICE=foo psql -l psql: ERROR: service file "/etc/postgresql-common/pg_service.conf" not found Thanks, Martin -- Martin Pitt http://www.piware.de Ubuntu Developer http://www.ubuntu.com Debian Developer http://www.debian.org In a world without walls and fences, who needs Windows and Gates?
signature.asc
Description: Digital signature
