Postgres Pro
Downloads
Home   >   mailing lists

Thread: updating windows installation

updating windows installation

From
"Rick Schumeyer"
Date:

Last month I installed the windows version of 8.0 RC1.  The installation

installed postgresql as a service with user “postgres”, and an associated

password.  “postgres” is a service user, not a standard user.

 

Yesterday, I uninstalled 8.0 RC1 and then installed 8.0 RC3.  That worked,

once I realized that the “postgres” service user was never deleted, and

that I could only install RC3 if I remembered the password from RC1.  I guess

I could also use a different name for the service user.

 

It seems that I may be able to change the password for the postgres service

user IF postgres is still registered as a service (before I uninstall).  But, if I have

already uninstalled postgres, can I still change the password of delete the user?

 

Re: updating windows installation

From
"Magnus Hagander"
Date:
You can change the password at any time. Use the MMC snapin "Local Users and Groups" in Windows - it's just a standard user. (This snapin is also available from the Computer Management MMC console). This assume Win2000 or newer. If you're on NT4, yo use "User Manager".
 
Or you can run "net user postgres MyNewPassword" on the commandline to change the password to MyNewPassword. This should work on all supported versions.
 
 
//Magnus
 
-----Original Message-----
From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Rick Schumeyer
Sent: den 7 januari 2005 17:28
To: pgsql-admin@postgresql.org
Subject: [ADMIN] updating windows installation

Last month I installed the windows version of 8.0 RC1.  The installation

installed postgresql as a service with user “postgres”, and an associated

password.  “postgres” is a service user, not a standard user.

 

Yesterday, I uninstalled 8.0 RC1 and then installed 8.0 RC3.  That worked,

once I realized that the “postgres” service user was never deleted, and

that I could only install RC3 if I remembered the password from RC1.  I guess

I could also use a different name for the service user.

 

It seems that I may be able to change the password for the postgres service

user IF postgres is still registered as a service (before I uninstall).  But, if I have

already uninstalled postgres, can I still change the password of delete the user?

 

error in start a Data base

From
"Miguel Angel Mejia Argueta"
Date:
Hi .

I have a problem with postgress, i changed in last days the IP of my
server and now I can't connect to DB. The server show me the next message:


psql: FATAL 1:  Missing or erroneous pg_hba.conf file, see postmaster log
for details

And my pg_hba.conf file this the next

# host       template1   192.168.12.10 255.255.255.255    md5

local    MyDatabase     127.0.0.1     255.255.255.0     password pass/pg_ltx


do you have any idea what cuoud have happend?

Thanks

Re: error in start a Data base

From
Michael Fuhr
Date:
On Fri, Jan 07, 2005 at 11:47:01AM -0600, Miguel Angel Mejia Argueta wrote:

> psql: FATAL 1:  Missing or erroneous pg_hba.conf file, see postmaster log
> for details
>
> And my pg_hba.conf file this the next
>
> # host       template1   192.168.12.10 255.255.255.255    md5
>
> local    MyDatabase     127.0.0.1     255.255.255.0     password pass/pg_ltx

See the "Client Authentication" chapter in the PostgreSQL documentation
and the comments at the beginning of pg_hba.conf.  They describe the
format of the lines in that file.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/