PostgreSQL DBA Support

Search This Blog

How to check configuration - PostgreSQL DB

July 21, 2024

Get link
Facebook
X
Pinterest
Email
Other Apps

How to check configuration - PostgreSQL DB

C:\Users\amits>pg_controldata "D:\Program Files\PostgreSQL\data"

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

How to check configuration applied or not in PostgreSQL

How to use pg_basebackup utility

How to use pg_basebackup utility F - format t - tar z - zip P - progress X - wal files C:\Users\amits>pg_basebackup -D "D:\pg_data" -Ft -z -P -Xs Password: pg_basebackup: error: connection to server at "localhost" (::1), port 5432 failed: FATAL: password authentication failed for user "amits" C:\Users\amits>pg_basebackup -U postgres -D "D:\pg_data" -Ft -z -P -Xs Password: pg_basebackup: error: directory "D:\pg_data" exists but is not empty C:\Users\amits>pg_basebackup -U postgres -D "D:\pg_data\pg_backup" -Ft -z -P -Xs Password: 1 file(s) copied. 63489/63489 kB (100%), 1/1 tablespace 1 file(s) copied. 1 file(s) copied. Get 2 files in tar C:\Users\amits>pg_basebackup -U postgres -D "D:\pg_data\pg_backup" -Fp -P -Xs Password: 1 file(s) copied. 63489/63489 kB (100%), 1/1 tablespace 1 file(s) copied. 1...

PostgreSQL DB configuration Reload with Restart DB

PostgreSQL DB configuration Reload with Restart DB select pg_reload_conf(); pg_reload_conf ---------------- t (1 row)

Powered by Blogger

How to check configuration - PostgreSQL DB

How to check configuration - PostgreSQL DB

Comments

Post a Comment