Sorry Copy and Paste finger trouble I got the correct syntax from http://www.postgresql.org/docs/9.1/static/sql-createdatabase.html
Tim Wade Penguin Products Ph: (021) 797-0725 Fax: (021) 762-4644 [image: Picture] On Thu, Oct 11, 2012 at 6:53 PM, Penguin Products <[email protected] > wrote: > 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
