0

I'm a SQL Serve DBA new to PostgreSQL. Does pg_dump have an impact on the backup chain, i.e., in SQL Server if I needed a copy of a database I would peform a COPYONLY backup so as not to break the lsn sequence. Does pg_dump impact the native Azure backups being performed in the background?

Improve this question

1 Answer 1

Reset to default
0

If Azure is anything like PostgreSQL, an online physical backup won't interfere with pg_dump and vice versa (except that both will generate I/O load).

pg_dump uses a REPEATABLE READ transaction which guarantees a consistent backup.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.