linux gpg-check key failed update
danang setya pramana# 1. Clean DNF cache sudo dnf clean all # 2. Update the AlmaLinux release package (installs new keys) sudo dnf upgrade almalinux-release -y # 3. Import the latest AlmaLinux…
Backup & Restore Postgre SQL Database
pg_dump and pg_restore are command-line utilities for backing up and restoring PostgreSQL databases. The tar format is one of the non-plain text archive formats that pg_dump can produce and which pg_restore is designed to handle. Backing Up with pg_dump (TAR format) …
change all tables owner to specified user
first use select to show all tables from old owner SELECT tablename, schemaname,tableowner FROM pg_tables WHERE schemaname = 'public' AND tableowner = 'oldowner'; and make script for looping alter table…
To drop all primary key constraints in the public schema of a PostgreSQL database
DO $$ DECLARE r RECORD; BEGIN -- Select all primary key constraints in the 'public' schema FOR r IN ( SELECT table_name, constraint_name FROM information_schema.table_constraints WHERE constraint_type = 'PRIMARY KEY'…