PostgreSQL DBA Support

Search This Blog

PostgreSQL DB configuration Reload with Restart DB

July 21, 2024

Get link
Facebook
X
Pinterest
Email
Other Apps

PostgreSQL DB configuration Reload with Restart DB

select pg_reload_conf();

pg_reload_conf

----------------

t

(1 row)

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...

Powered by Blogger

PostgreSQL DB configuration Reload with Restart DB

Comments

Post a Comment