BTW, there's a CentOS/RH-based SysV init script here: https://github.com/ledgersmb/LedgerSMB/tree/master/doc/conf/sysvinit hopefully that helps to (quickly) build one for LFS. I'd be happy to include such an script in our repository for use by others or even just for reference.

The LFS boot scripts are much more "bare bones" but this will be an excellent starting point, thanks!

The "entry_id" column of table "acc_trans" is just sequential numbers, as far as I can tell.  Maybe I misunderstand.

That's interesting. If there are no rows where "amount" is null in acc_trans, then why does this query fail:

select trans_id, chart_id, transdate from acc_trans WHERE amount IS NULL

This may be simpler than it looks.  Trying to use it directly from psql, I'm running into an access problem.