Talk:Migration to PostgreSQL

Thanks for a good how-to. Following it I was able to migrate my own wiki to Posgtres. For some reason the standard method with XML dump/restore did not work for me.

One little comment: I had to modify your  script so that it could operate with prefixed table names. I have changed this function a little:

Yet another thing I had to do after all the process was this: GRANT SELECT, UPDATE ON user_user_id_seq TO wikiuser;

otherwise new users could not sign-in.

-- Stanislav, Russia.


 * Hi Stanislav, thanks for your comments and improvements. Actually, I did write this How to as a private memo for myself. It really makes me happy to see that it has been helpful to some other admin. You are right, I didn't care for table prefixes since we didn't use them. However, you addition might be a help for other admins that migrate to PG. I'm not sure what's about the permissions for user_user_id_seq. Maybe I really did forget to add them to the scripts. It took me so many attempts until the migration finally succeeded that I might had become somewhat confused. -- Hansm 15:28, 11 January 2008 (UTC)