Mailing-List:	contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe:	<mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive:	<http://sources.redhat.com/ml/cygwin/>
List-Post:	<mailto:cygwin AT cygwin DOT com>
List-Help:	<mailto:cygwin-help AT cygwin DOT com>, <http://sources.redhat.com/ml/#faqs>
Sender:	cygwin-owner AT cygwin DOT com
Mail-Followup-To:	cygwin AT cygwin DOT com
Delivered-To:	mailing list cygwin AT cygwin DOT com
Date:	Fri, 13 Dec 2002 07:58:16 -0500
From:	Jason Tishler <jason AT tishler DOT net>
Subject:	Re: Changing to another user in cygwin -- login?
In-reply-to:	<3DF984D7.3030305@intekom.co.za>
To:	cygwin AT cygwin DOT com
Mail-followup-to:	cygwin AT cygwin DOT com
Message-id:	<20021213125816.GA1704@tishler.net>
MIME-version:	1.0
User-Agent:	Mutt/1.4i
References:	<3DF984D7 DOT 3030305 AT intekom DOT co DOT za>

Andre,

On Fri, Dec 13, 2002 at 08:57:27AM +0200, Andre Truter wrote:
> Now I want to run the createdb, etc scritps as user postgres to create
> a new database.

What about using the "--username" option?

    $ id
    uid=19695(jt) gid=10513(Domain Users)...
    $ psql -l
    psql: FATAL:  user "jt" does not exist
    $ psql -l --username postgres
            List of databases
    ...

> I have tried 'login postgres' from a bash shell, but this is the result:
> $ login postgres
> Password:
> Login incorrect
> login:

Search the archives to understand why the above does not work.
 
> I also followed all the instructions in the postgres readme.
                  ^^^

Really?  What about the following:

    [2] The "$" prompt indicates running as the "postgres" user.  Log in
        as "postgres" or use ssh to emulate Unix's "su" command.
                         ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Jason

-- 
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6

--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Bug reporting:         http://cygwin.com/bugs.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/

- Raw text -