I noticed a few days ago my FreedomBox was inaccessible. This morning I power reset it and did updates through
aptitude and once complete purged all obsolete packages. Apparently
postgresql-11 was among the packages purged. Fortunately, I think the database remains in
One clue was that
tt-rss complained that it could not connect to the server on port 5432 and
netstat -tunlp showed
postgres on 5433. I corrected that and restarted the postgres server and now I get an error that password authentication failed for user “ttrss”.
Unless I manually find and install the
postgresql-11 packages, I need to figure out how to migrate the database to the new server. Is there a simple tool that will do this? If so, a HOWTO will be greatly appreciated.