Selamat Tahun Baru 2021! Semoga di tahun 2021 ini Coronavirus(Covid-19) dapat segera berakhir, semoga apa yang direncanakan dapat terwujud, dan ke depannya menjadi lebih baik lagi.
Aamiin.
Image Credit: Eugine Cholo
Hi, i'm Darmanex, a Sysadmin/DevOps, Infosec, and yeah i love coffee ☕. I blog about all things, research, DIY things, life story, etc. Read more →
# find / -iname kdevtmpfsi -exec rm -fv {} \;
# find / -iname kinsing -exec rm -fv {} \;
# touch /tmp/kdevtmpfsi && touch /var/tmp/kinsing
# chmod 000 /tmp/kdevtmpfsi && chmod 000 /var/tmp/kinsing
# chattr +i /tmp/kdevtmpfsi && chattr +i /var/tmp/kinsing
# apt-get remove --purge postgresql
After the step above, please reboot the server, and then install again the postgresql./Users/darm/.pyenv/shims/python3: line 21: /usr/local/Cellar/pyenv/1.2.18/libexec/pyenv: No such file or directory
To solve the issue, you have to rehash it, like below.
pyenv rehash
# select * from table_name;
ERROR: could not connect to server "server_master"
DETAIL: FATAL: password authentication failed for user "postgres"
In this situation we have to check one by one what's the password of user postgres, and we found the password is different. To check current password of user mappings, you can type \deu+ on psql console.
In this case we will change the password of user mappings. To change the password, assuming you are on the right database, and run this on psql console:
# ALTER USER MAPPING FOR postgres SERVER server_master OPTIONS (SET password 'YOUR_NEW_PASSWORD');
Then check it again the user mappings with \deu+.
Then try it once again.
Cool, we have no error found anymore!
Reference: https://www.postgresql.org/docs/10/sql-alterusermapping.html