Shin Code log

Logs of solution for code

Articles


[Postgres] How to list active connections on PostgreSQL?

You can check connection details in Postgres using pgstatactivity. You can apply filter to satisfy your condition.

[Postgres] How to list active connections on PostgreSQL?

Run docker image with bash

Spawn a container and jump right into a shell

Run docker image with bash

[Postgresql] Check number of connection to db

The query to check number of connection to db and more details about activity

SQL Postgresql, run docker ssl mode

Enabling SSL for PostgreSQL in Docker

SQL Postgresql, run docker ssl mode

[Postgres] Restore backup file, sql file type

The way to restore backup db from terminal

[Postgres] Restore backup file, sql file type

Compress file by terminal in macos

In Terminal, you can use the GNU tar command to compress and uncompress files and folders. The usual file extension for a compressed tar archive is .tgz, although you might also see files ending with the .tar.gz extension. If the archive isn’t compressed, it usually just ends in .tar.

Compress file by terminal in macos