PostgreSQL & recovery.conf
The coming version of PostgreSQL, 12, will loose the recovery.conf file. It will get some time to get used to!
written sometime in July 2019
|
PostgreSQL Administrator Account WITH NOLOGIN (recover your role)
Today I got an email from a friend of mine that locked out of his own database due to a little mistake.
written sometime in June 2019
|
Importing data from MSSQL is faster than I thought
A few months ago I set up a Foreign Data Wrapper against a Microsoft SQL Server to import historical data.
I’m quite impressive about how quick the bulk import is.
written sometime in June 2019
|
A recursive CTE to get information about partitions
I was wondering about writing a function that provides a quick status about partitioning. But wait, PostgreSQL has recursive CTEs!
written sometime in June 2019
|
Checking the sequences status on a single pass
It is quite simple to wrap a couple of queries in a function to have a glance at all the sequences and their cycling status.
written sometime in June 2019
|