Blog: Vasilis Ventirozos

209 blogs updated: 27 min. ago
Reusing an old master (as slave) after a switchover
Todays blogpost is old news but it's not very well known and it has to do with how to add an old master after a slave has been promoted. Fuj...
19-05-2017 16:25:57 Vasilis Ventirozos PostgreSQL
PostgreSQL statistics as data
Postgres provides a lot of information when it comes to statistics. Only problem is that all the statistics are frozen in time the moment yo...
09-05-2017 18:20:58 Vasilis Ventirozos PostgreSQL
PostgreSQL upgrades - Methodology
Yesterday, i came across a conversation in postgres slack channel, someone was interested in upgrading his database and i realised that ther...
25-01-2017 18:59:25 Vasilis Ventirozos PostgreSQL
Traveling in time(lines) with pg_rewind
At 9.5 pg_rewind was introduced, with this feature it was possible to make a server that is no longer master to follow a promoted standby th...
20-12-2016 20:58:35 Vasilis Ventirozos PostgreSQL
Adding columns with default value fast
I recently came across a discussion in #postgresql channel about how to add a new column that will represent record insert timestamps to a t...
14-12-2016 16:57:33 Vasilis Ventirozos PostgreSQL
Custom Postgres installation with Docker
Lately, i wanted to make a new test / lab environment that would be dispensable, fast to deploy and easily customisable. VM's are all nice f...
06-12-2016 18:41:43 Vasilis Ventirozos PostgreSQL
Repairing clog corruptions
Yesterday, i got a page from a client about a possible corruption issue to one of his clients, so i decided to share how i dealt with it. Be...
19-05-2016 12:07:48 Vasilis Ventirozos PostgreSQL
Backups Restores and PITR nowdays
Its been almost a year since 9.4 was released, it included many nice features, but the one that changed my day to day administration was rep...
24-11-2015 10:59:00 Vasilis Ventirozos PostgreSQL
PostgreSQL 9.4 streaming replication over SSL with Replication Slots
I never really liked the concept of keeping wal files in case the replica goes down proactively, setting wal_keep_segments was always a tric...
30-10-2015 09:21:00 Vasilis Ventirozos PostgreSQL

© Jiri Pinkas | this project on GitHub | related: SQL školení | Top Java Blogs | monitored using: sitemonitoring

Top SQL Blogs is a blog aggregator (with English-written blogs only) focused on MySQL, PostgreSQL, MS-SQL and Oracle databases.