[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: restore database errors
- Subject: Re: restore database errors
- From: "RYAN M. vAN GINNEKEN" <..hidden..>
- Date: Mon, 23 Apr 2007 11:36:37 -0700 (MST)
I am using pgadminIII aready the only instructions i could find on your website are the upgrading ones. These do not seem to apply as i have a broken version of sqlledger on one server and a new version of smbledger on the new server. All i need is to transfer my data set to the new server which i think i have done but i get this error when i try to login to ledgersmb
SELECT value FROM defaults
WHERE setting_key = 'version'
ERROR: relation "defaults" does not exist
----- Jeff Kowalczyk <..hidden..> wrote:
> RYAN M. vAN GINNEKEN wrote:
> > I do not really follow all the postgres mobojumbo about ownerships
> > roles and all nor do i really care. However i really really need
> > system to work ASAP i cannot print invoices or enter daily
> > Could you possibly explain it to me so i can understand and make
> > work as you may have noticed i am extremely frustrated. Sorry to be
> > pain but i did not find a solution in either of the last posts and
> > i try to login i get this error please help and thank you kinly in
> > advance.
> Well, LedgerSMB is very much a postgresql system, so you'll want to
> your way around database management in postgresql before trusting
> accounting data to be stored in it. You could find yourself in a much
> worse spot than not being able to get started, such as deleting a
> or running an unplanned update query from another program.
> That said, the best way to get your feet wet with postgresql IMO is
> pgadmin3 GUI.
> pgadmin3 has the inspired feature of displaying the SQL commands for
> everything it does through the GUI. You'll learn very quickly what
> commands are for adding a role, permissions to that role, and
> with dataset management.
> I highly recommend working with it to get comfortable with postgresql,
> to more closely examine your specific issues with LedgerSMB
> This SF.net email is sponsored by DB2 Express
> Download DB2 Express C - the FREE version of DB2 express and take
> control of your XML. No limits. Just data. Click to get it now.
> Ledger-smb-users mailing list
Computer King & CaN Mail - Sales Service Hosting Backup
NEW!!! Custom Service Packages
Secure IMAP Email - Automated Remote Backups - Photo Blogs - Online Accounting Packages