Re: Why doesn't pgsql ask me a password ???

From: Çağıl Şeker <cagils(at)biznet(dot)com(dot)tr>
To: "PostgreSQL-General-List (E-mail)" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why doesn't pgsql ask me a password ???
Date: 2002-11-21 17:08:38
Message-ID: 94327A2FE8C87C4C89A82DBE9E7B2B3F086824@beetle.biznet.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ok. I'd changed the pg_hba.conf file but I've forgotten to do a "pg_ctl reload". :)
So now it asks for passwords (because of md5 auth type)

Çağıl ŞEKER
-----------------
"Yes, I am a criminal. My crime is that of outsmarting you. Something that you'll never forgive me for!" - The Mentor'86 (Hacker's Manifesto)
-----------------
Ey kör ! Bu yer, bu gök, bu yıldızlar boştur boş !
Bırak onu bunu da gönlünü hoş tut hoş !
Şu durmadan kurulup dağılan evrende
Bir nefestir alacağın, o da boştur boş !
-- Ömer HAYYAM

-----Original Message-----
From: Çağıl Şeker
Sent: 21 Kasım 2002 Perşembe 18:59
To: PostgreSQL-General-List (E-mail)
Subject: [GENERAL] Why doesn't pgsql ask me a password ???

Administrator(at)CAGILS ~ $ whoami
Administrator
Administrator(at)CAGILS ~ $ psql -U postgres EDYS
Welcome to psql, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit

EDYS=# select * from pg_user ;
usename | usesysid | usecreatedb | usetrace | usesuper | usecatupd | passwd | valuntil
----------+----------+-------------+----------+----------+-----------+----------+----------
postgres | 1 | t | t | t | t | ******** | infinity
(1 row)

EDYS=#

As it can be seen, it does not ask me for a password. How can I make pgsql (or precisely the postmaster) ask for a password??? Tnx in advance..

Çağıl ŞEKER
-----------------
"Yes, I am a criminal. My crime is that of outsmarting you. Something that you'll never forgive me for!" - The Mentor'86 (Hacker's Manifesto)
-----------------

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-11-21 17:17:03 Re: stability of pg library usage
Previous Message Çağıl Şeker 2002-11-21 16:59:14 Why doesn't pgsql ask me a password ???