Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Not supported, instead please use database dump and restore facilities (e.g pg_dump)

Not supported, instead please use database dump and restore facilities (e.g pg_dump)

However, Django has commands dumpdata and loaddata - these should work across different database backends.

If you are looking to convert a large MySQL database to PostgresQL - have a look at available tools: https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Scripts.2C_programs

I've done this before and I think I've had success with this one (not 100% sure though): https://github.com/philipsoutham/py-mysql2pgsql

Not supported, instead please use database dump and restore facilities (e.g pg_dump)

However, Django has commands dumpdata and loaddata - these should work across different database backends.

If you are looking to convert a large MySQL database to PostgresQL - have a look at available tools: https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL#Scripts.2C_programs

I've done Also, please have a look at this before and I think I've had success with this one (not 100% sure though): https://github.com/philipsoutham/py-mysql2pgsqldocumentation page http://askbot.org/doc/mysql-to-postgres.html