How to provide a password for PostgreSQL’s createdb non-interactively?

How to provide a password for PostgreSQL’s createdb non-interactively?

I have a task in phing where before tests I drop the database if exists and create it. This is run on Jenkins.
I want to do it with createdb like this:

The thing is that the createdb is asking me … Read the rest “How to provide a password for PostgreSQL’s createdb non-interactively?”

How to migrate complex Rails database to use UUID primary keys Postgresql

How to migrate complex Rails database to use UUID primary keys Postgresql

I have a database I would like to convert to use UUID’s as the primary key in postgresql.
I have roughly 30 tables with deep multi-level associations. Is there an ‘easy’ way to convert all current ID’s to … Read the rest “How to migrate complex Rails database to use UUID primary keys Postgresql”