Hello, I do backup every day at work, but I heard that backup is the lowest access share mode.
If it's backup, I think it's pg_dump or pg_dumpall, but I can't find it when I look for documents online.
If it is pg_dump or pg_dumpall?, I would appreciate it if you could tell me where it is written like access share mode.
https://www.postgresql.jp/document/9.1/html/index.html is the postgresql document, right?
If possible, please let me know url.Japanese version, please.
postgresql
The 24.1.SQL dump page of the postgresql document in the question reads:This statement appears to indicate that pg_dump, pg_dumpall is access share mode.
Dumps created with pg_dump are internally consistent.In other words, the dump shows a snapshot of the database when pg_dump was started.The pg_dump operation does not interfere with other operations on the database (except for operations that require exclusive locking, such as most forms of ALTER TABLE).
pg_dumpall re-creates roles, tablespace, and databases by issuing the command, and starts pg_dump for each database.This indicates that while each database is internally consistent, snapshots of different databases may not be fully synchronized.
© 2024 OneMinuteCode. All rights reserved.