[PostgreSQL] psql dan Scripting Query

Belajar atau bermain database PostgreSQL dengan aplikasi dengan tampilan memang mudah, tapi menggunakan tool bawaan dari Postgres resmi jauh lebih powerful. Namanya, psql.
Read more →

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 →