Danang Setya Pramana - Working Memory
This is my working memory when i forgot some command and some code for my work
brew services start postgresql@18 issue Is another postmaster (PID 787) running in data directory "/opt/homebrew/var/postgresql@18 kill -9 787 rm /opt/homebrew/var/postgresql@18/postmaster.pid brew services restart postgresql@18 and postgresql start normally
SELECT 'ALTER TABLE ' || quote_ident(schemaname) || '.' || quote_ident(tablename) || ' OWNER TO nama_user_baru;' FROM pg_tables WHERE schemaname = 'public'; copy output ke psql kembali
edit pg_hba.conf and add host all all 192.168.1.0/24 scram-sha-256 after that enter on…
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'…
ALTER TABLE table_name ALTER COLUMN column_name TYPE BIGINT USING (column_name::bigint);
sebelumnya buat .env dan isi connection string untuk postgre POSTGRE_URL="postgresql://postgres:userpassword@localhost:5432/dbname" buat drizzle config import { defineConfig } from "drizzle-kit"; export default defineConfig({ schema: "./src/lib/db/postgresql/schema.ts", out: "./src/lib/drizzle/postgresql", dialect: "postgresql", dbCredentials: {…
karena saya menggunakan jendela saat ini , terpaksa saya menggunakan pg_loader dari docker , pertama ambil packagenya dulu dari remote milik dimitri docker pull ghcr.io/dimitri/pgloader:latest pertama pastikan kalian punya akses…
mengubah privileges user untuk semua tables GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO user; ubah nama field di dalam table ALTER nama_table RENAME COLUMN nama_lama TO nama_baru;…
danang setya pramana