[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Restoring from backup - help!

Hi all

Having diligently backed up my dataset, I am having trouble restoring.
I realised I did not back up the *separate* admin database so have
re-created that as set out in the installation documentation. I
restored the database as follows:

..hidden.. ~ $ createdb -O ledgersmb mydataset
..hidden.. ~ $ pg_restore -d mydataset mydataset-1.2.0-20100924.sqlc
..hidden.. ~ $

So no problems there. However when I try to log in using the newly
created user I get:


SELECT value FROM defaults
WHERE setting_key = 'version'
ERROR: permission denied for relation defaults

What could be the problem here?