Travis changed their default distribution from Ubuntu 14.04 (trusty) to 16.04 (precise). This might break your test setup for new...
When doing some meta-programming magic and you want to do something for all attributes of a class, you may...
If you have a PostgreSQL dump in the custom format you can can view the text format dump (plain SQL...
For searching in large database tables we usually use PostgreSQL's fulltext search capabilities. While this works reasonably well for...
When restoring a PostgreSQL dump using pg_restore, you usually add the --clean flag to remove any existing data from...
To remove all tables from a database (but keep the database itself), you have two options. Option 1: Drop the...
When projects run for many years, they require special regular maintenance to stay fresh. This kind of maintenance is usually...
Setting array columns When using PostgreSQL array columns, you can set an array attribute to a value with square brackets...
When you need to store structured data (like Ruby hashes) in a single database column with ActiveRecord, a simple way...
When you have a large PG database, you may want to find out which tables are consuming the most disk...
Don't sum up columns with + in a sql-query if NULL-Values can be present. MySQL and PostgreSQL cannot...
geordi delete_dumps [directory] Recursively search for files ending in *.dump and offer to delete those. When no...
Your default postgres user is named like your linux user. That default user has limited access privileges, which can cause...
This is an extension to PostgreSQL vs MySQL: How to UPDATE using a JOIN. UPDATE employees SET department_name = departments.name...
This is a small example on how you can check if your Postgres index can be used by a specific...
PostgreSQL's Common Table Expressions (CTEs) can be used to extract sub-queries from bulky SQL statements into a temporary...
PostgreSQL supports the SQL OVERLAPS operator. You can use it to test if two date ranges overlap: => SELECT ('2001-02...
An end-to-end test (E2E test) is a script that remote-controls a web browser with tools like Selenium...
If another session is accessing your database you are trying to reset or drop you might have seen the following...
This card compares patterns to store trees in a relation database like MySQL or PostgreSQL. Implementation examples are for the...
This card is just about creating simple PostgreSQL dumps. This is no instruction for a backup strategy nor a guide...
Hint This applies only to distributions based on Debian. Requirement You need to setup the PostgreSQL Apt Repository first.
on the bash (issued as postgres user) Start/Stop/Restart PostgreSQL pg_ctl -D $configdir start|stop|restart Start/Stop/Restart the corresponding PostgreSQL...