Home > mailing lists

Thread: problem with password

problem with password

From

"Sasha"

Date:

04 March 2003, 19:25:09

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?

Re: problem with password

From

"Douglas Blood"

Date:

05 March 2003, 03:59:38

update user set password = password('dima') where user = 'dima'

that should fix your problem.

----- Original Message -----
From: Sasha
To: pgsql-general@PostgreSQL.org
Sent: Thursday, February 27, 2003 10:49 AM
Subject: [GENERAL] problem with password

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?

Re: problem with password

From

Stephan Szabo

Date:

05 March 2003, 07:11:47

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?