Re: setting login database

Hi Michael,

Thank you for the tip. The integration tool is OGSA-DAI. Of course, we
have to specify the database but the connection string that it uses does
not contain it.

Cheers,
Samatha

Michael Fuhr wrote:
> On Thu, Jun 07, 2007 at 03:38:15PM +0200, Samatha Kottha wrote:
>
>> We are trying to access a postgres database using a data integration
>> tool. This data integration tool have options to specify the hostname,
>> port, userid, and passwd of a database. But there is no way to supply
>> the database name.
>>
>
> What data integration tool is it? Are you sure it doesn't have an
> option to specify the database?
>
>
>> So, I am thinking to set the database name to each user (default
>> login database) so that they do not need to supply that info when
>> they access data using data integration tool.
>>
>
> In libpq applications a role's default database has the same name
> as the role; you can override that with the PGDATABASE environment
> variable.
>
> http://www.postgresql.org/docs/8.2/interactive/libpq-envars.html
>
> See also PGSERVICE, PGSYSCONFDIR, and the connection service file.
>
> http://www.postgresql.org/docs/8.2/interactive/libpq-pgservice.html
>
>

--
Samatha Kottha
Zentrum für Informationsdienste und Hochleistungsrechnen (ZIH)
Technische Universität Dresden Tel: (+49) 351 463-38776
Room 1019 Fax: (+49) 351 463-38245
Noethnitzer Straße 46
01187 Dresden
Germany