Problems connecting to the database -_mdfd_getrelnfd: cannot open relation pg_type: Permission denied

Started by Gavani, Umaover 22 years ago2 messagesgeneral

UGavani@intrusion.com

over 22 years ago

I am running into problems when attempting to connect to the database.
The server(version 7.3.2-1PGDG) starts just fine.

Running to some permission problems:

psql dbuser
ERROR: _mdfd_getrelnfd: cannot open relation pg_type: Permission denied
psql: ERROR: _mdfd_getrelnfd: cannot open relation pg_type: Permission
denied
LOG: pq_recvbuf: recv() failed: Connection reset by peer

dbuser owns all the tables and the database.
This used to work fine before.

I am new to postgres, I couldn't find any other post which was
similar.

Thank you,

Uma.

Tom Lane

tgl@sss.pgh.pa.us

over 22 years ago

In reply to: Gavani, Uma (#1)

Re: Problems connecting to the database -_mdfd_getrelnfd: cannot open relation pg_type: Permission denied

"Gavani, Uma" <UGavani@intrusion.com> writes:

psql dbuser
ERROR: _mdfd_getrelnfd: cannot open relation pg_type: Permission denied

dbuser owns all the tables and the database.

Evidently not. Better check again.

regards, tom lane