PostgreSQL Support for BuildBuddy

By popular demand, we are introducing support for a PostgreSQL database backend for BuildBuddy! You can now use PostgreSQL as a drop-in replacement for MySQL or SQLite just by specifying a PostgreSQL endpoint to your BuildBuddy instance.

Try it out!

# After following steps appropriate to your OS/distribution to install PostgreSQL:

# Create a PostgreSQL user corresponding to the current user if one does not already exist
sudo su postgres -c "createuser $USER --createdb --pwprompt"

# Create a PostgreSQL database called "buildbuddy_test"
createdb buildbuddy_test

# Replace "$PGPASSWORD" with the PostgreSQL password you created for your user
bb run //enterprise/server -- --database.data_source="postgresql://$USER:$PGPASSWORD@localhost/buildbuddy_test?sslmode=disable"

The PostgreSQL connection may also be specified via database.advanced_data_source, just like our other database backends, and as always these flags can instead be specified in your BuildBuddy YAML config as opposed to on the command line. Remember that when you switch out database backends, you're starting with a fresh BuildBuddy instance, so you'll need to create users and change your API keys before you can build anything against it if you're using auth.

Questions? Comments? Other things you'd like to see in BuildBuddy? You can find us on Slack or contact us at hello@buildbuddy.io; we'd love to hear from you!