I have a Wiki running 'MediaWiki' software that was using MySQL as it's back end database. We want to migrate the Wiki to new hardware / server but more important, we wont to stop using MySQL. I found that MediaWiki has a 'mysql2postgres.pl' tool that converts the database from MySQL for PostgreSQL use:
So now I have this file and I want to get the data over to my true production PostgreSQL server (8.4.7) but don't know how to approach this. Do I need to create a new wiki database using template0 or template1 ot just normally create a database and associated role?
postgres=# CREATE ROLE wiki LOGIN ENCRYPTED PASSWORD 'letmein' NOSUPERUSER NOCREATEDB NOCREATEROLE;
postgres=# CREATE DATABASE mediawiki OWNER wiki;