So I decided also on the update to move to postgresql. I found http://blog.koehn.com/technology/2014/08/21/diaspora-mariadb-to-postgres.html to be my best place to start, however I had lots of crap in my DB to also solve. First I have open_aspects and password_salt in my users table that should have dropped, so I did. Second, I had tons of created_at and updated_at that were NULL and that wont work to move to postgres so I populated them with now() as the date, hope that does not wonk things up a ton. From the example post above I just needed to add the 3 new tables around chat and I was ready to run. The pod

close

So I decided also on the update to move to postgresql. I found http://blog.koehn.com/technology/2014/08/21/diaspora-mariadb-to-postgres.html to be my best place to start, however I had lots of crap in my DB to also solve. First I have open_aspects and password_salt in my users table that should have dropped, so I did. Second, I had tons of created_at and updated_at that were NULL and that wont work to move to postgres so I populated them with now() as the date, hope that does not wonk things up a ton. From the example post above I just needed to add the 3 new tables around chat and I was ready to run. The pod

Read more

Posted in Uncategorized

Well its been a year again since my last blog post.. I moved to the east coast from the west coast, getting settled in. We have a new dog and 2 new cats here at the house. Not been as active on the pod as I would like, I think the slowness bugs me, but the new server and the move to postgresql makes a HUGE difference. Happy 2016! On the pod front, I got a new dedicated server to move the pod to at the same host. I have it set up, but still working on migrating the mysql db to postgresql first. Specs on new server are: Dual Intel

close

Well its been a year again since my last blog post.. I moved to the east coast from the west coast, getting settled in. We have a new dog and 2 new cats here at the house. Not been as active on the pod as I would like, I think the slowness bugs me, but the new server and the move to postgresql makes a HUGE difference. Happy 2016! On the pod front, I got a new dedicated server to move the pod to at the same host. I have it set up, but still working on migrating the mysql db to postgresql first. Specs on new server are: Dual Intel

Read more

Posted in diaspora