Archive for April 1st, 2008

PostgreSQL tuning

Tuesday, April 1st, 2008

Useful links for postgres tuning: Powerpostgresql Devshed postgres tips Varlena tips

MySQL > Postgres Migration woes

Tuesday, April 1st, 2008

After migrating to postgres with the insert records from a mysqldump, everything seemed fine. But when making a new user there is an error about the primary key: because postgres doesn't have autoincrement, it has problems with the primary key constraint. So apparently the dbfamily variable is not set correctly. ...