A database replica is able to provide another layer of protection in case of the main database server going down.
Postgres has this capability out of the box.
In this case the requirement was to create a replica on a separate server. (It’s also possible to create it on the same server where Postgres is running).
The replica maintains an exact copy of the main database (called Primary) on a real-time basis.
Continue readingAlthough this is not recommended, there might be scenarios where there are no other options.
An example is an analysis software which doesn’t give the capability to connect via SSH. I came across this scenario when someone wanted to use QLik. Although this has a lot of capabilities, but when something like this is required, I’d rather use the open source and free Metabase.
Continue reading
Recently, I had to build fossil from source on Ubuntu because I needed to make a change to the source code.
It required a number of dependencies which is expected to be installed.
They are –
gcc (obviously!)
zlib1g and zlib1g-dev
tcl-dev
tk
libssl
libssl-dev
To grant access to users for only viewing a database (i.e. no INESRTs or CREATE or UPDATE access) there are certain conditions.
First, access should be only allowed through ssh.
Second, the ssh user should not be able to get into a shell directly.
And finally, the database should restrict access to that particular user with relevant permissions.
Continue reading
In the past, on my server I’ve installed Fossil, Syncthing, Bitwarden, Inlets. All these require some form of Process Management. These programs / processes / services need to be always running, so they are restarted in case they get terminated. Also, on a system restart these need to start up automatically.
I’ve mostly used Systemd or Supervisor to all these things.
However, I recently came across PM2 and I was really blown out of my mind as to how simple it was to set it up.
Continue reading
I have been using LastPass for password management since like forever.
I became a paid customer in 2014. It was initially $1/month. Then it got hiked to $2/month and currently it stands at $3/month. That’s $36/year which was working out too much for me.
Furthermore, the free option is limited to a single type of device. Since I wanted to use it across desktops and mobiles, there was no option except for the $3/month plan.
I had been looking at bitwarden for quite some time now but read that it’s too resource heavy. I then came to know of biwarden_rs which is a rewrite of bitwarden in Rust and compatible with upstream Bitwarden clients. I had then forgotten about this for some time until I head the news of it being renamed to vaultwarden via a Reddit thread.
Continue reading
I got this weird error while deploying an SSL certificate from GoDaddy
nginx: [emerg] SSL_CTX_use_PrivateKey_file failed (SSL: error:0909006C:PEM routines:get_name:no start line:Expecting: ANY PRIVATE KEY error:140B0009:SSL routines:SSL_CTX_use_PrivateKey_file:PEM lib)Continue reading
As mentioned in the previous post, if you need to run cron jobs in linux, knowing how to debug them via mail is really important.
By the way, mail is the older program, the link above is to the man page of mailx which is the newer program created relatively recently, in 1986!
Navigating through messages in the mailbox is quite a challenge as I found.
So I decided to create a list of the commands which I used most frequently and found useful.
Continue readingSo, we set up a project on a new Digital Ocean droplet and the cron jobs started failing.
Not just that, the log file that we had set up to track the cron was showing up empty!
After a lot of head scratching, I had a look at /var/log/syslog
Starting up another computer on a network itself is such a fascinating idea! For me, it literally feels like magic!
There are so many things involved. The computer which needs to be started (or woken up) has to have the capability, both at the hardware and the software level.
Also the computer doing the waking needs to send a magic packet!
When I initially heard this, I honestly thought this was a joke of some kind. A magic packet? Really?
Continue readingCopyright © 2025 the möbius trip
Theme by Anders Noren — Up ↑