Finally sorted it all out, thanks so much, the bottom line is you shouldn't let a part time person who THINKS he might be able to do something like this near a command line.....(that person being me)... Bottom line was that I was trying to access the pg database as sql-ledger and I had not set sql-ledger up correctly as a user, as you all guessed, (please excuse the laymans terms... thats what I am when it comes to this) so Postgres wasn't me letting in. Also the syntax has changed slightly from psql 8.3 to 9.1 which is what Ubuntu 12.04 is running... finally got that figured out with a little help from a friend (ie sat and watched him do it on teamview), applied Armaghan's Custom tables to the database and it looks like I'm in business.
http://www.ledger123.com/archives/msg05860.html is what got us on the right track and then a quick google of http://www.ledger123.com/archives/msg05860.html got us the right syntax. and it all finally worked I am indebted especially to Rolf who took the time to look at my initial disaster of an install and so stopped me wasting days trying to make something work that was broken, to Amarghan for his advice and help and to Jean Pierre who offered to sort out my databse for me if we didn't come right. I am very grateful to you all I've learnt a huge amount over the last few days and am in awe at your abilities to make computers do things I only dream about!! Tim Wade Penguin Products Ph: (021) 797-0725 Fax: (021) 762-4644 [image: Picture] On Wed, Oct 10, 2012 at 5:33 PM, Penguin Products <[email protected] > wrote: > Hi Armaghan > > We ran the Pg-custom_tables.sql on the database after importing the > dataset. no errors were reported during that process, but we still have the > same error on login into sql-ledger > Error! > > *SELECT * FROM defaults > ERROR: permission denied for relation defaults* > > If I login using a test database Sql-ledger runs fine. > > > Thanks again > Tim Wade > Penguin Products > Ph: (021) 797-0725 > Fax: (021) 762-4644 > > [image: Picture] > > > > On Wed, Oct 10, 2012 at 2:38 AM, Armaghan Saqib <[email protected]>wrote: > >> On Wed, Oct 10, 2012 at 2:10 PM, Penguin Products < >> [email protected]> wrote: >> >>> Thank you to all who helped, I now have a working version of Ledger123 >>> (2.8.33) up and running. >>> >>> How do I restore the backup from Sql Ledger 2.8.14 onto this current >>> version. When I import the penguin.sql file, I get an error on login that's >>> a SQL error which means it's looking for something that doesn't exist or >>> the sql is different. >>> >>> to do the import I did: psql [database] < databasename.sql >>> so psql penguin < penguin.sql >>> if I create the dataset in sql-ledger the import gives errors but still >>> completes >>> if i create an empty database and import there are no errors on import >>> but either way they give the same error on login. >>> >>> Please run sql/Pg-custom_tables.sql on the database after importing your >> dataset. This should fix the problem. >> >> If not, post the error message. >> >> Regards >> Armaghan >> >> _______________________________________________ >> SQL-Ledger mailing list >> [email protected] >> http://lists.ledger123.com/mailman/listinfo/sql-ledger >> >> >
_______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
