Tags » Postgresql

PostgreSQL + rake db:migrate

ActiveRecord::NoDatabaseError: FATAL: role “dev” does not exist

If you receive the error above when trying to run your Rails migrations against a newly installed instance of PostgreSQL on an Ubuntu development box, all you need to do is a new role to Postgres with the name ‘dev’. 18 more words

Ruby On Rails

PostgreSQL basics

To login to prompt

#psql -h myhost -d mydb -U myuser -W

To create user

psql#CREATE USER anoop WITH password ‘tmppassword’;

To create database

 CREATE DATABASE db1 WITH OWNER anoop; 15 more words


PHP application in SAP Cloud Platform. With PostgreSQL, Redis and Cloud Foundry

Keeping on with my study of SAP’s cloud platform (SCP) and Cloud Foundry today I’m going to build a simple PHP application. This application serves a simple Bootstrap landing page. 1,639 more words


Golang: Database migration to manage your database schema by creating incremental SQL

In this post I write down my experience regarding  database migration configuration for Golang using Goose database migration.

Goose installation

$ go get -u github.com/pressly/goose/cmd/goose… 155 more words