I have to do a dump of a Postgres database on a regular basis.
So pg_dump is the obvious choice to do this as is cron to do this periodically.
But the main problem with this is – pg_dump expects a password to be entered at the prompt. There’s no way to pass the password in the prompt to be able to do this.
Stackoverflow to the rescue.
What is required is a .pgpass file in the home directory.
I’ve long been a user of DBeaver which works so well across different OSes, so recently I wanted to set up the cloud version called cloudbeaver.
In the course of doing that, I had to generate SSH keys to be able to access remote databases via SSH.
The standard way of generating SSH keys is to run this command.
> ssh-keygen -t rsa
This by default creates id_rsa and id_rsa.pub under <home directory>/.ssh folder (both in Windows and Linux)
One of the things I forgot when I wrote the PM2 post is that PM2 creates logs. And these logs get very big, very fast!!
The pm2-logrotate takes care of this.
To install pm2-logrotate
$> pm2 install pm2-logrotate
The defaults work perfectly fine. It will retain logs for 30 days and rotate the log every day, each with a max-size of 10 MB.
To change any of these settings –
$> pm2 set pm2-logrotate:max_size 1K (1KB) $> pm2 set pm2-logrotate:compress true (compress logs when rotated) $> pm2 set pm2-logrotate:rotateInterval '*/1 * * * *' (force rotate every minute)
Every time I need to check the current version of Ubuntu, I have to run
$> lsb_release -a
But what if lsb_release is not installed?
The easiest way is to run
$> cat /etc/*release
This gives me an output like this!
There’s been a number of times I’ve wanted to not include some commands that I type into bash from being added to bash_history
The most convenient is to start a subshell by typing in bash again. This ensures that the commands in the subshell don’t get added to the history.
There are additional ways of achieving this as well.
Continue readingIn the Windows explorer address bar enter –
\\wsl$
While running a cron job in Linux, I sometimes get this error and I had been struggling to solve this until I came across this post.
Although that particular post mentions the cause being Vagrant, mine was due to a cron job.
First the solution …
.profile under home folderOpen ~/.profile
Replace the following line –
mesg n || true
with
tty -s && mesg n
The reason for this is given very well in the post linked above.
Continue readingWe got a weird error today when running the latest migration on a production Postgres DB.
cannot update table "schema_info" because it does not have a replica identity and publishes updates
The table schema_info is created when we run ruby Sequel migrations. This table stores just the version number of the latest migration applied under a column called version.
We had set up a replica database some time ago and it looked like the issue was because of this.
Continue reading
A number of times, I prefer to use the Windows key on the keyboard to create shortcuts, especially to applications which I use frequently.
However, Windows has a default set of keyboard shortcuts that it maps to various applications and those key mappings can’t be changed. A few examples are Cortana (Win+C), Clipboard (Win+V).
To get around this, the Registry Editor needs to be modified.
Continue readingEvery time I need to create, modify, grant sudo access to users in Linux, I have to search for it.
This is a list of the commands I’ve used in the past.
Will keep updating this so that I don’t have to load a search page every time!
All commands below are run as root user. If I’m not the root user, I need to prefix them with sudo!
Copyright © 2025 the möbius trip
Theme by Anders Noren — Up ↑