postgresql

How to recover or reset a lost Postgresql password

December 20, 2012 November 21, 2019 / Archived (old posts) / centos, postgresql

This has been doing my head in all day – so hopefully it will save some of you the trouble. I’m on a CentOS box. First thing you want to do is check which version of postgres you have, with:

How to create a user, database, and assign the user to the db in PostgreSQL

August 10, 2012 November 21, 2019 / Archived (old posts) / postgresql, rails

Here’s a quick reference on how to create a user, a database and grant the user all privileges to the database (on Mac OS X). If you haven’t yet installed PostgreSQL, look here: How to install PostgreSQL on Mac OS X

How to install PostgreSQL on Mac OS X

August 10, 2012 November 21, 2019 / Archived (old posts) / mac, OS X, postgresql, rails, ruby

There are a number of ways to install Postgres on Mac, here’s three. While these instructions are for a clean install of Lion, they may work for Mountain Lion.