![Preview Image](https://raw.githubusercontent.com/lamngockhuong/dev-images/main/posts/2023/10/sql.png)
Terminating (kill) database connection, specific session
PostgreSQL Find session ID (pid) SELECT * FROM pg_stat_activity WHERE datname = 'dbname' # postgres database AND usename = 'apiuser' # postgres username Kill session pg_cancel_backend(pid):...
PostgreSQL Find session ID (pid) SELECT * FROM pg_stat_activity WHERE datname = 'dbname' # postgres database AND usename = 'apiuser' # postgres username Kill session pg_cancel_backend(pid):...
Guideline To set the scroll direction of your mouse, do the following steps: Step 1: Open Windows PowerShell in Administrator Mode. You can do this by going to Start Menu, type PowerShell, and cl...
Guideline 1. Creating the SSH keys. For each SSH key pairs: Go ~/.ssh Run: ssh-keygen -t rsa -b 4096 -C "[email protected]" 2. Register your keys to the respective GitHub accounts. Follow...
First run /usr/libexec/java_home -V to check available Java Virtual Machine: Matching Java Virtual Machines (2): 20.0.1 (arm64) "Eclipse Adoptium" - "OpenJDK 20.0.1" /Library/Java/JavaVirtualMachi...
Gradle What’s the difference between implementation, api and compile (compileOnly, runtimeOnly, testImplementation, testCompileOnly, testRuntimeOnly) in Gradle? Name Role ...
Gradle (Groovy) . ├── app │ ... │ └── build.gradle └── settings.gradle rootProject.name = 'basic-multiproject' include 'app' plugins { id 'application' } application { mainClass ...
This tutorial will guide you how to write a post in the Chirpy template, and it’s worth reading even if you’ve used Jekyll before, as many features require specific variables to be set. Naming and...
Whichjdk Introduce JDK, OpenJDK and some openjdk distributions. And some recommendations for using the right distributions Baeldung This blog publishes to-the-point guides and courses, with...
Examples Example 1: List All instances from Default Region aws ec2 describe-instances Example 2: List All instances with query With all informations aws ec2 describe-instances \ --region ...
Prepare Dockerfile, image, container and IP address Dockerfile FROM ubuntu:22.10 RUN apt update && apt install -y openssh-server nano RUN mkdir /var/run/sshd # Aa@123456 is root pa...