Cleaning schema.rb
Public

Since [apartment](https://github.com/influitive/apartment) uses `schema.rb` as a source for new schemas, it is important to keep this file clean. Running mig...

Postgres - View all connections details
Public

Postgres server with limited connection pool can experience issues when all connections are occupied by some process. Here you'll learn how to get more details about them to mitigate this issue.

How to detect time-overlapping-records in Postgres + Rails
Public

```ruby Model .where("TSRANGE(?, ?, '()') && TSRANGE(starts_at, ends_at, '()')", starts_at, ends_at) .where.not(id: record_id) .exists? ``` Bot...

How to add polish dictionary to postgres
Public

PostgreSQL dictionary consists of 3 files: * lang.dict * lang.affix * lang.stop # Generating dictionary files 1. Download the most recent polish Isp...

How to restore DB from SQLC file
Public

`pg_restore -d db_name /path/to/sqlc/file.sqlc`

How to run PostgreSQL if 'postmaster.pid' already exists
Public

How to run PostgreSQL if it isn't starting because 'postmaster.pid' already exists