How to Find Postgres Log File and Postgres Data Directory from PSQL
If you want to find the location of your log file in Postgres, you'll need to hop into a Psql session..
psql dbname
Then it's as simple as running..
show data_directory ;
Which will output the data directory, in my case..
/Users/sea...
Written by Sean Behan on 05/25/2018
How to Import/Export a Database from One Heroku App to Another Heroku App
Heroku is awesome! Let's say we want to copy a production database to a staging database.
We can use the `pg:backups:restore` command to accomplish this. Here is an example. For the source database we are using the `production-app-name` and for stagi...
Written by Sean Behan on 03/07/2017
How to Enable UUIDs in Postgres
The first thing you'll need to do is enable the extension
create extension "uuid-ossp";
To test that it's working
select uuid_generate_v1();
For more info on which version of the algorithm you should use refer to the documentation.
...
Written by Sean Behan on 03/03/2017
How to Upgrade RVM on Mac OS X
I had an old version of rvm installed and wanted to upgrade. So old in fact that the resource for upgrading no longer existed.
rvm update
just returned a 301, redirect.
Luckily, the following worked
# checks out from repo
rvm update --head
# will re...
Written by Sean Behan on 06/17/2012