Re: Windows Installation User account - Correct database for us

From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Don Brown
Sent: Thursday, July 10, 2014 7:56 PM
To: pgsql-general(at)postgresql(dot)org
Subject: [GENERAL] Windows Installation User account - Correct database for us

Hello

We are writing a small application and we are trying to determine if PostgreSQL is the right database for us.

The application at this stage is only for a single user and commonly for persons with little computer expertise.

When the database is installed a postgreSQL user account is created which in most cases will be the second user account on the PC.  The result of this is the user now has to select the user account when ever the computer is restarted.

The programmer working on this application has suggested looking at an imbedded database, something like H2 as an alternative.

I was hoping the members of this group may have some comments or suggestions as to the direction we should look at.

Thank you and appreciate any comments/suggestions

Don
 
--------------------------------------------------

Don,

PostgreSQL user account is only supposed to be used as an account under which Postgres service runs.
Using Control Panel you can try to revoke "log in local" from PostgreSQL account (in Win7 it's actually "deny log in local").

Regards,
Igor Neyman