installing 8.4 creates a new user account

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

installing 8.4 creates a new user account

Postby rowhousepd » Thu Apr 08, 2010 4:11 am

I just completely uninstalled postgres 8.3 and upgraded to 8.4.3. Things seem to be fine so far, but for some reason the reinstalling process created a new windows user account called "postgres" which is password protected. (Not surprisingly it was dbpass.) Is it normal for postgres to create another user account? And if so, do I need to leave it there? I'd rather delete and not have multiple ways to log into windows.
rowhousepd
 
Posts: 329
Joined: Sun Mar 22, 2009 4:00 am
Location: Philadelphia, PA

Re: installing 8.4 creates a new user account

Postby WhiteRider » Thu Apr 08, 2010 5:52 am

Yes - you need this 'postgres' account. All versions of postgres have that, it's how database permissions are controlled.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: installing 8.4 creates a new user account

Postby WhiteRider » Thu Apr 08, 2010 5:53 am

If you want to hide the 'postgres' user from the login window, you can do that by following these instructions.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK

Re: installing 8.4 creates a new user account

Postby rowhousepd » Thu Apr 08, 2010 5:38 pm

Hmmm. None of the suggestions there seem to be working. I know it's not PT3's domain, but is there another fix you recommend? Also, why didn't it exist (or at least was invisible) w/ the initial PT3 installation using v8.3, but now it seems to have appeared when I upgraded?

Also, somewhat related to that: Do I even want to keep this upgrade? I mean, 8.3 was working ok but I figured a newer version would be better, or at least it couldn't hurt. Is it tested & stable, and is there a meaningful difference do you think?
rowhousepd
 
Posts: 329
Joined: Sun Mar 22, 2009 4:00 am
Location: Philadelphia, PA

Re: installing 8.4 creates a new user account

Postby WhiteRider » Fri Apr 09, 2010 2:44 am

The postgres user has always been created - I don't know why you didn't see it before; it's possible that PT3 does something different when it installs postgres.
We haven't heard of any problems in 8.4 so you should be fine with it - I wouldn't change back to 8.3 unless you have a specific reason to.
WhiteRider
Moderator
 
Posts: 54025
Joined: Sat Jan 19, 2008 7:06 pm
Location: UK


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 0 guests