Knowledge base for teams
How to restore DB from SQLC filePublic
`pg_restore -d db_name /path/to/sqlc/file.sqlc`
@aleksanderHow to add polish dictionary to postgresPublic
PostgreSQL dictionary consists of 3 files: * lang.dict * lang.affix * lang.stop # Generating dictionary files 1. Download the most recent polish Isp...
Cleaning schema.rbPublic
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...
How to run PostgreSQL if 'postmaster.pid' already existsPublic
How to run PostgreSQL if it isn't starting because 'postmaster.pid' already exists
How to detect time-overlapping-records in Postgres + RailsPublic
```ruby Model .where("TSRANGE(?, ?, '()') && TSRANGE(starts_at, ends_at, '()')", starts_at, ends_at) .where.not(id: record_id) .exists? ``` Bot...
Postgres - View all connections detailsPublic
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.
