Danang Setya Pramana - Working Memory
This is my working memory when i forgot some command and some code for my work
# Install the repository RPM: sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm # Disable the built-in PostgreSQL module: sudo dnf -qy module disable postgresql # Install PostgreSQL: sudo dnf install -y postgresql18-server…
dnf install https://dl.fedoraproject.org/pub/epel/epel-release-latest-8.noarch.rpm -y dnf install https://rpms.remirepo.net/enterprise/remi-release-8.rpm -y jika SELINUX di disable bisa menggunakan fungsi sock akan tetapi jika tidak akan sulit menyesuaikan permissionnya lebih menggunakan listen 7000 misalnya…
command show processor architecture the huge problem to success the installation is you must install in non-root user cause if u use root user you will fail uname -m x86_64…
edit pg_hba.conf and add host all all 192.168.1.0/24 scram-sha-256 after that enter on…
goto nano /usr/local/apache/conf/httpd.conf add ServerName your_domain.com:80 use Config Test /usr/local/apache/bin/apachectl configtest if Ok Restart Services
# 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…
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) …
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…
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'…
danang setya pramana