[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Restoring from backup - help!
- Subject: Restoring from backup - help!
- From: Phil <..hidden..>
- Date: Mon, 18 Oct 2010 12:09:14 +0100
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?