I'm attempting to get a PostgreSQL environment running locally. I'm using 9.2.8, and have restored data from a backup made by the DBA of the production environment.
The restoration worked fine with 0 errors; however, in a couple of the Views there is a missing field that is in the production schema from which we restored our data.
As well, when attempting to do a simple select from the Views mentioned using the postgres role, I always get the following error:
ERROR: permission denied for relation Map ********** Error ********** ERROR: permission denied for relation Map SQL state: 42501
After doing some research (read: Googling), I tried GRANTing priveleges on the Schema, Views, and associated tables (in this case, the table 'Map') to avail.
Obviously, I'm a neophyte PostgreSQL user. I'm sure there's something simple I'm missing. But what could it be?