Thread: installation problem with postgres password

installation problem with postgres password

From
KOTa
Date:
Hi all,

i am trying to install postgres on a new machine with win 7. i tried
two different versions (9.0.4 and 9.1.4) and the problem is the same

when i run installation it asks me to provide a password for superuser
and service account,

i tried to enter numerous options, including leaving it blank - the
setup hangs for a minute or two and then show a warning message:

"The password specified does not meet the local or domain policy.
Check the minimum length, password complexity and password history
requirements."

i also tried to run it as administrator, no effect.

any ideas?

thank you

Re: installation problem with postgres password

From
Raymond O'Donnell
Date:
On 11/07/2012 15:47, KOTa wrote:
> Hi all,
>
> i am trying to install postgres on a new machine with win 7. i tried
> two different versions (9.0.4 and 9.1.4) and the problem is the same
>
> when i run installation it asks me to provide a password for superuser
> and service account,
>
> i tried to enter numerous options, including leaving it blank - the
> setup hangs for a minute or two and then show a warning message:
>
> "The password specified does not meet the local or domain policy.
> Check the minimum length, password complexity and password history
> requirements."

The clue is in the message - there's a security policy in place
somewhere governing the minimum requirements for the password. Are you
in an Active Directory domain?

Ray.


--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie



Re: installation problem with postgres password

From
KOTa
Date:
that is what i though, but i tried many different combinations for
password, and at least 1 of them should satisfy policy requirements.
also my windows user password, which is accepted by OS and thus
satisfies the requirements resulted in same message

i did try to see what policy is active, but i am using win 7 Home
Premium and i could find a way for this version to see/change
policies.
the only thing i found is by running "net accounts" from command
prompt. which shows the following:

http://gyazo.com/be1089b5f0a1ebe6b8037ad9322eac31.png?1342061599

and those are very simple password policy which all combinations i used satisfy

On Wed, Jul 11, 2012 at 10:48 PM, Raymond O'Donnell <rod@iol.ie> wrote:
> On 11/07/2012 15:47, KOTa wrote:
>> Hi all,
>>
>> i am trying to install postgres on a new machine with win 7. i tried
>> two different versions (9.0.4 and 9.1.4) and the problem is the same
>>
>> when i run installation it asks me to provide a password for superuser
>> and service account,
>>
>> i tried to enter numerous options, including leaving it blank - the
>> setup hangs for a minute or two and then show a warning message:
>>
>> "The password specified does not meet the local or domain policy.
>> Check the minimum length, password complexity and password history
>> requirements."
>
> The clue is in the message - there's a security policy in place
> somewhere governing the minimum requirements for the password. Are you
> in an Active Directory domain?
>
> Ray.
>
>
> --
> Raymond O'Donnell :: Galway :: Ireland
> rod@iol.ie
>
>

Re: installation problem with postgres password

From
raghu ram
Date:


On Thu, Jul 12, 2012 at 8:35 AM, KOTa <kota.alba@gmail.com> wrote:
that is what i though, but i tried many different combinations for
password, and at least 1 of them should satisfy policy requirements.
also my windows user password, which is accepted by OS and thus
satisfies the requirements resulted in same message

i did try to see what policy is active, but i am using win 7 Home
Premium and i could find a way for this version to see/change
policies.
the only thing i found is by running "net accounts" from command
prompt. which shows the following:

http://gyazo.com/be1089b5f0a1ebe6b8037ad9322eac31.png?1342061599

and those are very simple password policy which all combinations i used satisfy

Could you please try to reset the "postgres" user password in window7 before reinstalling the PostgreSQL. Below link gives more information of reseting password in windows7


Thanks & Regards,

Raghu Ram

EnterpriseDB Corporation

Blog:http://raghurc.blogspot.in/



Re: installation problem with postgres password

From
KOTa
Date:
postgres user does not exist yet, its a fresh new installation of
windows 7 Home. New HP laptop.
there is only my account (admin) and Guest

i saw on internet someone had similar problem and this was resolved by
removing HP protection tools tha was messing with policies, but i
already removed it before.

On Thu, Jul 12, 2012 at 8:02 AM, raghu ram <raghuchennuru@gmail.com> wrote:
>
>
> On Thu, Jul 12, 2012 at 8:35 AM, KOTa <kota.alba@gmail.com> wrote:
>>
>> that is what i though, but i tried many different combinations for
>> password, and at least 1 of them should satisfy policy requirements.
>> also my windows user password, which is accepted by OS and thus
>> satisfies the requirements resulted in same message
>>
>> i did try to see what policy is active, but i am using win 7 Home
>> Premium and i could find a way for this version to see/change
>> policies.
>> the only thing i found is by running "net accounts" from command
>> prompt. which shows the following:
>>
>> http://gyazo.com/be1089b5f0a1ebe6b8037ad9322eac31.png?1342061599
>>
>> and those are very simple password policy which all combinations i used
>> satisfy
>
>
> Could you please try to reset the "postgres" user password in window7 before
> reinstalling the PostgreSQL. Below link gives more information of reseting
> password in windows7
>
> http://pcsupport.about.com/od/windows7/ht/change-password-windows-7.htm
>
> Thanks & Regards,
>
> Raghu Ram
>
> EnterpriseDB Corporation
>
> Blog:http://raghurc.blogspot.in/
>
>
>

Re: installation problem with postgres password

From
Sachin Srivastava
Date:
Could you see anything wrong in the installation log? (%TEMP%\install-postgresql.log)

On Thu, Jul 12, 2012 at 11:04 AM, KOTa <kota.alba@gmail.com> wrote:
postgres user does not exist yet, its a fresh new installation of
windows 7 Home. New HP laptop.
there is only my account (admin) and Guest

i saw on internet someone had similar problem and this was resolved by
removing HP protection tools tha was messing with policies, but i
already removed it before.

On Thu, Jul 12, 2012 at 8:02 AM, raghu ram <raghuchennuru@gmail.com> wrote:
>
>
> On Thu, Jul 12, 2012 at 8:35 AM, KOTa <kota.alba@gmail.com> wrote:
>>
>> that is what i though, but i tried many different combinations for
>> password, and at least 1 of them should satisfy policy requirements.
>> also my windows user password, which is accepted by OS and thus
>> satisfies the requirements resulted in same message
>>
>> i did try to see what policy is active, but i am using win 7 Home
>> Premium and i could find a way for this version to see/change
>> policies.
>> the only thing i found is by running "net accounts" from command
>> prompt. which shows the following:
>>
>> http://gyazo.com/be1089b5f0a1ebe6b8037ad9322eac31.png?1342061599
>>
>> and those are very simple password policy which all combinations i used
>> satisfy
>
>
> Could you please try to reset the "postgres" user password in window7 before
> reinstalling the PostgreSQL. Below link gives more information of reseting
> password in windows7
>
> http://pcsupport.about.com/od/windows7/ht/change-password-windows-7.htm
>
> Thanks & Regards,
>
> Raghu Ram
>
> EnterpriseDB Corporation
>
> Blog:http://raghurc.blogspot.in/
>
>
>

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



--
Regards,
Sachin Srivastava
EnterpriseDB, India

Re: installation problem with postgres password

From
KOTa
Date:
there is no log, only thing which is left after failed installation
attempt is %TEMP%\postgresql_installer\
with following files:
http://gyazo.com/01c378f7c55c876f937ca3798b255d37.png?1342165847

On Fri, Jul 13, 2012 at 9:44 AM, Sachin Srivastava
<sachin.srivastava@enterprisedb.com> wrote:
> Could you see anything wrong in the installation log?
> (%TEMP%\install-postgresql.log)
>
> On Thu, Jul 12, 2012 at 11:04 AM, KOTa <kota.alba@gmail.com> wrote:
>>
>> postgres user does not exist yet, its a fresh new installation of
>> windows 7 Home. New HP laptop.
>> there is only my account (admin) and Guest
>>
>> i saw on internet someone had similar problem and this was resolved by
>> removing HP protection tools tha was messing with policies, but i
>> already removed it before.
>>
>> On Thu, Jul 12, 2012 at 8:02 AM, raghu ram <raghuchennuru@gmail.com>
>> wrote:
>> >
>> >
>> > On Thu, Jul 12, 2012 at 8:35 AM, KOTa <kota.alba@gmail.com> wrote:
>> >>
>> >> that is what i though, but i tried many different combinations for
>> >> password, and at least 1 of them should satisfy policy requirements.
>> >> also my windows user password, which is accepted by OS and thus
>> >> satisfies the requirements resulted in same message
>> >>
>> >> i did try to see what policy is active, but i am using win 7 Home
>> >> Premium and i could find a way for this version to see/change
>> >> policies.
>> >> the only thing i found is by running "net accounts" from command
>> >> prompt. which shows the following:
>> >>
>> >> http://gyazo.com/be1089b5f0a1ebe6b8037ad9322eac31.png?1342061599
>> >>
>> >> and those are very simple password policy which all combinations i used
>> >> satisfy
>> >
>> >
>> > Could you please try to reset the "postgres" user password in window7
>> > before
>> > reinstalling the PostgreSQL. Below link gives more information of
>> > reseting
>> > password in windows7
>> >
>> > http://pcsupport.about.com/od/windows7/ht/change-password-windows-7.htm
>> >
>> > Thanks & Regards,
>> >
>> > Raghu Ram
>> >
>> > EnterpriseDB Corporation
>> >
>> > Blog:http://raghurc.blogspot.in/
>> >
>> >
>> >
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-general
>
>
>
>
> --
> Regards,
> Sachin Srivastava
> EnterpriseDB, India

Re: installation problem with postgres password

From
KOTa
Date:
so nobody can help? :(

On Fri, Jul 13, 2012 at 10:56 AM, KOTa <kota.alba@gmail.com> wrote:
> there is no log, only thing which is left after failed installation
> attempt is %TEMP%\postgresql_installer\
> with following files:
> http://gyazo.com/01c378f7c55c876f937ca3798b255d37.png?1342165847
>
> On Fri, Jul 13, 2012 at 9:44 AM, Sachin Srivastava
> <sachin.srivastava@enterprisedb.com> wrote:
>> Could you see anything wrong in the installation log?
>> (%TEMP%\install-postgresql.log)
>>
>> On Thu, Jul 12, 2012 at 11:04 AM, KOTa <kota.alba@gmail.com> wrote:
>>>
>>> postgres user does not exist yet, its a fresh new installation of
>>> windows 7 Home. New HP laptop.
>>> there is only my account (admin) and Guest
>>>
>>> i saw on internet someone had similar problem and this was resolved by
>>> removing HP protection tools tha was messing with policies, but i
>>> already removed it before.
>>>
>>> On Thu, Jul 12, 2012 at 8:02 AM, raghu ram <raghuchennuru@gmail.com>
>>> wrote:
>>> >
>>> >
>>> > On Thu, Jul 12, 2012 at 8:35 AM, KOTa <kota.alba@gmail.com> wrote:
>>> >>
>>> >> that is what i though, but i tried many different combinations for
>>> >> password, and at least 1 of them should satisfy policy requirements.
>>> >> also my windows user password, which is accepted by OS and thus
>>> >> satisfies the requirements resulted in same message
>>> >>
>>> >> i did try to see what policy is active, but i am using win 7 Home
>>> >> Premium and i could find a way for this version to see/change
>>> >> policies.
>>> >> the only thing i found is by running "net accounts" from command
>>> >> prompt. which shows the following:
>>> >>
>>> >> http://gyazo.com/be1089b5f0a1ebe6b8037ad9322eac31.png?1342061599
>>> >>
>>> >> and those are very simple password policy which all combinations i used
>>> >> satisfy
>>> >
>>> >
>>> > Could you please try to reset the "postgres" user password in window7
>>> > before
>>> > reinstalling the PostgreSQL. Below link gives more information of
>>> > reseting
>>> > password in windows7
>>> >
>>> > http://pcsupport.about.com/od/windows7/ht/change-password-windows-7.htm
>>> >
>>> > Thanks & Regards,
>>> >
>>> > Raghu Ram
>>> >
>>> > EnterpriseDB Corporation
>>> >
>>> > Blog:http://raghurc.blogspot.in/
>>> >
>>> >
>>> >
>>>
>>> --
>>> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
>>> To make changes to your subscription:
>>> http://www.postgresql.org/mailpref/pgsql-general
>>
>>
>>
>>
>> --
>> Regards,
>> Sachin Srivastava
>> EnterpriseDB, India

Re: installation problem with postgres password

From
Adrian Klaver
Date:
On 07/17/2012 03:29 AM, KOTa wrote:
> so nobody can help? :(
>

If I followed correctly the problem is:
1) You are on Windows 7 Home
2) You have an admin account and Guest account.
3) You are using the One-Click Installer
4) Using either account the install fails when it asks for the superuser
password with the following message.
"The password specified does not meet the local or domain policy.
Check the minimum length, password complexity and password history
requirements."

My question
1) Have you installed any other program successfully on this machine?


--
Adrian Klaver
adrian.klaver@gmail.com



Re: installation problem with postgres password

From
Sachin Srivastava
Date:
You can use an already existing account by specifying --serviceaccount CLI option.  So you can:

i) Create a new account and then use it.
ii) Use an already existing account.

See if this helps.

On Wed, Jul 18, 2012 at 11:07 AM, KOTa <kota.alba@gmail.com> wrote:
yes, many other programs.
although none of them needed to create an account

On Wed, Jul 18, 2012 at 6:19 AM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
> On 07/17/2012 03:29 AM, KOTa wrote:
>>
>> so nobody can help? :(
>>
>
> If I followed correctly the problem is:
> 1) You are on Windows 7 Home
> 2) You have an admin account and Guest account.
> 3) You are using the One-Click Installer
> 4) Using either account the install fails when it asks for the superuser
> password with the following message.
>
> "The password specified does not meet the local or domain policy.
> Check the minimum length, password complexity and password history
> requirements."
>
> My question
> 1) Have you installed any other program successfully on this machine?
>
>
> --
> Adrian Klaver
> adrian.klaver@gmail.com
>
>



--
Regards,
Sachin Srivastava
EnterpriseDB, India

Re: installation problem with postgres password

From
KOTa
Date:
yes, many other programs.
although none of them needed to create an account

On Wed, Jul 18, 2012 at 6:19 AM, Adrian Klaver <adrian.klaver@gmail.com> wrote:
> On 07/17/2012 03:29 AM, KOTa wrote:
>>
>> so nobody can help? :(
>>
>
> If I followed correctly the problem is:
> 1) You are on Windows 7 Home
> 2) You have an admin account and Guest account.
> 3) You are using the One-Click Installer
> 4) Using either account the install fails when it asks for the superuser
> password with the following message.
>
> "The password specified does not meet the local or domain policy.
> Check the minimum length, password complexity and password history
> requirements."
>
> My question
> 1) Have you installed any other program successfully on this machine?
>
>
> --
> Adrian Klaver
> adrian.klaver@gmail.com
>
>

Re: installation problem with postgres password

From
KOTa
Date:
update. managed to run it via command prompt "postgres_install.exe
--serviceaccount postgres"
it did start. it still asks for a password, but because i could not
create any password for this user and installation does not accept
empty password, i am still stuck

On Wed, Jul 18, 2012 at 11:27 AM, KOTa <kota.alba@gmail.com> wrote:
> thank, this is a good idea.
>
> 1. i created account "postgres"
> 2. i tried to create a password for it, but got the same error message
> 3. i tried to run postgres installation with  --serviceaccount option,
> but can't figure out a way to do it in win 7. (i tried to do it as i
> did in win XP - from command prompt, or creating shortcut with option
> included, but win 7 did't allow it)
>
> On Wed, Jul 18, 2012 at 8:57 AM, Sachin Srivastava
> <sachin.srivastava@enterprisedb.com> wrote:
>> You can use an already existing account by specifying --serviceaccount CLI
>> option.  So you can:
>>
>> i) Create a new account and then use it.
>> ii) Use an already existing account.
>>
>> See if this helps.
>>
>> On Wed, Jul 18, 2012 at 11:07 AM, KOTa <kota.alba@gmail.com> wrote:
>>>
>>> yes, many other programs.
>>> although none of them needed to create an account
>>>
>>> On Wed, Jul 18, 2012 at 6:19 AM, Adrian Klaver <adrian.klaver@gmail.com>
>>> wrote:
>>> > On 07/17/2012 03:29 AM, KOTa wrote:
>>> >>
>>> >> so nobody can help? :(
>>> >>
>>> >
>>> > If I followed correctly the problem is:
>>> > 1) You are on Windows 7 Home
>>> > 2) You have an admin account and Guest account.
>>> > 3) You are using the One-Click Installer
>>> > 4) Using either account the install fails when it asks for the superuser
>>> > password with the following message.
>>> >
>>> > "The password specified does not meet the local or domain policy.
>>> > Check the minimum length, password complexity and password history
>>> > requirements."
>>> >
>>> > My question
>>> > 1) Have you installed any other program successfully on this machine?
>>> >
>>> >
>>> > --
>>> > Adrian Klaver
>>> > adrian.klaver@gmail.com
>>> >
>>> >
>>
>>
>>
>>
>> --
>> Regards,
>> Sachin Srivastava
>> EnterpriseDB, India

Re: installation problem with postgres password

From
KOTa
Date:
thank, this is a good idea.

1. i created account "postgres"
2. i tried to create a password for it, but got the same error message
3. i tried to run postgres installation with  --serviceaccount option,
but can't figure out a way to do it in win 7. (i tried to do it as i
did in win XP - from command prompt, or creating shortcut with option
included, but win 7 did't allow it)

On Wed, Jul 18, 2012 at 8:57 AM, Sachin Srivastava
<sachin.srivastava@enterprisedb.com> wrote:
> You can use an already existing account by specifying --serviceaccount CLI
> option.  So you can:
>
> i) Create a new account and then use it.
> ii) Use an already existing account.
>
> See if this helps.
>
> On Wed, Jul 18, 2012 at 11:07 AM, KOTa <kota.alba@gmail.com> wrote:
>>
>> yes, many other programs.
>> although none of them needed to create an account
>>
>> On Wed, Jul 18, 2012 at 6:19 AM, Adrian Klaver <adrian.klaver@gmail.com>
>> wrote:
>> > On 07/17/2012 03:29 AM, KOTa wrote:
>> >>
>> >> so nobody can help? :(
>> >>
>> >
>> > If I followed correctly the problem is:
>> > 1) You are on Windows 7 Home
>> > 2) You have an admin account and Guest account.
>> > 3) You are using the One-Click Installer
>> > 4) Using either account the install fails when it asks for the superuser
>> > password with the following message.
>> >
>> > "The password specified does not meet the local or domain policy.
>> > Check the minimum length, password complexity and password history
>> > requirements."
>> >
>> > My question
>> > 1) Have you installed any other program successfully on this machine?
>> >
>> >
>> > --
>> > Adrian Klaver
>> > adrian.klaver@gmail.com
>> >
>> >
>
>
>
>
> --
> Regards,
> Sachin Srivastava
> EnterpriseDB, India

Re: installation problem with postgres password

From
Alban Hertroys
Date:
On 18 July 2012 10:33, KOTa <kota.alba@gmail.com> wrote:
> update. managed to run it via command prompt "postgres_install.exe
> --serviceaccount postgres"
> it did start. it still asks for a password, but because i could not
> create any password for this user and installation does not accept
> empty password, i am still stuck

Perhaps you can't create more than one account because it's Windows 7
Home Edition? It sounds like the type of limitation to expect on that
edition.

In that case, use your own account to run Postgres as, or install a
less limited OS.

--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

Re: installation problem with postgres password

From
Craig Ringer
Date:
On 07/18/2012 10:13 PM, Alban Hertroys wrote:
> On 18 July 2012 10:33, KOTa <kota.alba@gmail.com> wrote:
>> update. managed to run it via command prompt "postgres_install.exe
>> --serviceaccount postgres"
>> it did start. it still asks for a password, but because i could not
>> create any password for this user and installation does not accept
>> empty password, i am still stuck
> Perhaps you can't create more than one account because it's Windows 7
> Home Edition? It sounds like the type of limitation to expect on that
> edition.
Maybe if it were Starter. "Home" typically refers to Home Premium which
is certainly not so restricted. Even if it were Home Basic, that can't
create homegroups, lacks Aero, and lacks media center, but it's
perfectly happy with multiple users.

There's something funky about this person's Windows install, it's just a
matter of working out what.

--
Craig Ringer

Re: installation problem with postgres password

From
KOTa
Date:
thanks!

that solved a problem. i used my own account.

but it does not seem to be a limitation in number of accounts. because
i can create new account, but without password. the problem comes out
when i try to add password to it.

On Wed, Jul 18, 2012 at 5:13 PM, Alban Hertroys <haramrae@gmail.com> wrote:
> On 18 July 2012 10:33, KOTa <kota.alba@gmail.com> wrote:
>> update. managed to run it via command prompt "postgres_install.exe
>> --serviceaccount postgres"
>> it did start. it still asks for a password, but because i could not
>> create any password for this user and installation does not accept
>> empty password, i am still stuck
>
> Perhaps you can't create more than one account because it's Windows 7
> Home Edition? It sounds like the type of limitation to expect on that
> edition.
>
> In that case, use your own account to run Postgres as, or install a
> less limited OS.
>
> --
> If you can't see the forest for the trees,
> Cut the trees and you'll see there is no forest.