Re: permission denied for relation - Mailing list pgsql-general

From Tom Lane
Subject Re: permission denied for relation
Date
Msg-id 31885.1391095967@sss.pgh.pa.us
Whole thread Raw
In response to Re: permission denied for relation  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Adrian Klaver <adrian.klaver@gmail.com> writes:
> I would tend to go with Raymond, are you sure about the user you are
> connecting as?

That's my thought as well.

> It would be helpful to tail the Postgres log and see what the connection
> info is.

Note you will need to turn on "log_connections" to have the relevant
info logged.  If the program with the problem keeps a persistent
connection, you could also look into pg_stat_activity.

            regards, tom lane


pgsql-general by date:

Previous
From: Klaus Ita
Date:
Subject: Re: permission denied for relation
Next
From: Ovid
Date:
Subject: Re: permission denied for relation