DevOps, Technology

How to Set up PhpPgAdmin for PostgreSQL?

PostgreSQL is a powerful, open source object-relational database system (ORDBMS). The version 8.0 and above also comes with the native Windows compatibility. Compared to other RDBMSs, PostgreSQL differs itself with its object-oriented and/or relational database functionality, such as the complete support for reliable transactions,...

by Anup Yadav
Tag: postgresql
23-Feb-2017

AWS, DevOps

Migrate PostgreSQL on Linux server to AWS PostgreSQL RDS using Londiste (Skytools 2)

PostgreSQL is another SQL. It is the second most popular Structured Query Language after MySQL. The steps discussed in the blog can be used for any kind of migration of PostgreSQL. From on-premise to cloud or on-premise to on-premise or cloud to on-premise. Use-case I had to migrate my PostgreSQL running on an EC2 server to RDS...

by Ranvijay Jamwal
Tag: postgresql
12-Oct-2015

Automation Testing

Connect to PostgreSQL using JavaScript

One of the best practices of Automation testing is to leave the system from the state where you started your test from. While doing functional testing for an angularjs application using Protractor and Cucumber (BDD framework), there was a need to clean up whatever data was being generated in the Data setup (generally the Given) of the...

by Anuj Verma
Tag: postgresql
20-May-2015

Grails

PostgreSQL with Grails

Currently in my Grails project I am using PostgreSQL database so I thought to share my knowledge with everyone. I am using it on Linux operating system. I am mentioning all the steps that I followed to integrate PostgreSQL with Grails . Step 1: Install PostgreSQL on your system To install postgreSql [java] sudo apt-get install...

by Gunpreet
Tag: postgresql
05-Sep-2012