Re: using psql - Mailing list pgsql-novice

From John DeSoi
Subject Re: using psql
Date
Msg-id CEBBAB09-9F8E-11D9-A2EC-000A95B03262@pgedit.com
Whole thread Raw
In response to using psql  ("Stephen Choularton" <mail@bymouth.com>)
List pgsql-novice
On Mar 27, 2005, at 3:40 PM, Stephen Choularton wrote:

> Bit more on my problem.  The password I am after is to use psql.
>
>  
>
> When I do the following – I don’t know the password:
>
>  
>
> C:\Documents and Settings\Stephen>psql
>
> Password:
>
> psql: FATAL:  password authentication failed for user "Stephen"
>
>  
>
> is there an initial default password, or is there some file I can
> change.  (Windows XP)
>
>  


You can temporarily modify the pg_hba.conf file so that no password is
required. See

http://www.postgresql.org/docs/8.0/interactive/client-
authentication.html

There are examples in the file itself -- just change the authentication
method to 'trust' for 127.0.0.1.



John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL


pgsql-novice by date:

Previous
From: Ramon Orticio
Date:
Subject: how to connect to posgresql 8 using vb
Next
From: Bruno Wolff III
Date:
Subject: Re: [pgsql-advocacy] Function which gives back the nearest neighbours