Re: Admin questions on NT - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: Admin questions on NT
Date
Msg-id Pine.LNX.4.30.0101262006280.769-100000@peter.localdomain
Whole thread Raw
In response to Admin questions on NT  (lbottorff@harveycounty.com)
List pgsql-admin
lbottorff@harveycounty.com writes:

> I have set up 7.0.3 on my NT machine (no hope for non-Microsoft at this time) at
> my place of employment. I set it up as user "larryb". The larryb account has
> Administrator privledges, something (as I understand) had to be in order to
> install a fully  functional cygwin. Now, because I installed 7.0.3 as larryb,
> the user larryb is the Postgres DBA-superuser, right? I'm wondering/worried that
> because I did not install as the user "postgres", an NT account that has no NT
> Administrator privledges, I'm screwed security-wise. Does the superuser have to
> be postgres? Can a non-NT Administrator even install cygwin?

To run PostgreSQL, the server or initdb, you should preferably not use a
privileged account because if the server gets compromised, your system is
one step away from being hosed.

But the user as which the server runs does not have to be named
"postgres".

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


pgsql-admin by date:

Previous
From: lbottorff@harveycounty.com
Date:
Subject: Admin questions on NT
Next
From: Bruce Momjian
Date:
Subject: Re: Some thoughts on replication