installation problem with postgres password
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
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 samewhen 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
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 samewhen 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
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 messagei 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
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 messagei 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
satisfyCould you please try to reset the "postgres" user password in window7 before
reinstalling the PostgreSQL. Below link gives more information of reseting
password in windows7http://pcsupport.about.com/od/windows7/ht/change-password-windows-7.htm
Thanks & Regards,
Raghu Ram
EnterpriseDB Corporation
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 Guesti 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 messagei 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
satisfyCould 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
--
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
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 Guesti 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 messagei 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
satisfyCould you please try to reset the "postgres" user password in window7
before
reinstalling the PostgreSQL. Below link gives more information of
reseting
password in windows7http://pcsupport.about.com/od/windows7/ht/change-password-windows-7.htm
Thanks & Regards,
Raghu Ram
EnterpriseDB Corporation
--
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
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?1342165847On 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 Guesti 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 messagei 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
satisfyCould you please try to reset the "postgres" user password in window7
before
reinstalling the PostgreSQL. Below link gives more information of
reseting
password in windows7http://pcsupport.about.com/od/windows7/ht/change-password-windows-7.htm
Thanks & Regards,
Raghu Ram
EnterpriseDB Corporation
--
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
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
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
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 accountOn 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
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 accountOn 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
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 accountOn 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
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.
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 stuckPerhaps 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.
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 stuckPerhaps 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