Re: Postgres User and Password - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Postgres User and Password
Date
Msg-id Pine.BSF.4.21.0107201144530.40943-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Re: Postgres User and Password  (R Talbot <os2unix@attglobal.net>)
List pgsql-general
> > > Very inconvenient to log in as root then su postgres then back to User
> > > login to
> > > development tools..
> >
> > I have no idea why you would do that.
> >
>
>   You are indicating I should not do what?
>      Login as root then su to postgres or
>      Log back to user  to use development tools?
>         I do not auto start any servers because....
>           I am doing comparative development and each
>            development machine all 5 have installed
>                Sybase...DB2...PostgreSQL..MySQL..
>                 I don't want all 4 RDBMS running only the
>                  current working develpment session.
>                 So, I manually start Database servers.

Well, you can install postgres as a user other than postgres.

If you're the only user doing this, that's probably the easiest
thing for you, just install it as your own user, that way you
don't need to su at all.



pgsql-general by date:

Previous
From: Lamar Owen
Date:
Subject: Re: RPM source files should be in CVS (was Re: psql -l)
Next
From: Keith F Irwin
Date:
Subject: Does dropping a column from a table mess up foreign keys?