Authenticating using Windows XP login
Was looking to see if I could get pgAdmin to log into postgresql 8.0.3
on Windows XP using the current windows login information. Tried using
the ident functionality on pg_hba.conf to no avail.
Can someone post a link to a how to on this subject please?
Also can anyone tell me if there is an active project to produce a
"monitor" project that can sit in the task bar to tell us how many
users, cashe hits , start stop / reload etc.
Was looking to see if I could get pgAdmin to log into
postgresql 8.0.3 on Windows XP using the current windows
login information. Tried using the ident functionality on
pg_hba.conf to no avail.Can someone post a link to a how to on this subject please?
Also can anyone tell me if there is an active project to
produce a "monitor" project that can sit in the task bar to
tell us how many users, cashe hits , start stop / reload etc.
There is no such functionality available. The way to do is to put a
pgpass.conf file in the users directory that specifies a password to
use. See http://www.postgresql.org/docs/8.0/static/libpq-pgpass.html.
(Or you can enable trust authentication, but that will let anybody
connect as whatever user they chose, without a password and without any
verification whatsoever)
//Magnus
Import Notes
Resolved by subject fallback
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Thanks Magnus,<br>
<br>
I was specifically trying to avoid the "log into everything" approach.
Figured that if the user has logged into the computer that should be
sufficient to establish their identity.<br>
<br>
<br>
Magnus Hagander wrote:
<blockquote
cite="mid6BCB9D8A16AC4241919521715F4D8BCE6C78A6@algol.sollentuna.se"
type="cite">
<blockquote type="cite">
<pre wrap="">Was looking to see if I could get pgAdmin to log into
postgresql 8.0.3 on Windows XP using the current windows
login information. Tried using the ident functionality on
pg_hba.conf to no avail.
Can someone post a link to a how to on this subject please?
Also can anyone tell me if there is an active project to
produce a "monitor" project that can sit in the task bar to
tell us how many users, cashe hits , start stop / reload etc.
</pre>
</blockquote>
<pre wrap=""><!---->
There is no such functionality available. The way to do is to put a
pgpass.conf file in the users directory that specifies a password to
use. See <a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/8.0/static/libpq-pgpass.html">http://www.postgresql.org/docs/8.0/static/libpq-pgpass.html</a>.
(Or you can enable trust authentication, but that will let anybody
connect as whatever user they chose, without a password and without any
verification whatsoever)
//Magnus
</pre>
</blockquote>
</body>
</html>