PostgesSQL

Online Postgest testing

• crunchydata playground
• Supabase WASM

Cheatsheet

https://tomcam.github.io/postgres/#opening-a-connection-locally

https://www.geeksforgeeks.org/postgresql-psql-commands/

Basic commands

psql -d database -U user -W =  connect to database user specific user

psql -V       = version

\?            = help

\conninfo     = connection information

\l            = list databases

\dt           = list tables

\du           = display users

\s            = display command history

\i            = execute file

\H            = switch to HTML

\q            = quit

Dockers

https://www.docker.com/blog/how-to-use-the-postgres-docker-official-image/ 

https://www.baeldung.com/ops/postgresql-docker-setup

https://www.sqlshack.com/getting-started-with-postgresql-on-docker/ 

https://www.bytebase.com/blog/how-to-set-up-postgres-using-docker/

docker exec -it mypostgres psql -h localhost -U postgres

Ansible notes

Ansible is an open source, command-line IT automation software application that can configure systems, deploy software, and orchestrate workflows. I

• Steampunk ari_stark
• Installing cx_Oracle and Oracle Instant Client via Oracle Linux Yum Server
• How To Add Custom Modules In Ansible
• Ansible Playbook Examples - Sample Ansible Playbook
• how to setup inventory
• Server monitoring using ansible+
  
  

Upgrade ansible in linux

sudo dnf install python3-pip
sudo pip3 install --upgrade setuptools
sudo pip3 install --user --upgrade ansible
ansible --version

Ansible galaxy

Ansible-galaxy install -r collection/requirements.yml

Ansible-galaxy collection -h

Ansible-galaxy collection list

Ansible galaxy collection/collection.yml

https://intellipaat.com/blog/wp-content/uploads/2022/09/Ansible-Full-Image.pdf