Search found 75 matches

by hrk
14 Jun 2013, 21:30
Forum: Support
Topic: Proper way to migrate from MySQL to PostgreSQL
Replies: 60
Views: 28807

Re: Proper way to migrate from MySQL to PostgreSQL

Well, my tool is more automated. :) Just give it the connection URLs, username and password and run it. It will return some errors when trying to copy the admin user and ttrss-forum feeds, which are created in the schema script, but they can be easily ignored. Everything else is copied. You need to ...
by hrk
10 Jun 2013, 01:19
Forum: Support
Topic: Proper way to migrate from MySQL to PostgreSQL
Replies: 60
Views: 28807

Re: Proper way to migrate from MySQL to PostgreSQL

PGSQL's size is a very rough "du -hs" on the tablespace directory. MySQL's size was calculated with:

Code: Select all

SELECT table_schema "Data Base Name", sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB"
FROM information_schema.TABLES GROUP BY table_schema ;
by hrk
08 Jun 2013, 16:59
Forum: Support
Topic: Proper way to migrate from MySQL to PostgreSQL
Replies: 60
Views: 28807

Re: Proper way to migrate from MySQL to PostgreSQL

Okay, today I decided to give a try again to my migration tool, to understand what was wrong. As it happened, it was a (conceptual) mistake on my part: since I am "copying" data from the tables, I was using the very same keys in the INSERT statement, but since the datatype was declared as ...
by hrk
29 May 2013, 17:00
Forum: Support
Topic: Proper way to migrate from MySQL to PostgreSQL
Replies: 60
Views: 28807

Re: Proper way to migrate from MySQL to PostgreSQL

If you read it carefully, it's the same error I got with my own script. :( We're back at square 1 [except for the migration of user settings which works really fine].
by hrk
26 May 2013, 22:44
Forum: Support
Topic: Proper way to migrate from MySQL to PostgreSQL
Replies: 60
Views: 28807

Re: Proper way to migrate from MySQL to PostgreSQL

I'd rather preserve everything, but I understand that it is not supported and thus easily cause for the "screwing up". I tried your approach, but it didn't work well enough. Some feeds "lost" their category, and categories order wasn't preserved. Is this to be considered a bug or...
by hrk
26 May 2013, 22:21
Forum: Support
Topic: Proper way to migrate from MySQL to PostgreSQL
Replies: 60
Views: 28807

Re: Proper way to migrate from MySQL to PostgreSQL

Knowing you, it means I did a stupid thing, or asked a stupid question. Or both, mind you. So... is there a simpler way to move data from MySQL to PostgreSQL? In another thread, somebody used a ruby gem, but from what I understood, it converted the existing mysql schema to the postgresql one. I want...
by hrk
26 May 2013, 19:43
Forum: Support
Topic: Proper way to migrate from MySQL to PostgreSQL
Replies: 60
Views: 28807

Proper way to migrate from MySQL to PostgreSQL

e: ==================== The tool is here https://github.com/hrk/tt-rss-mysql2pgsql Download the contents of the dist directory, edit config.properties w/ the right values, launch the jar. Three (or five) errors you can ignore, and then you're done. More docs at the link. ==================== After h...
by hrk
17 May 2013, 11:10
Forum: Comedy bistro
Topic: daemon user needs shell?
Replies: 55
Views: 21531

Re: daemon user needs shell?

really? with a simple question? Seems I need to adjust my sense of humor, to ask less funny questions :D Well, it wasn't the question per se . There are no stupid questions, at most there are noobie questions. Point is, after asking a [legit] newbie question you reinforced your attitude w/ 20 years...
by hrk
16 May 2013, 15:59
Forum: Comedy bistro
Topic: daemon user needs shell?
Replies: 55
Views: 21531

Re: daemon user needs shell?

Really, I don't pity him. I pity the people he bosses around. I'm pretty sure everyday goes like this: Boss: "THIS IS NOT PROFESSIONAL AS IT LACKS DOCS! IT WON'T ENTER MY SERVERS!" Underling: "But the docs were in the same email :(" or Underling: "If the binary isn't in the ...
by hrk
06 May 2013, 21:16
Forum: Feature requests
Topic: [FIXED] Stop load operation on (user) click on feed
Replies: 2
Views: 1082

[FIXED] Stop load operation on (user) click on feed

I hope I will be able to explain my problem/desire. This applies when using "Adaptive" view and hidden categories w/ no unread articles. Scenario: - Open tt-rss and select feed "A" from the left. - Meanwhile the "spinning"/"waiting" animation is in progress, o...
by hrk
04 May 2013, 12:14
Forum: Support
Topic: MySQL Caching
Replies: 12
Views: 4131

Re: MySQL Caching

fox wrote:Don't update feeds or access tt-rss in the browser, that would definitely solve the I/O usage.


Image

Bonus points for the physical exercise?
by hrk
28 Apr 2013, 12:07
Forum: Themes and plugins
Topic: Custom font
Replies: 2
Views: 1844

Re: Custom font

You can leave the default "sans-serif" on and then change how your browser handles sans-serif, i.e., telling it to use Open Sans. (You'll need to have the font installed on your computer, though).
by hrk
28 Apr 2013, 11:52
Forum: Support
Topic: Article Time ahead 1 Hour
Replies: 24
Views: 8389

Re: Article Time ahead 1 Hour

Quick & dirty (& not what you really asked for) fix: edit include/functions.php and change line 149 adding a " %Z" inside the format string. That'll show the timezone (UTC) in the logs, which will at least help you remember it's not localtime ;)
by hrk
24 Apr 2013, 12:41
Forum: Support
Topic: (Another) Time zone issue
Replies: 2
Views: 988

Re: (Another) Time zone issue

I haven't checked the source code, but I guess it mey be that the date is printed through a php function that prints in UTC, as it happens with the logs generated by the update_daemon2.php.

Go to advanced search