On 01/12/2011 10:33 PM, Stuart Luppescu wrote:
Hello all, I just discovered that my "automatic" backups haven't been
being done since last September. *panic*. When I tried to do System ->
Backup -> Backup to file I get these error messages:
DBD::Pg::db selectrow_array failed: ERROR: relation "paymentid" does not exist
DBD::Pg::db selectrow_array failed: ERROR: relation "tempid" does not exist
DBD::Pg::db selectrow_array failed: ERROR: relation "tempid" does not exist
DBD::Pg::st execute failed: ERROR: relation "defau" does not exist
Error!
SELECT * FROM defau
ERROR: relation "defau" does not exist
I would love to be able to fix this, but I have no idea where to even
start (my knowledge of SQL is minimal in the extreme). Can anyone give
me some help? Thanks very much.
I'm running sql-ledger 2.6.27 on Gentoo Linux.
Not sure what is causing the problem (There is no table named 'defau' in
any SL version)
As a emergency measure you can always take backup directly using pg_dump
with something like this on your terminal.
pg_dump -U postgres your-data-set > your-data-set.sql
Regards
Armaghan
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
