Обсуждение: user passwords
why is it that I can sign in to the postgres database using PSQL without having to specify a password for a user even thought one has been specified in pg_shadow? I signed in to Linux with my own personal id (which is NOT a postgres account) and used the following command to get in: psql -U postgres dbname It let me in to our database as postgres (a superuser account) without even prompting for a password. Am I missing something? thanks Jodi _______________________________________________________________ Jodi L Kanter BioInformatics Database Administrator University of Virginia (804) 924-2846 jkanter@virginia.edu
take a look at http://archives.postgresql.org/pgsql-admin/2001-09/msg00095.php
-----Original Message-----
From: Jodi Kanter [mailto:jkanter@virginia.edu]
Sent: quinta-feira, 20 de dezembro de 2001 14:19
To: Postgres Admin List
Subject: [ADMIN] user passwords
why is it that I can sign in to the postgres database using PSQL without
having to specify a password for a user even thought one has been specified
in pg_shadow?
I signed in to Linux with my own personal id (which is NOT a postgres
account) and used the following command to get in:
psql -U postgres dbname
It let me in to our database as postgres (a superuser account) without even
prompting for a password.
Am I missing something?
thanks
Jodi
_______________________________________________________________ Jodi L
Kanter BioInformatics Database Administrator University of Virginia (804)
924-2846 jkanter@virginia.edu
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
You might want to take a look at your pg_hba.conf file to see if the auth-method is "trust". Details are here: http://www.postgresql.org/idocs/index.php?client-authentication.html#PG-HBA. CONF -Nick -------------------------------------------------------------------------- Nick Fankhauser nickf@ontko.com Phone 1.765.935.4283 Fax 1.765.962.9788 Ray Ontko & Co. Software Consulting Services http://www.ontko.com/ > -----Original Message----- > From: pgsql-admin-owner@postgresql.org > [mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Jodi Kanter > Sent: Thursday, December 20, 2001 11:19 AM > To: Postgres Admin List > Subject: [ADMIN] user passwords > > > why is it that I can sign in to the postgres database using PSQL without > having to specify a password for a user even thought one has been > specified > in pg_shadow? > > I signed in to Linux with my own personal id (which is NOT a postgres > account) and used the following command to get in: > > psql -U postgres dbname > > It let me in to our database as postgres (a superuser account) > without even > prompting for a password. > > Am I missing something? > thanks > Jodi > _______________________________________________________________ Jodi L > Kanter BioInformatics Database Administrator University of Virginia (804) > 924-2846 jkanter@virginia.edu > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org >