I am getting the following error from psql but have no idea where it
comes from:
ERROR: cache lookup for userid 1003 failed
1003 is the login id for the postgresql user, who owns all of the
postgresql installation.
I have one database installed and can work with it via either the psql
interface or the python interface.
I just created a second database (successfully) from within psql
(i.e., create database command) and can connect to it. I can also
access some system tables via, for example, \do or \df while connected
to this new database. But I cannot access a list of tables with \dt
without getting this error.
The only "oddity" about my installation (as far as I know) is that I
symlinked the data directory to another disk after creating the first
database, but before creating the second one. Of course I copied the
entire data directory to the new location.
Any clues would be helpful.
Thanks.
Cheers,
Brook
************
