| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | Sasha <ntd-linux(at)land(dot)ru> |
| Cc: | <pgsql-general(at)PostgreSQL(dot)org> |
| Subject: | Re: problem with password |
| Date: | 2003-03-04 21:31:49 |
| Message-ID: | 20030304133133.L56946-100000@megazone23.bigpanda.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, 27 Feb 2003, Sasha wrote:
> I create the database by following:
>
> mkdir -p /usr/local/pgsql/data
> chown postgres /usr/local/pgsql/data
> su postgres
>
> initdb -D /usr/local/pgsql/data
> postmaster -D /usr/local/pgsql/data
> createdb appc
> psql appc
>
> Then i create a same user:
>
> create user dima with password 'dima'
> \q
>
> Then:
>
> psql appc -U dima -W
> Password: __Input any password__ - enter to postgresql.
>
> Why i can access to database with any password? What is my error?
What does your pg_hba.conf file (in the data directory) say?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Douglas Blood | 2003-03-04 21:48:55 | Re: problem with password |
| Previous Message | Dennis Gearon | 2003-03-04 21:27:51 | Re: Demande d'information |