Thread: using psql
Hi
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)
Stephen
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.8.1 - Release Date: 23/03/2005
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