OK, I am not yet awake :-) Of course, the connection string has database
name but some thing is not working on OGSA-DAI side. It is giving
authorisation failure error!
Samatha
Samatha Kottha wrote:
> 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