Page 1 of 1

Login & PostgreSQL 8.4.1

PostPosted: Tue Sep 15, 2009 5:59 am
by MartinK
So I installed the (currently) latest PostgreSQL 8.4.1 and then the latest PT3.
I followed the PDF guide for uninstalling/reinstalling PostgreSQL with minor changes since the latest postgres installes a bit differently. To be specific I didn't use the .zip files since they looked quite different from the 8.3.5 example in the pdf and just used the normal "one-click" file. Worked fine.

Everything works fine but.. upon login into windows I get the option to either login as "Administrator" or as "postgres".
I'd rather not have that "option" and wondering if I can safely remove "postgres" as a User and still have everything else working perfectly?

Did I mess up somewhere during the install or is this normal with the latest PostgreSQL 8.4.1, and can I change it?

EDIT: I'm using Windows XP Pro, incase that may be of any importance.
EDIT2: Looking at it under "User Accounts" it says that "postgres" is a "Limited Account" and "Password protected". So I assume it got created together with the database, if it isn't the same thing?

Re: Login & PostgreSQL 8.4.1

PostPosted: Tue Sep 15, 2009 8:35 am
by kraada
You want to still be logging in to Windows using your Administrator login. The postgres account is just for administering PostgreSQL; you only use it when logging into the database directly. You should not remove postgres as a user but you can hide postgres from the login options by following this tutorial.

Re: Login & PostgreSQL 8.4.1

PostPosted: Tue Sep 15, 2009 8:45 am
by MartinK
Thanks, I actually just found another way of doing it. I have a program in my Control Panel called "Tweak UI", and just found an option to remove "postgres" from the "Welcome screen".

I'm curious though for when "administering PostgreSQL" might be useful, shouldn't I be able to do that (everything) using my Administrator login anyways?

Re: Login & PostgreSQL 8.4.1

PostPosted: Tue Sep 15, 2009 8:52 am
by kraada
PostgreSQL was designed to be robust for use on multi-user servers for corporations. Thus by default it builds a user which just uses it; this is for security reasons. Your Administrator account has the power to change the users, editing most anything you could want, but the point is to keep PostgreSQL sandboxed. The normal channels for using PostgreSQL assume you are always going to log in to PostgreSQL using the postgres account.

The really short answer though is you shouldn't worry about it; PT3 will remember your details once you save your database, and the only other times you would be using that information is using pgadmin3 which unless you are going to be doing real database work probably won't come up.