installation problem with postgres password

Started by KOTaover 13 years ago16 messagesgeneral
Jump to latest
#1KOTa
kota.alba@gmail.com

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

In reply to: KOTa (#1)
Re: installation problem with postgres password

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

#3KOTa
kota.alba@gmail.com
In reply to: Raymond O'Donnell (#2)
Re: installation problem with postgres password

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

Show quoted text

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

#4raghu ram
raghuchennuru@gmail.com
In reply to: KOTa (#3)
Re: installation problem with postgres password

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

<goog_788790081>
http://pcsupport.about.com/od/windows7/ht/change-password-windows-7.htm

Thanks & Regards,

Raghu Ram

EnterpriseDB Corporation

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

#5KOTa
kota.alba@gmail.com
In reply to: raghu ram (#4)
Re: installation problem with postgres password

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.

Show quoted text

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/

#6Sachin Srivastava
sachin.srivastava@enterprisedb.com
In reply to: KOTa (#5)
Re: installation problem with postgres password

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

#7KOTa
kota.alba@gmail.com
In reply to: Sachin Srivastava (#6)
Re: installation problem with postgres password

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:

Show quoted text

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

#8KOTa
kota.alba@gmail.com
In reply to: KOTa (#7)
Re: installation problem with postgres password

so nobody can help? :(

Show quoted text

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

#9Adrian Klaver
adrian.klaver@aklaver.com
In reply to: KOTa (#8)
Re: installation problem with postgres password

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

#10KOTa
kota.alba@gmail.com
In reply to: Adrian Klaver (#9)
Re: installation problem with postgres password

yes, many other programs.
although none of them needed to create an account

Show quoted text

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

#11Sachin Srivastava
sachin.srivastava@enterprisedb.com
In reply to: KOTa (#10)
Re: installation problem with postgres password

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

#12KOTa
kota.alba@gmail.com
In reply to: Sachin Srivastava (#11)
Re: installation problem with postgres password

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:

Show quoted text

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

#13KOTa
kota.alba@gmail.com
In reply to: KOTa (#12)
Re: installation problem with postgres password

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

Show quoted text

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

#14Alban Hertroys
haramrae@gmail.com
In reply to: KOTa (#13)
Re: installation problem with postgres password

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.

#15KOTa
kota.alba@gmail.com
In reply to: Alban Hertroys (#14)
Re: installation problem with postgres password

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.

Show quoted text

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.

#16Craig Ringer
craig@2ndquadrant.com
In reply to: Alban Hertroys (#14)
Re: installation problem with postgres password

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