Re: using psql

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