Database Administration & Monitoring A response to: What makes a community? 16.11.2017 by Daniel Westermann A recent tweet of mine resulted in Martin Widlake to write a really great blog post about What makes a community. Please read it before you continue to read this. There was another response(…)
Database Administration & Monitoring Can I do it with PostgreSQL? – 18 – Instead of triggers on views 15.11.2017 by Daniel Westermann It has been quite a while since the last post in this series but today comes the next one. Being at a customer this morning this question popped up: Can we have instead of triggers on a view in PostgreSQL(…)
Database Administration & Monitoring Auto pre-warming in EDB Postgres Advanced Server 10 15.11.2017 by Daniel Westermann Some days ago EDB Postgres Advanced Server 10 was released and one feature which might be handy is auto pre-warming. What this does is to save all the buffers (or better a description of the buffers) which(…)
Database Administration & Monitoring Displaying the contents of a PostgreSQL data file with pg_filedump 08.11.2017 by Daniel Westermann Did you ever wonder what exactly is in a PostgreSQL data file? Usually you don't care, I agree. But there might be situations where knowing how you can do this might be a great help. Maybe your file is corrupted(…)
Database Administration & Monitoring Can I have the same table published and subscribed (bi-directional) in PostgreSQL 10 logical replication? 03.11.2017 by Daniel Westermann When you start using PostgreSQL 10 logical replication you might think it is a good idea to setup bi-directional replication so you end up with two or more masters that are all writable. I will not go into the details(…)
Database Administration & Monitoring Are large objects supported in PostgreSQL 10 logical replication? 02.11.2017 by Daniel Westermann Another interesting topic that popped up last week during pgconfeu: Are large objects supported with logical replication in PostgreSQL 10? The only truth is a test, isn't it? Lets go...
Database Administration & Monitoring Are temporary tables auto vacuumed in PostgreSQL? 31.10.2017 by Daniel Westermann While doing the EDB quiz at their booth last week at pgconfeu one of the questions was: Are temporary tables auto vacuumed? What do you think? My first thought was yes, but lets see. The first question(…)
Database Administration & Monitoring Changing the LOCALE in CentOS/RedHat 7 06.10.2017 by Daniel Westermann What I really don't like is this: Someone wants me to work on a Linux system for whatever purpose and then I get messages like this: postgres@pgbox:/home/postgres/ [pg960final] cat /proc/sysrq-trigger cat: /proc/sysrq-trigger: Permission non accordée or: postgres@pgbox:/home/postgres/ [pg960final] cat /proc/sysrq-trigger(…)
Database Administration & Monitoring And finally it is there…PostgreSQL 10 05.10.2017 by Daniel Westermann What are you waiting for?(…)
Database Administration & Monitoring udev rules for ASM devices on RHEL 7 05.10.2017 by Daniel Westermann Preparing the storage devices for use with ASM is one of the first tasks you should do. When you do not want to use ASMLib then udev is what you should use for this.