pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
security - user account setup on SUSE
2+ messages / 2 participants
[nested] [flat]

* security - user account setup on SUSE
@ 2005-05-11 18:42  Brandon Fouts <BFouts@psrc.org>
  0 siblings, 1 reply; 2+ messages in thread

From: Brandon Fouts @ 2005-05-11 18:42 UTC (permalink / raw)
  To: pgsql-admin

I think for security reasons I should not run PostgreSQL from the root account.
Also, as PostgreSQL will probably be only one of the applications running on this box.
(would running in UML give me any extra security? - I suspect not the right tool??)

IF I'm wrong to worry about root account, now is the time to inform me. Otherwise read on.

(I have setup once and I think I had it running from the root account.)

background SUSE 9 and YAST install of PostgreSQL creates the following directories:

/usr/lib/postgresql/
/usr/share/postgresql/
/usr/share/pgsql/
/var/lib/pgsql/backup
/var/lib/pgsql/data

and currently status shows unused 
# rcpostgresql status     unused        (rc - is this some kind of scripting??)

Can anyone offer some guidance?


 
   




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: security - user account setup on SUSE
@ 2005-05-12 10:59  Ivo Rossacher <rossacher@bluewin.ch>
  parent: Brandon Fouts <BFouts@psrc.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Ivo Rossacher @ 2005-05-12 10:59 UTC (permalink / raw)
  To: pgsql-admin

Am Mittwoch, 11. Mai 2005 20:42 schrieb Brandon Fouts:
> I think for security reasons I should not run PostgreSQL from the root

yes.

> account. Also, as PostgreSQL will probably be only one of the applications
> running on this box. (would running in UML give me any extra security? - I
> suspect not the right tool??)

Don't think this helps by it self.

>
> IF I'm wrong to worry about root account, now is the time to inform me.
> Otherwise read on.
>
> (I have setup once and I think I had it running from the root account.)
>
> background SUSE 9 and YAST install of PostgreSQL creates the following
> directories:
>
> /usr/lib/postgresql/
> /usr/share/postgresql/
> /usr/share/pgsql/
> /var/lib/pgsql/backup
> /var/lib/pgsql/data
>
> and currently status shows unused
> # rcpostgresql status     unused        (rc - is this some kind of
> scripting??)
>
> Can anyone offer some guidance?

In the Yast tool you can start the servers you need in the Runlevel-Editor.
There you can select in which runnlevels you want it to run as well.
When you start it there, at startup a scritp will be executed with root 
permission. This script will start then the Server with postgres as user. So 
the database does not run under root permission (which would be definitly 
bad).

Best regards
Ivo

>--------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2005-05-12 10:59 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-05-11 18:42 security - user account setup on SUSE Brandon Fouts <BFouts@psrc.org>
2005-05-12 10:59 ` Ivo Rossacher <rossacher@bluewin.ch>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox