I did a git pull to get the production instance up to date
I spun up a new VM for postgresql
made sure I had access to MySQL from the new VM to the existing VM
did base setup of web server and git clone of tt-rs (so both production and new are at the same level)
ran through the install wizard and confirmed I could login as admin
edited the config.properties to match the production and new databases
after hitting java heap space errors, finally got it to run, but not completed
java -Xmx4096m -jar tt-rss-mysql2pgsql.jar
at the bottom of the output
}";}') was aborted. Call getNextException to see the cause.
CAUSE: ERROR: insert or update on table "ttrss_plugin_storage" violates foreign key constraint "ttrss_plugin_storage_owner_uid_fkey"
Detail: Key (owner_uid)=(2) is not present in table "ttrss_users".
[ttrss_plugin_storage] 13 ms.
[ttrss_plugin_storage] setting sequence to 5
INSERT INTO ttrss_error_log(id, owner_uid, errno, errstr, filename, lineno, context, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
[ttrss_error_log] 12 ms.