|
Home > Archive > PostgreSQL Newbies > November 2005 > WinXP Install - Account Password Information
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
WinXP Install - Account Password Information
|
|
| operationsengineer1@yahoo.com 2005-10-27, 8:04 am |
| hi all,
during the 8.0.4 installation of pgsql, you are asked
for two passwords.
1. the account password
2. the db user password (as you know, postgres is the
db user name)
i understand the latter password and how to update it.
i don't understand the former password and i don't
understand how to change. i googled it and i did a
quick search on postgresql.org, but came up empty.
can someone provide a quick overview of the account
password mechanics and explain how to update that
password to something new.
tia...
to help future googlers find this theead - pgsql
postgresql change account password.
____________________
______________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
| |
| me@alternize.com 2005-10-27, 8:04 am |
| the first one is the password for the pgsql service account - you can change
it through the windows user manager, but don't forget to also change the
service identity in the service manager console once you do so.
cheers,
thomas
----- Original Message -----
From: < operationsengineer1@
yahoo.com>
To: <pgsql-novice@postgresql.org>
Sent: Saturday, October 22, 2005 9:34 PM
Subject: [NOVICE] WinXP Install - Account Password Information
> hi all,
>
> during the 8.0.4 installation of pgsql, you are asked
> for two passwords.
>
> 1. the account password
> 2. the db user password (as you know, postgres is the
> db user name)
>
> i understand the latter password and how to update it.
>
> i don't understand the former password and i don't
> understand how to change. i googled it and i did a
> quick search on postgresql.org, but came up empty.
>
> can someone provide a quick overview of the account
> password mechanics and explain how to update that
> password to something new.
>
> tia...
>
> to help future googlers find this theead - pgsql
> postgresql change account password.
>
>
>
>
> ____________________
______________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
> choose an index scan if your joining column's datatypes do not
> match
>
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
| |
| operationsengineer1@yahoo.com 2005-10-27, 8:04 am |
| -- me@alternize.com wrote:
> the first one is the password for the pgsql service
> account - you can change
> it through the windows user manager, but don't
> forget to also change the
> service identity in the service manager console once
> you do so.
>
> cheers,
> thomas
thanks for the information. i'm using winxp home and
i have no clue how to get to the windows service
manager. i went to start -> control panel -> User
Accounts, but only saw the normal account like owner
and guest. i didn't see anything related to pgsql.
i went to administrative tools, but nothing indicated
it related to users.
is windows service manager on winxp pro only? can
this be managed on winxp home?
tia...
tia...
since i can't find windows service manager, i can't
change the password.
____________________
______________
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs
---------------------------(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
| |
| me@alternize.com 2005-10-27, 8:04 am |
| its in the administrative tools -> computer management -> users
cheers,
thomas
----- Original Message -----
From: < operationsengineer1@
yahoo.com>
To: <me@alternize.com>; <pgsql-novice@postgresql.org>
Sent: Sunday, October 23, 2005 12:08 AM
Subject: Re: [NOVICE] WinXP Install - Account Password Information
> -- me@alternize.com wrote:
>
>
> thanks for the information. i'm using winxp home and
> i have no clue how to get to the windows service
> manager. i went to start -> control panel -> User
> Accounts, but only saw the normal account like owner
> and guest. i didn't see anything related to pgsql.
>
> i went to administrative tools, but nothing indicated
> it related to users.
>
> is windows service manager on winxp pro only? can
> this be managed on winxp home?
>
> tia...
>
> tia...
>
> since i can't find windows service manager, i can't
> change the password.
>
>
>
> ____________________
______________
> Start your day with Yahoo! - Make it your home page!
> http://www.yahoo.com/r/hs
>
> ---------------------------(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
>
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
| |
| operationsengineer1@yahoo.com 2005-10-27, 8:04 am |
| > its in the administrative tools -> computer
> management -> users
>
> cheers,
> thomas
thomas, believe it or not, i don't have a users option
in computer management.
i do have system tools, storage and services and
applications.
again, winxp home.
____________________
______________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
| |
| Aly Dharshi 2005-10-27, 8:04 am |
| Try Start->Run->MMC, this should help, you would have to load up the
users snap-in that will give you a view into a load of things including
the "hidden PG user"
operationsengineer1@
yahoo.com wrote:
> -- me@alternize.com wrote:
>
>
>
>
> thanks for the information. i'm using winxp home and
> i have no clue how to get to the windows service
> manager. i went to start -> control panel -> User
> Accounts, but only saw the normal account like owner
> and guest. i didn't see anything related to pgsql.
>
> i went to administrative tools, but nothing indicated
> it related to users.
>
> is windows service manager on winxp pro only? can
> this be managed on winxp home?
>
> tia...
>
> tia...
>
> since i can't find windows service manager, i can't
> change the password.
>
>
>
> ____________________
______________
> Start your day with Yahoo! - Make it your home page!
> http://www.yahoo.com/r/hs
>
> ---------------------------(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
--
Aly Dharshi
aly.dharshi@telus.net
"A good speech is like a good dress
that's short enough to be interesting
and long enough to cover the subject"
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
| |
| operationsengineer1@yahoo.com 2005-10-27, 8:04 am |
| --- Aly Dharshi <aly.dharshi@telus.net> wrote:
> Try Start->Run->MMC, this should help,
this got me into console 1 with an empty console root.
> you would have to load up the users snap-in that
will
> give you a view into a load of things including the
>"hidden PG user"
unfortunately, i don't have the experience to know
what this means.
thanks for helping.
-------------------
>
> operationsengineer1@
yahoo.com wrote:
> service
> once
> and
> owner
> pgsql.
> indicated
> can't
> page!
> broadcast)---------------------------
> send an appropriate
> majordomo@postgresql
.org so that your
> cleanly
>
> --
> Aly Dharshi
> aly.dharshi@telus.net
>
> "A good speech is like a good dress
> that's short enough to be interesting
> and long enough to cover the subject"
>
>
____________________
______________
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
| |
| Aly Dharshi 2005-10-27, 8:04 am |
| Ah soory about that, when you are in MMC, execute the following:
File->Add/Remove Snap-in->Standalone->Add-><pick your snap-in e.g Local
Users and Groups>->Add->Finish->close->Ok
You should now be able to manage the users and groups better, you should
see the postgres user. The postgres user is not visible directly for
myself even if I am Administrator on my XP Pro box, I don't see that
being terribly different on your Home edition box.
operationsengineer1@
yahoo.com wrote:
> --- Aly Dharshi <aly.dharshi@telus.net> wrote:
>
>
>
>
> this got me into console 1 with an empty console root.
>
>
>
> will
>
>
>
> unfortunately, i don't have the experience to know
> what this means.
>
> thanks for helping.
>
>
>
> -------------------
>
>
>
>
>
>
> ____________________
______________
> Start your day with Yahoo! - Make it your home page!
> http://www.yahoo.com/r/hs
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
--
Aly Dharshi
aly.dharshi@telus.net
"A good speech is like a good dress
that's short enough to be interesting
and long enough to cover the subject"
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
| |
| Afton & Ray Still 2005-10-27, 8:04 am |
| Sorry, This was supposed to go to the list
----- Original Message -----
From: "Afton & Ray Still" <rastill@shaw.ca>
To: < operationsengineer1@
yahoo.com>
Sent: Sunday, October 23, 2005 8:50 AM
Subject: Re: [NOVICE] WinXP Install - Account Password Information
>
> ----- Original Message -----
> From: < operationsengineer1@
yahoo.com>
> To: "Aly Dharshi" <aly.dharshi@telus.net>
> Cc: <me@alternize.com>; <pgsql-novice@postgresql.org>
> Sent: Sunday, October 23, 2005 1:39 AM
> Subject: Re: [NOVICE] WinXP Install - Account Password Information
>
>
> Hello,
> I've had the same problem and near as I can tell, the solution is that
> users can only be managed this way in XP Pro. (see these two previous
> threads)
>
> PostgreSQL installation problem on Windows XP Home
> http://archives.postgresql.org/pgsq...03/msg00044.php
> basic download and setup questions
> http://archives.postgresql.org/pgsq...12/msg00092.php
>
> If anybody finds a solution that works on XP Home, please post.
>
>
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.361 / Virus Database: 267.12.4/146 - Release Date: 10/21/2005
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
| |
| operationsengineer1@yahoo.com 2005-10-27, 8:04 am |
|
--- Afton & Ray Still <rastill@shaw.ca> wrote:
> Sorry, This was supposed to go to the list
> ----- Original Message -----
> From: "Afton & Ray Still" <rastill@shaw.ca>
> To: < operationsengineer1@
yahoo.com>
> Sent: Sunday, October 23, 2005 8:50 AM
> Subject: Re: [NOVICE] WinXP Install - Account
> Password Information
>
> root.
> the
> know
> the solution is that
> these two previous
>
http://archives.postgresql.org/pgsq...03/msg00044.php
>
http://archives.postgresql.org/pgsq...12/msg00092.php
> please post.
hi all,
i super googled and found out how to delete services
(postgres or postgresql service) in winxp home.
first of all, get the service name:
start -> control panel -> administrative tools ->
services -> find the service name (may or may not be
the display name).
once you know the service name, you can delete it by:
start -> run -> type in "regedit" -> navigate to
HKEY_LOCAL_MACHINE\S
YSTEM\CurrentControl
Set\Services
-> find the service name you want to delete, delete it
-> restart.
i verified the above with my cygwin based "postgres"
service and it worked like a charm.
a second way, as yet unverified by yours truly, is to
get the service name just as you did, above, then:
start -> run -> cmd -> type in "sc delete <service
name>", where "<service name>" is the name of your
service you want deleted -> restart.
i wasn't set up to see if this registry key also holds
the password to the postgresql database server or not.
when i install 8.04, i will check the registry and
see if the password is also included in the key.
i hope this helps.
____________________
______________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
| |
| Afton & Ray Still 2005-11-04, 3:23 am |
|
----- Original Message -----
From: < operationsengineer1@
yahoo.com>
To: "Afton & Ray Still" <rastill@shaw.ca>; <pgsql-novice@postgresql.org>
Sent: Sunday, October 23, 2005 6:44 PM
Subject: Re: [NOVICE] WinXP Install - Account Password Information
> --- Afton & Ray Still <rastill@shaw.ca> wrote:
>
> http://archives.postgresql.org/pgsq...03/msg00044.php
> http://archives.postgresql.org/pgsq...12/msg00092.php
>
> does this mean it is *impossible* to change the
> service pw on winxp home?
>
I just came across a way to change the password on this type of account on
XP Home. It's not overly elegant, but it seems to work, at least sort of.
Please note: I haven't fully tested this. To make a long story short, I
tried a piece of software I read about http://www.enuffpc.com/ (please
note: I have no connection to this software) It has a free trial download.
The software is designed to take control of all the profiles on your
computer, to limit login time, etc. As part of the setup process, it detects
all the accounts on your computer. It also detects service accounts. It
gives you the option of changing the password on these accounts at this
time. It appears that it may change the account into something like a guest
account as well. I'm not sure if this destroys the functionality of the
account or not. This also allows the account to be deleted if desired.
(make sure you remove the program when your finished.)
Not overly pretty, but the closest thing I've come across to a solution.
HTH
Ray
>
>
> ____________________
______________
> Yahoo! FareChase: Search multiple travel sites in one click.
> http://farechase.yahoo.com
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.361 / Virus Database: 267.12.4/146 - Release Date: 10/21/2005
>
>
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.12.7/160 - Release Date: 11/3/2005
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
|
|
|
|
|