Thread: Can postgres use the login password

I would like to pass the login password to Postgres.  Will this work?
TIA
John

On Mon, 2002-02-18 at 10:34, John Fabiani wrote:
> I would like to pass the login password to Postgres.  Will this work?
> TIA
> John

To take your stated desire literally, the answer is certainly no,
because you don't know what the password is - nor should you.

If you mean that you want a Unix user to be able to connect to
PostgreSQL under his Unix identity, this facility is provided for Unix
socket connections on certain operating systems by 7.2, where "ident"
authentication has been extended to Unix sockets.  "ident" is available
in 7.2 and earlier releses for TCP/IP but is then only as secure as the
identd server of the client's machine.  In either case, you have to
create PostgreSQL users with the same names as the Unix users who want
to connect to the database.

See the documentation in src/backend/libpq/pg_hba.conf.sample.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "All we like sheep have gone astray; we have turned
      every one to his own way; and the LORD hath laid on
      him the iniquity of us all."         Isaiah 53:6

Hi,
I've some questions about the large object.
1 the large object manipulation fonctions (lo_open, lo_lseek, lo_read....)
Are-they usable within SQL statement (Except lo_import and lo_export which
can be used in a SQL statement).
2 the large object is-it used only to store Operating Systeme files or it
can be any thing other.
If the function lo_open can be used within the SQL statement I want to know
the the value of INV_READ integer constant.
Thanks.
Mourad.