Hi Jean Pierre we apparently did try setting up pgadmin a few years ago but it failed. So sadly we havent.... only webmin...
Tim Wade Penguin Products Ph: (021) 797-0725 Fax: (021) 762-4644 [image: Picture] On Wed, Oct 10, 2012 at 10:46 AM, Jean Pierre Guillou < [email protected]> wrote: > Dear Tim > > Do you still have your old server running? If you do, do you have pgadmin > III installed? > > If yes to the above, I can give you instructions to do the data transfer > in a different way, that works for us. > > I even have a version of 123 (2.8.33) running on a laptop. > > Please advise. > > Regards > > Jean-Pierre > > > > > *Please note my new e-mail address** : **[email protected]* > _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ > /_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ > Jean-Pierre Guillou > CEO > *DCDM Management Services Ltd* > > Tel PABX : (230) 202 3000 > Tel Direct : (230) 202 3057 > Fax : (230) 208 0086 > Web :www.dcdm-ms.com > > Business Registration Number : C07051938 > > ******************************************************************** > Privileged/Confidential Information may be contained in this message. If > you are not the addressee indicated in this message (or responsible for > delivering the message to the intended recipient), you should not read it, > nor copy or deliver this message to anyone. In such case, you should > destroy this message and kindly notify the sender by reply E-mail. > Opinions, conclusions and other information in this message that do not > relate to the official business of any member firm of the DCDM Organisation > shall be understood as neither given nor endorsed by the firm. > > Please consider the environment before printing this e-mail! > Want a signature like mine? > <http://r1.wisestamp.com/r/landing?promo=21&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_21> > CLICK > HERE.<http://r1.wisestamp.com/r/landing?promo=21&dest=http%3A%2F%2Fwww.wisestamp.com%2Femail-install%3Futm_source%3Dextension%26utm_medium%3Demail%26utm_campaign%3Dpromo_21> > > > > On 10 October 2012 19:33, 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 >> >> > > _______________________________________________ > 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
