> By the way, where I can get the pgAdmin tool? I have read that it is the
> best tool for administrating PostgreSQL in Windows.
hmm.. Dave? Where is it? Google says www.pgadmin.freeserve.co.uk (which
doesn't work). I couldn't find it on the PG website.
> Also I would like to ask something OFF-TOPIC. I have searched on the web,
> read docs and ask in other mailing list but nobody tells me how the password
> politics in PostgreSQL works. I would like to have some kind on encryption
> accessing the database, I have tried to set in the pg_hba.conf an entry for
> the host where my C++ application is, but when I use the crypt option rather
> than password, I cannot connect through the ODBC driver.
The pg_hba.conf crypt option is only for encrypting during authentication
(ie. login). The windows ODBC driver doesn't support crypt (IMHO,
pointless anyway as everything after that is not encrypted. There have
been discussions about this in the past). How passwords are stored inside
the database is an entirely different issue. I think someone wrote a
patch to do this or something similar. IIRC it was a 'crypt' (character)
data type, or maybe just some functions. In any case, you must be a
database superuser to read the passwords.
-Cedar