Re: setting login database - Mailing list pgsql-general

From Samatha Kottha
Subject Re: setting login database
Date
Msg-id 46690A32.1060307@tu-dresden.de
Whole thread Raw
In response to Re: setting login database  (Samatha Kottha <samatha.kottha@tu-dresden.de>)
Responses Re: setting login database
List pgsql-general
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


pgsql-general by date:

Previous
From: "Andy Dale"
Date:
Subject: Re: list all columns in db
Next
From: Alban Hertroys
Date:
Subject: Re: querying the age of a row