Learn the main steps to migrate a MySQL database to PostgreSQL, from preparation to optimization. Find out the best tools and tips for a smooth transition.

This is likely because when I first learned it was with command-line tools, but even so, I think command-line database tools often are the best way to interact with a database manually. Two of the ...

This script is used to convert a Bacula Database from MySQL to PostgreSQL. It was tested using MySQL 5.6 and 5.7 to a PostgreSQL 9.4 and 9.6 and Bacula 9.0.8 and Bacula 9.2.2 This migration script was ...

This script was designed for our specific database and column requirements -\nnotably, it doubles the lengths of VARCHARs due to a unicode size problem we\nhad, places indexes on all foreign keys, and ...

Using the new Alter System Set function, administrators can now modify the PostgreSQL configuration file directly from the SQL command line.

Looking to use an open source general-purpose database? This extensive comparison of MySQL vs. PostgreSQL explores the strengths and weaknesses of each.