Обсуждение: 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 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
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 > >
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/
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/ > > >
Could you see anything wrong in the installation log? (%TEMP%\install-postgresql.log)
--
Regards,
Sachin Srivastava
EnterpriseDB, India
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
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
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
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.
--
Regards,
Sachin Srivastava
EnterpriseDB, India
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
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 > >
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
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
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.
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
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.