does pg_dump provide a consistent value for sequences in postgreSQL (for long running transactions)
When pg_dump captures a full backup, if we have sequences being updated, does pg_dump guarantee that the sequence values will be consistent when the export is being done? To elaborate, if pg_dump takes an hour to run, and if sequences are being updated, are the sequence values consistent with when the pg_dump was executed, or will it be the latest sequence values when pg_dump finishes?