Cannot connect to the database (PG 7.3)

From: Michiel Lange <michiel(at)minas(dot)demon(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: Cannot connect to the database (PG 7.3)
Date: 2003-01-27 00:25:06
Message-ID: 5.1.0.14.0.20030127011523.00b33440@192.168.1.3
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-hackers

Hello people,

I have this Postgres 7.3 database, and could not find if this is a known
issue, but:
I can connect to the database with my postgres user to a remote database.
This as supposed with
psql -d mydb -h 123.456.789.001 -U postgres
it goes fine... postgres user exists on my system and the other system.
Both versions of Postgres are the same (7.3)

However, I have another user, (whose name is a number) that does not exist
on operating system level:
psql -d mydb -h 123.456.789.001 -U 20020003
or from within php:
pg_connect("host=123.456.789.001 dbname=mydb user=20020003 password=secret");

I get this error message:
psql: FATAL: permission denied

while I do not get that message with postgres-user...
Anyone who knows where the problem lies?
I am thinking of:
- Users must exist both in the database and on the operating system. (which
would be strange I think)
- Usernames may not exist solely out of numbers

If the mistake is because I have missed it in the documentation, I am
sorry... I'll try to be more cautious next time...

Michiel

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-01-27 00:42:14 Re: Cannot connect to the database (PG 7.3)
Previous Message Bruce Momjian 2003-01-26 23:51:36 Re: Password Encryption

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-01-27 00:42:14 Re: Cannot connect to the database (PG 7.3)
Previous Message Tom Lane 2003-01-27 00:11:56 Re: Can we revisit the thought of PostgreSQL 7.2.4?