Skip site navigation (1) Skip section navigation (2)

Re: user passwords

From: "Nick Fankhauser" <nickf(at)ontko(dot)com>
To: "Jodi Kanter" <jkanter(at)virginia(dot)edu>, "Postgres Admin List" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: user passwords
Date: 2001-12-20 17:26:02
Message-ID: NEBBLAAHGLEEPCGOBHDGAEKCEBAA.nickf@ontko.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)ontko(dot)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(at)postgresql(dot)org
> [mailto:pgsql-admin-owner(at)postgresql(dot)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(at)virginia(dot)edu
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>


In response to

pgsql-admin by date

Next:From: ChristianDate: 2001-12-20 19:14:52
Subject: Re: Data partitioning
Previous:From: Felipe NascimentoDate: 2001-12-20 16:46:42
Subject: Re: user passwords

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group