Re: [SLUG] a simple cygwin question... I think.

From: Paul M Foster (paulf@quillandmouse.com)
Date: Thu Apr 24 2003 - 18:11:19 EDT


On Thu, Apr 24, 2003 at 10:10:55AM -0700, Jared Quedens wrote:

>
> --- Russell Hires <rhires@earthlink.net> wrote:
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA1
> >
> > Is this a problem w/ Cygwin, or posgresql? There are postgresql docs
> about how
> > to run it as a non-root user...I can't help you with cygwin, though...
>
> Ya its mainly a cygwin problem, I dont know how to "su postgres" or login
> as postgres. nothing
> seems to work.

Though your main problems appear to be with cygwin (which I know nothing
about), PostgreSQL is easier. You have to su postgres from root (there
is no password for the postgres user). Then do createuser (man
createuser) to set up a "regular" PostgreSQL user to your specs (can
they create databases? users? etc.). You can also create a password for
the postgres user if you like (man passwd).

Paul



This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 18:30:30 EDT