Category Archives: From The Internet

PostgreSQL set sequences to max value

When you import data into a PostgreSQL database, the sequences are not updated automatically. In the PostgreSQL wiki there is a guide showing you how to update the sequences to the max value of the id column by generating a query for each table.

Here is the full guide: Fixing Sequences

Advertisements

Allow remote access to mysql using xampp

If you use XAMPP for your MySQL and you want to use another program to manage your database instead of phpMyAdmin, for example MySQL Workbench, you will need to allow remote access to MySQL.

Here is how from an answer in serverfault.com: How do I allow remote access to mysql using xampp?