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