I tried to migrate PMF 2.8.8 from mySQL to PostgreSQL. I tried to use the backup/restore mechanism. This was successful in *some* topics, not in all:
Some errors on importing the backup made from the mySQL install stating problems with \", I fixed those by editing the sql file.
Errors inserting the data in faquserdata: error with last_modified being varchar(14) whereas the sql was showing up timestamps like '2014-03-02 14.23.34'. I fixed those by editing the sql file.
All contents was showing up then, but the line breaks not show as \r\n
Inserting a new faq resulted in not showing up, but linking an old faq into the category i was trying to insert the new faq. It may be a problem with the sequences in postgresql. When saving, the unique id changed from 1105 to i.e. 1004 and the new entries do not show up, even when searching for them
Are there any hints how to do a better job? How are the sequences handled in PMF backup/restore?