Re: new install, can't use - need password for postgres user

Thanks very much for getting back to me.

OK, so I first change the pg_hba.conf file to add local hosts, restart the service, and that is good - postgresql restarted fine.

I then run psql.exe from command line, as you suggested and I get the following:

psql: FATAL: password authentication failed for user "postgres"

So, I need a password. I tried several passwords, and none worked...did I set this password on install? If yes, then my bad and I will have to resintall, because I just don't remember what it was. Then I guess I am kind of dumb, though in my defence, I first installed this a month ago and I am just getting back to it now.

Cheers,

Doug

>
> Try psql. It should be there in bin directory under postgresql installation. For example -
> D:\Applns\PostgreSQL\8.4\bin
>
> H:\>psql -U postgres
> Password for user postgres:
> psql (8.4.3)
>
>
> > tables...that should take like 2 minutes. Does anyone else think
> > this is ridiculous? Help please.
> You could try having just one line in the hba file?
> local all all trust
>
>
> Then you could add users with passwords.... and have an entry similar to
> host all all 192.168.0.0/16 md5
>
> Read a bit more and change the
> local all all trust
> to something more restrictive?
> http://www.postgresql.org/docs/8.2/static/auth-pg-hba-conf.html
>
> Regards,
> Jayadevan
>
>
>
>
>
> DISCLAIMER:
>
> "The information in this e-mail and any attachment is intended only for the person to whom it is addressed and may contain confidential and/or privileged material. If you have received this e-mail in error, kindly contact the sender and destroy all copies of the original communication. IBS makes no warranty, express or implied, nor guarantees the accuracy, adequacy or completeness of the information contained in this email or any attachment and is not liable for any errors, defects, omissions, viruses or for resultant loss or damage, if any, direct or indirect."
>
>
>
>