Re: PostgreSQL run as process in windows

On 1/2/2013 6:40 PM, tuanhoanganh wrote:
> I have more than 500 users connect to Postgres in windows 2008 R2. I
> change registry make postgres service support 512 connect. But is
> there any good way make postgres run as process not service. Is it
> safe run postgres as process in windows.

a service *is* a type of process.

yes, you could setup postgres to run in a command line window within a
desktop session, starting and stopping it with pg_ctl ... you'd want to
create a user specifically for this, and have that user own the postgres
data directory. you would need to leave this user logged onto the
console at all times, or postgres would exit when the user session
terminates.