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."