Pepaya Mentah dan Garam

Tidak semua orang suka pepaya, tetapi saya yakin kalau kebanyakan orang akan memilih pepaya matang daripada pepaya mentah. Tapi, pernahkah Anda memakan pepaya mentah, dan menikmatinya?
Read more →

[Python] Pyrseas Error: dict object has no attribute column

I was using Pyrseas package for database comparison between my clusters. In fact, I am using it for more complex cases and it’s been very helpful. Unfortunately, there is a bug that I encountered recently. The Problem Both dbtoyaml and yamltodb are needed for my cases and the command is mainly do as follow: dbtoyaml –host=localhost –port=5433 sai_database –output=sai_database.yaml After some processes are running, this throws an error below:
Read more →

Currently Reading

When: The Scientific Secrets of Perfect Timing by Daniel H. Pink
Read more →

Nyantri Itu…

Ya, saya pernah menjadi santri di beberapa (pondok) pesantren. Dan ini adalah secuil cerita bagaimana efek positif nyantri pada kehidupan saya saat ini.
Read more →

[Belanda] Bag 1: Ber-Islam

Kalau mendengar berita di televisi maupun media daring, menjadi muslim kadang terasa membuat diri ini khawatir. Tentu saja ini semua adalah paranoia saya semata. Karena nyatanya, pengalaman bermuslim di negeri Belanda ini tidak seperti yang saya khawatirkan.
Read more →

[PostgreSQL] Inactive Replication Slot: the Butterfly Effect

I have been using replication slot since its birth in PostgreSQL 9.4 version. This feature is very helpful in terms of keeping the WAL files on master server to make sure that its replica servers are in good state and (a)sync with it. But, something horrible will happen if you left them inactive.

In one of our database clusters, the design was simply like this:

PostgreSQL simple replication

Read more →

[PostgreSQL] Logical Replication in Postgres 10

Available in English and Indonesian versions.

Up until this moment, PostgreSQL version 9.x, the only way to have limited replication, as in tables and its data and not the whole database cluster, is to use dump and restore option or the trigger. And if you wanto to use the trigger option, the only tools with this capability are Bucardo and Skytool’s Londiste with their own good and bad side. You can easily set trigger-based replication up and the replicated data you have is mostly nearly realtime unless you forgot to run the daemon. On the other hand, dump and restore options doesn’t give you the ability to have near realtime replication but the limitation gives you more power over the trigger-based one. (Depending on how you look at it)

Read more →