Tags » PostgreSQL » Page 2

Get schema of the database

To get the schema of your database. Follow below steps:

  1. Download db visualizer http://www.dbvis.com/ and install it in your system.
    For ubuntu system:
    Download dbvis package 
  2. 148 more words

Upsert and Before Insert/Update Trigger

Upsert feature in PostgreSQL drove me to shorten SQL statement in my user defined functions. But somehow I overlook PostgreSQL version 10 documentation explaining trigger behavior: 1,030 more words


What AWS service can help speed up slow Django view functions

I have a Django application with a Postgres DB that has kind of run away from my client as the database has millions of records. That being said there are some view functions that make several database queries, and because of that, it is glacier slow. 614 more words


Install PostgreSQL

1. yum install postgresql-server postgresql-contrib

2. su postgresql

3. postgresql-setup initdb

4. vi /var/lib/pgsql/data/pg_hba.conf

5. Find the lines that look like this near the end of the file and change them from ident to md5: host all all ident host all all ::1/128 ident… 31 more words


Calculating Tupper's Self-Referential Formula With SQL

A really geeky way to start a Monday morning is to be nerd-sniped by the cool Fermat’s Library twitter account…

Tupper's self-referential formula is a formula that visually represents itself when graphed at a specific location in the (x, y) plane.

375 more words

Dumping(backing) and restoring database [PostgreSQL, MongoDB, MySQL]

A database backup and recovery plan is creating backup copies of data. When error (internal exception within the DBMS, Application (or transaction) failures, damage to disk storage devices, file system failures, tape degradation or damage, and deleted data files… 901 more words

System Administration

February 2018 Meeting: Automatic For The People

When: 6-8pm Thursday February 15, 2018

Want automated high availability PostgreSQL *without* relying on someone
else’s cloud service? It’s possible today, and easier than you think; 183 more words

Meeting Announcements