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
Content-type: text/plain; charset=us-ascii
Content-transfer-encoding: 7BIT
Content-disposition: inline
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/