current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I'm looking for a way to create a user with password for PostgreSQL >= 8.4 using SQL statement, but the password must match the windows password policy.

At MSSQL I can create a LOGIN and set CHECK_POLICY=ON

CREATE LOGIN [xy] WITH PASSWORD='pass', DEFAULT_DATABASE=[mydb], CHECK_POLICY=ON

and later create the user for this login.

Is there something similar for PostgreSQL? I have to support all versions beginning at 8.4.

Thank you

share|improve this question
1  
You will want SSPI authentication mode, where PostgreSQL defers user authentication to Windows. –  Craig Ringer Jan 31 at 9:26
    
@CraigRinger Does that mean, that I have to create a windows user account and use it to authenticate to postgres? –  Vlad L Jan 31 at 9:37
    
If you wish to enforce Windows's password policy, yes. PostgreSQL has its own password policy options you can use instead, but it'll be separate. –  Craig Ringer Jan 31 at 13:32

1 Answer 1

up vote 0 down vote

There is a module for that: http://www.postgresql.org/docs/9.3/static/passwordcheck.html Think this works since Version 9.0.

share|improve this answer
    
yes, nothing for 8.4 –  Vlad L Jan 31 at 10:48
    
Version 8.4 is end-of-life from July this year. Not sure how much effort you'll want to go to. postgresql.org/support/versioning –  Richard Huxton Jan 31 at 11:27
    
@RichardHuxton sure, but the head developer decided to support 8.4 as well ;) –  Vlad L Jan 31 at 18:25

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.