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
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 |
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? |