Aston J


Posts Tagged ‘postgresql’

How to recover or reset a lost Postgresql password

Posted on: December 20th, 2012 by AstonJ 1 Comment

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:
(more…)

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

Posted on: August 10th, 2012 by AstonJ No Comments

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
(more…)

How to install PostgreSQL on Mac OS X

Posted on: August 10th, 2012 by AstonJ 5 Comments

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.
(more…)