Wednesday, November 23, 2022

PostgreSQL : How to verify archive mode is enabled or not

 How to verify archive mode is enabled or not



Login to PostgreSQL database with super privilege 


postgres=#

postgres=# show archive_mode;

 archive_mode

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

 off

(1 row)


postgres=#

-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to switch/connect with other database (demo)?

  postgres=# postgres=# postgres=# postgres=# \c demo You are now connected to database "demo" as user "postgres". demo=...