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

Re: Restoring from backup - help!

This is a shot in the dark, but if you can get to the administration
interface, maybe try setting the user you are trying to log in as
administrator or something higher than user.  It is a drop down menu at
the top of the list of check mark boxes.

On Mon, 2010-10-18 at 12:09 +0100, Phil wrote:
> 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:
> Error!
> LedgerSMB/User.pm:207
> SELECT value FROM defaults
> WHERE setting_key = 'version'
> ERROR: permission denied for relation defaults
> What could be the problem here?
> ------------------------------------------------------------------------------
> Download new Adobe(R) Flash(R) Builder(TM) 4
> The new Adobe(R) Flex(R) 4 and Flash(R) Builder(TM) 4 (formerly 
> Flex(R) Builder(TM)) enable the development of rich applications that run
> across multiple browsers and platforms. Download your free trials today!
> http://p.sf.net/sfu/adobe-dev2dev
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users

Bob Miller
Network, Internet, Server,
and Open Source Solutions