Having run tt-rss on MySQL for a while (I was younger and foolisher) I’ve been thinking about migrating to PostgreSQL when I move tt-rss from Ubuntu 14.04 to 16.04.
I should add that tt-rss is running in a VM, and I’ll be taking an offline snapshot before the migration so I can easily revert back when I do break it, but it would be nice not to have to revert it too many times…
An OPML file is a list of feeds, however for sentimental reasons I want to preserve content from several sites that are no longer online, these would be empty if I just used an OPML export and import.
Is there a simple way to set all (rather than the 30 can be selected easily) items in a feed as Archived ?
The project will still work unless @fox has added some new tables (they’re hardcoded - yeah blame me) in the past two years. I’ll give a look at the schemas.
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.
Sorry for the heap space - I can’t know in advance how much you’ll need.
Now, to you rissue… ttrss_users is the first table that gets copied, it looks like the second user wasn’t copied. Would you check what is at the top of the output (being the first table). You can write me an email or open an issue on github if you don’t want to pollute this forum.
e: out of curiosity, did you ty logging in with your user after the tool completed? It did complete, even if it shows some errors during the execution.