How to migrate from MySQL to PostgreSQL?

If you run tt-rss on an officially unsupported platform (shared hosting, Windows, etc.) post here
kulak
Bear Rating Trainee
Bear Rating Trainee
Posts: 13
Joined: 05 Jan 2016, 13:50

How to migrate from MySQL to PostgreSQL?

Postby kulak » 12 Dec 2016, 23:42

I am running 16.1 on FreeBSD 10.2 with MySQL backend.

I am getting ready to migrate the system to Raspberry Pi host with Postgre database installed. I assume I will update to the latest TTRSS.

I prefer not to loose my feeds and especially starred articles.

Is there a database migration process you can recommend for me?

Thank you

chalbersma
Bear Rating Trainee
Bear Rating Trainee
Posts: 1
Joined: 02 Dec 2016, 19:36

Re: How to migrate from MySQL to PostgreSQL?

Postby chalbersma » 13 Dec 2016, 01:35

While i've never felt the need to move from MySQL, Postgres' docs have a decent page on migration. Additionally I've had good luck using Symmetric-DS going from Oracle DB to MariaDB. I believe it supports PostgreSQL so you may want to give it a look.

JustAMacUser
Bear Rating Overlord
Bear Rating Overlord
Posts: 373
Joined: 20 Aug 2013, 23:13

Re: How to migrate from MySQL to PostgreSQL?

Postby JustAMacUser » 13 Dec 2016, 03:41

Fox is not going to appreciate that you didn't bother to search:

Proper way to migrate from MySQL to PostgreSQL

I'm going to add that migrating is, in general, a bad idea. You should export/import your feeds using the built-in feature for this. There's also a plugin bundled with TT-RSS that will handle this for your starred articles.

AngryChris
Bear Rating Master
Bear Rating Master
Posts: 135
Joined: 08 Apr 2013, 02:42

Re: How to migrate from MySQL to PostgreSQL?

Postby AngryChris » 14 Dec 2016, 05:32

kulak wrote:I am running 16.1 on FreeBSD 10.2 with MySQL backend.

I am getting ready to migrate the system to Raspberry Pi host with Postgre database installed. I assume I will update to the latest TTRSS.

I prefer not to loose my feeds and especially starred articles.

Is there a database migration process you can recommend for me?

Thank you

PostgreSQL's name

Hint: There is no such thing as "Postgre" -- I'm only letting you know so you don't sound like an idiot when you call it "Postgre" to your friends, let alone your employer.

kulak
Bear Rating Trainee
Bear Rating Trainee
Posts: 13
Joined: 05 Jan 2016, 13:50

Re: How to migrate from MySQL to PostgreSQL?

Postby kulak » 18 Jan 2017, 10:30

I decided against using migration tool https://github.com/hrk/tt-rss-mysql2pgs ... its/master and import/export plug-in reference is dead
https://github.com/lotrfan/Tiny-Tiny-RS ... export_all

hrk
Bear Rating Disaster
Bear Rating Disaster
Posts: 75
Joined: 24 Apr 2013, 12:39

Re: How to migrate from MySQL to PostgreSQL?

Postby hrk » 20 Jan 2017, 22:21

kulak wrote:I decided against using migration tool https://github.com/hrk/tt-rss-mysql2pgs ... its/master


Why?

(I'm the author)

kulak
Bear Rating Trainee
Bear Rating Trainee
Posts: 13
Joined: 05 Jan 2016, 13:50

Re: How to migrate from MySQL to PostgreSQL?

Postby kulak » 21 Jan 2017, 21:58

Correct or not: Java to install on a system, for some reason I thought the migration project was last updated several years ago, so I was not sure it was up to date. Risk of having problems that cost me additional time in the end and doubting if migration created problems or if it has always been there.

hrk
Bear Rating Disaster
Bear Rating Disaster
Posts: 75
Joined: 24 Apr 2013, 12:39

Re: How to migrate from MySQL to PostgreSQL?

Postby hrk » 22 Jan 2017, 16:25

Yes, you need Java installed on your system.

The migration project hasn't been updated in years because there has been no need (as the database schema didn't change in a way that required changes to the tool).

ldidry
Bear Rating Trainee
Bear Rating Trainee
Posts: 27
Joined: 11 Jun 2013, 20:43

Re: How to migrate from MySQL to PostgreSQL?

Postby ldidry » 22 Jan 2017, 18:26

I didn't test it for a ttrss migration but used it for a Drupal MySQL to PostgreSQL migration but you may try pgloader (http://pgloader.io/).


Return to “Unsupported platforms”

Who is online

Users browsing this forum: No registered users and 2 guests