Thread: PostgreSQL Database Server 8.0 Service Password Problem - WinXP Home
hi all, i think i'm stuck with alton and ray's problem - i stopped my install just after creating a database service and approving the auto-generated file. i went to copy down the password and stopped because, 1. there was a character (legal subparagraph character - straight line "s-curves" running its length and / or elongated ovals running perpendicular) that my keyboard didn't support and 2. i figured it was in the log file. i stoped because i wanted to delete all prior instances of my cygwin pgsql install to avoid any confusion on the part of the system or myself down the road. after i did the delete, i started getting concerned i might have set myself up for failure... the concern was warranted. ;-) i tried to install postgresql from scratch this morning. the log file from last night was over written with no notice to the user - so there's no record from last night anymore. i breifly checked the file last night for the password and i didn't see it - so maybe it isn't kept there, anyway. i check in services and there is no postgresql database server 8.0 listed. i do a search for "postgresql database server 8.0" in my registry and in my local drive and nothing comes up. i search postgresql - nadda. it has to be there because i can't install pgsql without that password. how is it stored? is it in zipped format and is that why my searches are missing it? is it in the registry? i need... 1. access to the password in order to install pgsql 8 or, 2. access to delete the service so i can start all over again. or, 3. something i don't yet know i need. ;-) any advice w/b greatly appreciated. tia... __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com
just delete the postgresql windows user created by the 8.0 setup and restart the setup. - thomas btw: the service is called pgsql-8.0 ----- Original Message ----- From: <operationsengineer1@yahoo.com> To: "Afton & Ray Still" <rastill@shaw.ca>; <pgsql-novice@postgresql.org> Sent: Monday, October 24, 2005 7:40 PM Subject: [NOVICE] PostgreSQL Database Server 8.0 Service Password Problem - WinXP Home > hi all, > > i think i'm stuck with alton and ray's problem - i > stopped my install just after creating a database > service and approving the auto-generated file. > > i went to copy down the password and stopped because, > 1. there was a character (legal subparagraph character > - straight line "s-curves" running its length and / or > elongated ovals running perpendicular) that my > keyboard didn't support and 2. i figured it was in the > log file. > > i stoped because i wanted to delete all prior > instances of my cygwin pgsql install to avoid any > confusion on the part of the system or myself down the > road. > > after i did the delete, i started getting concerned i > might have set myself up for failure... the concern > was warranted. ;-) > > i tried to install postgresql from scratch this > morning. the log file from last night was over > written with no notice to the user - so there's no > record from last night anymore. > > i breifly checked the file last night for the password > and i didn't see it - so maybe it isn't kept there, > anyway. > > i check in services and there is no postgresql > database server 8.0 listed. > > i do a search for "postgresql database server 8.0" in > my registry and in my local drive and nothing comes > up. i search postgresql - nadda. > > it has to be there because i can't install pgsql > without that password. > > how is it stored? is it in zipped format and is that > why my searches are missing it? is it in the > registry? > > i need... > > 1. access to the password in order to install pgsql 8 > > or, > > 2. access to delete the service so i can start all > over again. > > or, > > 3. something i don't yet know i need. ;-) > > any advice w/b greatly appreciated. > > tia... > > > > > __________________________________ > Yahoo! Mail - PC Magazine Editors' Choice 2005 > http://mail.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly >
thomas, there is no postgresql user that i can access in winxp home. are you using winxp pro? if so, maybe that accounts for the difference in being able to view these options. i search my registry and my local drive for pgsql-8.0 - absolutely nothing. there is no user information displaying in computer administration or in user accounts. OE1 --- me@alternize.com wrote: > just delete the postgresql windows user created by > the 8.0 setup and restart > the setup. > > - thomas > > btw: the service is called pgsql-8.0 > > ----- Original Message ----- > From: <operationsengineer1@yahoo.com> > To: "Afton & Ray Still" <rastill@shaw.ca>; > <pgsql-novice@postgresql.org> > Sent: Monday, October 24, 2005 7:40 PM > Subject: [NOVICE] PostgreSQL Database Server 8.0 > Service Password Problem - > WinXP Home > > > > hi all, > > > > i think i'm stuck with alton and ray's problem - i > > stopped my install just after creating a database > > service and approving the auto-generated file. > > > > i went to copy down the password and stopped > because, > > 1. there was a character (legal subparagraph > character > > - straight line "s-curves" running its length and > / or > > elongated ovals running perpendicular) that my > > keyboard didn't support and 2. i figured it was in > the > > log file. > > > > i stoped because i wanted to delete all prior > > instances of my cygwin pgsql install to avoid any > > confusion on the part of the system or myself down > the > > road. > > > > after i did the delete, i started getting > concerned i > > might have set myself up for failure... the > concern > > was warranted. ;-) > > > > i tried to install postgresql from scratch this > > morning. the log file from last night was over > > written with no notice to the user - so there's no > > record from last night anymore. > > > > i breifly checked the file last night for the > password > > and i didn't see it - so maybe it isn't kept > there, > > anyway. > > > > i check in services and there is no postgresql > > database server 8.0 listed. > > > > i do a search for "postgresql database server 8.0" > in > > my registry and in my local drive and nothing > comes > > up. i search postgresql - nadda. > > > > it has to be there because i can't install pgsql > > without that password. > > > > how is it stored? is it in zipped format and is > that > > why my searches are missing it? is it in the > > registry? > > > > i need... > > > > 1. access to the password in order to install > pgsql 8 > > > > or, > > > > 2. access to delete the service so i can start all > > over again. > > > > or, > > > > 3. something i don't yet know i need. ;-) > > > > any advice w/b greatly appreciated. > > > > tia... __________________________________ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs
type the following at the command prompt (start, run, "cmd"): net user postgres /delete Typing "net user" and you should no longer see the "postgres" account to confirm. -----Original Message----- From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org]On Behalf Of operationsengineer1@yahoo.com Sent: Monday, October 24, 2005 2:10 PM To: me@alternize.com; Afton & Ray Still; pgsql-novice@postgresql.org Subject: Re: [NOVICE] PostgreSQL Database Server 8.0 Service Password Problem - WinXP Home thomas, there is no postgresql user that i can access in winxp home. are you using winxp pro? if so, maybe that accounts for the difference in being able to view these options. i search my registry and my local drive for pgsql-8.0 - absolutely nothing. there is no user information displaying in computer administration or in user accounts. OE1 --- me@alternize.com wrote: > just delete the postgresql windows user created by > the 8.0 setup and restart > the setup. > > - thomas > > btw: the service is called pgsql-8.0 > > ----- Original Message ----- > From: <operationsengineer1@yahoo.com> > To: "Afton & Ray Still" <rastill@shaw.ca>; > <pgsql-novice@postgresql.org> > Sent: Monday, October 24, 2005 7:40 PM > Subject: [NOVICE] PostgreSQL Database Server 8.0 > Service Password Problem - > WinXP Home > > > > hi all, > > > > i think i'm stuck with alton and ray's problem - i > > stopped my install just after creating a database > > service and approving the auto-generated file. > > > > i went to copy down the password and stopped > because, > > 1. there was a character (legal subparagraph > character > > - straight line "s-curves" running its length and > / or > > elongated ovals running perpendicular) that my > > keyboard didn't support and 2. i figured it was in > the > > log file. > > > > i stoped because i wanted to delete all prior > > instances of my cygwin pgsql install to avoid any > > confusion on the part of the system or myself down > the > > road. > > > > after i did the delete, i started getting > concerned i > > might have set myself up for failure... the > concern > > was warranted. ;-) > > > > i tried to install postgresql from scratch this > > morning. the log file from last night was over > > written with no notice to the user - so there's no > > record from last night anymore. > > > > i breifly checked the file last night for the > password > > and i didn't see it - so maybe it isn't kept > there, > > anyway. > > > > i check in services and there is no postgresql > > database server 8.0 listed. > > > > i do a search for "postgresql database server 8.0" > in > > my registry and in my local drive and nothing > comes > > up. i search postgresql - nadda. > > > > it has to be there because i can't install pgsql > > without that password. > > > > how is it stored? is it in zipped format and is > that > > why my searches are missing it? is it in the > > registry? > > > > i need... > > > > 1. access to the password in order to install > pgsql 8 > > > > or, > > > > 2. access to delete the service so i can start all > > over again. > > > > or, > > > > 3. something i don't yet know i need. ;-) > > > > any advice w/b greatly appreciated. > > > > tia... __________________________________ Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
wooooo hoooo! wes, worked like a charm, however, i was never able to view the postgres user in winxp home - so the only way to verify this worked was to run the installer again - and it worked as if there was no prior install so all is well! i remember posting "net user..." command calls to delete the service (but not the user) within the last few days... but i didn't make the connection to users. thanks to all who helped and thanks to wes for the answer that actually worked for winxp home (winxp pro likely has more functionality here). --- Wes Williams <wes_williams@fcbonline.net> wrote: > type the following at the command prompt (start, > run, "cmd"): > > net user postgres /delete > > Typing "net user" and you should no longer see the > "postgres" account to > confirm. > -----Original Message----- > From: pgsql-novice-owner@postgresql.org > [mailto:pgsql-novice-owner@postgresql.org]On Behalf > Of > operationsengineer1@yahoo.com > Sent: Monday, October 24, 2005 2:10 PM > To: me@alternize.com; Afton & Ray Still; > pgsql-novice@postgresql.org > Subject: Re: [NOVICE] PostgreSQL Database Server 8.0 > Service Password > Problem - WinXP Home > > > thomas, > > there is no postgresql user that i can access in > winxp > home. are you using winxp pro? if so, maybe that > accounts for the difference in being able to view > these options. > > i search my registry and my local drive for > pgsql-8.0 > - absolutely nothing. > > there is no user information displaying in computer > administration or in user accounts. > > OE1 > > --- me@alternize.com wrote: > > > just delete the postgresql windows user created by > > the 8.0 setup and restart > > the setup. > > > > - thomas > > > > btw: the service is called pgsql-8.0 > > > > ----- Original Message ----- > > From: <operationsengineer1@yahoo.com> > > To: "Afton & Ray Still" <rastill@shaw.ca>; > > <pgsql-novice@postgresql.org> > > Sent: Monday, October 24, 2005 7:40 PM > > Subject: [NOVICE] PostgreSQL Database Server 8.0 > > Service Password Problem - > > WinXP Home > > > > > > > hi all, > > > > > > i think i'm stuck with alton and ray's problem - > i > > > stopped my install just after creating a > database > > > service and approving the auto-generated file. > > > > > > i went to copy down the password and stopped > > because, > > > 1. there was a character (legal subparagraph > > character > > > - straight line "s-curves" running its length > and > > / or > > > elongated ovals running perpendicular) that my > > > keyboard didn't support and 2. i figured it was > in > > the > > > log file. > > > > > > i stoped because i wanted to delete all prior > > > instances of my cygwin pgsql install to avoid > any > > > confusion on the part of the system or myself > down > > the > > > road. > > > > > > after i did the delete, i started getting > > concerned i > > > might have set myself up for failure... the > > concern > > > was warranted. ;-) > > > > > > i tried to install postgresql from scratch this > > > morning. the log file from last night was over > > > written with no notice to the user - so there's > no > > > record from last night anymore. > > > > > > i breifly checked the file last night for the > > password > > > and i didn't see it - so maybe it isn't kept > > there, > > > anyway. > > > > > > i check in services and there is no postgresql > > > database server 8.0 listed. > > > > > > i do a search for "postgresql database server > 8.0" > > in > > > my registry and in my local drive and nothing > > comes > > > up. i search postgresql - nadda. > > > > > > it has to be there because i can't install pgsql > > > without that password. > > > > > > how is it stored? is it in zipped format and is > > that > > > why my searches are missing it? is it in the > > > registry? > > > > > > i need... > > > > > > 1. access to the password in order to install > > pgsql 8 > > > > > > or, > > > > > > 2. access to delete the service so i can start > all > > > over again. > > > > > > or, > > > > > > 3. something i don't yet know i need. ;-) > > > > > > any advice w/b greatly appreciated. > > > > > > tia... > > > > > __________________________________ > Start your day with Yahoo! - Make it your home page! > http://www.yahoo.com/r/hs > > ---------------------------(end of > broadcast)--------------------------- > TIP 4: Have you searched our list archives? > > http://archives.postgresql.org > > __________________________________ Yahoo! FareChase: Search multiple travel sites in one click. http://farechase.yahoo.com