Re: [Ledger-smb-users] Restoring from backup

2012-11-08 Thread Erik Huelsmann
From: Erik Huelsmann > To: ledger-smb-users > Sent: Wed, 7 Nov 2012 21:17 > Subject: Re: [Ledger-smb-users] Restoring from backup > > Hi Richard, > > On Wed, Nov 7, 2012 at 5:38 PM, wrote: > >> Back to where I was 3 weeks ago - the 1.2 dbase seems ok, but it will >&

Re: [Ledger-smb-users] Restoring from backup

2012-11-08 Thread lrspares45
m the web. Cheers Richard -Original Message- From: Erik Huelsmann To: ledger-smb-users Sent: Wed, 7 Nov 2012 21:17 Subject: Re: [Ledger-smb-users] Restoring from backup Hi Richard, On Wed, Nov 7, 2012 at 5:38 PM, wrote: Back to where I was 3 weeks ago - the 1.2 dbase see

Re: [Ledger-smb-users] Restoring from backup

2012-11-07 Thread Erik Huelsmann
Hi Richard, On Wed, Nov 7, 2012 at 5:38 PM, wrote: > Back to where I was 3 weeks ago - the 1.2 dbase seems ok, but it will not > update to 1.3. Has anyone actually achieved this or am I trying to do the > impossible? Looks like the company will probably go bust now, can't find > stock in the sto

Re: [Ledger-smb-users] Restoring from backup

2012-11-07 Thread lrspares45
c etc... -Original Message- From: lrspares45 To: ledger-smb-users Sent: Wed, 7 Nov 2012 16:20 Subject: [Ledger-smb-users] Restoring from backup Well, progress I got setup to work, and I can log into ledgersmb ok - but there's no data! I couldn't get pg_restore

[Ledger-smb-users] Restoring from backup

2012-11-07 Thread lrspares45
Well, progress I got setup to work, and I can log into ledgersmb ok - but there's no data! I couldn't get pg_restore -U postgres -C data.sqlc to work at all - I just got numbers whizzing by in the terminal, so I resorted to restoring through pgAdminIII. All the expected tables are there I

Re: [Ledger-smb-users] Restoring from backup

2012-10-18 Thread Kevin Bailey
backup To: -Original Message- From: Kevin Bailey To: ledger-smb-users Sent: Thu, 18 Oct 2012 15:58 Subject: Re: [Ledger-smb-users] Restoring from backup Install phppgadmin so you can see what you are getting. Sent from my HTC I have pdadmin - I seem to have create a server with

Re: [Ledger-smb-users] Restoring from backup

2012-10-18 Thread Kevin Bailey
Install phppgadmin so you can see what you are getting. Sent from my HTC - Reply message - From: lrspare...@aol.com Date: Thu, Oct 18, 2012 15:26 Subject: [Ledger-smb-users] Restoring from backup To: -Original Message- From: lrspares45 To: ledger-smb-users Sent: Thu

Re: [Ledger-smb-users] Restoring from backup - help!

2010-10-18 Thread Phil
I've managed to solve this one, a Postgres permissions problem - see below. I'm not sure why "sql-ledger" is there - maybe the service account was different on the restore? GRANTing access permissions to _every_ table did the trick. Not sure why I have to do that when the database _owner_ is ledger

Re: [Ledger-smb-users] Restoring from backup - help!

2010-10-18 Thread Bob Miller
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: > H

[Ledger-smb-users] Restoring from backup - help!

2010-10-18 Thread Phil
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: postg...@www ~ $ createdb -O ledgersmb mydataset post