Databases
How to Move Data Between SQLite MySQL and PostgreSQL
Move data between SQLite, MySQL and PostgreSQL from the shell: dumps and their dialect problems, CSV as the neutral format, type mapping, pgloader and checks.
6 min read
Tag
postgresql
3 posts
Databases
PostgreSQL Error Role Does Not Exist and How to Prevent It
Fix PostgreSQL role does not exist: createuser, psql defaults to your OS user, the missing database error, quoting case-sensitive names and idempotent setup.
6 min read
Databases
PostgreSQL Error Peer Authentication Failed With Every Cause
Fix PostgreSQL peer authentication failed for user: pg_hba.conf rules, Unix socket versus TCP, matching OS and database user names, and a safe change.
6 min read