Tags » Postgresql

Connecting to Remote POSTGRESQL Using PgAdmin

Here is how I connect to the PostgreSQL database on a Digital Ocean droplet using pgAdmin III.


Configuring Master-Slave Replication With PostgreSQL

Having configured PostgreSQL 9.3 master/slave replication from bits and pieces of documentation on the Internet, I feel like a post is in order documenting my experience for others. 897 more words



The past couple of days I spent some time getting my app running with Hibernate. Unfortunately I was quite low on time, so it took me longer than I had anticipated. 504 more words


Maven GWT Mojo, GWT, Hibernate and PostgreSQL

Currently I am working on a side GWT side project. My interest in GWT initially started during my days at college. I really find it to be an awesome way to create client-heavy internet applications (RIAs, Rich Internet Applications). 729 more words



I’ve been using MySQL for quite some time now. Since 2015 just began, I decided it was time to mix things up a little bit and to use… 476 more words


Vagrant, PostgreSQL and pgAdmin

Here’s how to use pgAdmin to inspect a database on a Vagrant virtual machine. Vagrant already has SSH setup so the easiest and most secure way to connect to that database is using pgAdmin’s SSH Tunnel feature. 196 more words


Know the size of a postgresql schema

Sometimes we want to know the current size of a certain schema in our Database. For  that create the following function.

CREATE OR REPLACE FUNCTION pg_schema_getsize(text) returns bigint AS $$ 33 more words