Re: createdb.exe prompting for password on Vista - Mailing list pgsql-general

From Greg Quinn
Subject Re: createdb.exe prompting for password on Vista
Date
Msg-id 001801c7a15c$43c0cb00$cb426100$@co.za
Whole thread Raw
In response to Re: createdb.exe prompting for password on Vista  (Andrew Sullivan <ajs@crankycanuck.ca>)
Responses Re: createdb.exe prompting for password on Vista
List pgsql-general
Setting the authentication option to "trust" seems to work but now I'm
worried my application won't need a password for users accessing the
database. It is a client-server application so I don't know which IP
addresses can/can't use it and I'm not relying my application to be on a
windows domain/active directory.

I'm thinking the best way to get around it is change the auth option to
trust in my installer, create the database, and then automatically set the
auth option back to "md5". Not the most elegant solution but it will work
for now.

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Andrew Sullivan
Sent: 28 May 2007 07:46 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] createdb.exe prompting for password on Vista

On Mon, May 28, 2007 at 07:18:47PM +0200, Greg Quinn wrote:
> And how would I enable this?
> I've tried all the created password options with no luck.

You'll need to look at
http://www.postgresql.org/docs/8.2/static/client-authentication.html.
Sorry, I know nothing about Windows, so if there's some
Windows-specific tricks, you may need to know that.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
Everything that happens in the world happens at some place.
        --Jane Jacobs

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq



pgsql-general by date:

Previous
From: danmcb
Date:
Subject: optimisation for a table with frequently used query
Next
From: PFC
Date:
Subject: Re: optimisation for a table with frequently used query