Skip to main content
Database Administrators

Return to Answer

added 4 characters in body
Source Link
András Váczi
András Váczi
  • 31.6k
  • 13
  • 101
  • 149

The dump begins with setting TRANSACTION ISOLATION LEVEL SERIALIZABLE.

Please read the manual on Transaction Isolation and for example the User List discussion about this.

QouteQuote:

The backup will only see transactions that were commited before the isolation level was set.

Basically everything after pg_dumppg_dump sets the transaction isolation level is not part of this dump.

The read/write operations are not affected(locked) during that time.

The dump begins with setting TRANSACTION ISOLATION LEVEL SERIALIZABLE

Please read the manual on Transaction Isolation and for example the User List discussion about this

Qoute:

The backup will only see transactions that were commited before the isolation level was set.

Basically everything after pg_dump sets the transaction isolation level is not part of this dump.

The read/write operations are not affected(locked) during that time.

The dump begins with setting TRANSACTION ISOLATION LEVEL SERIALIZABLE.

Please read the manual on Transaction Isolation and for example the User List discussion about this.

Quote:

The backup will only see transactions that were commited before the isolation level was set.

Basically everything after pg_dump sets the transaction isolation level is not part of this dump.

The read/write operations are not affected(locked) during that time.

cleaned up sentences
Source Link
Dennis Nolte
Dennis Nolte
  • 465
  • 6
  • 14

The dump data is a TRANSACTION ISOLATION LEVEL SERIALIZABLE readbegins with setting TRANSACTION ISOLATION LEVEL SERIALIZABLE

Please read the manual on Transaction Isolation and for example the User DiscussionList discussion about this

The backup will only see transactions that were commited before the isolation level was set (which is the first pg_dump does)Qoute:

The backup will only see transactions that were commited before the isolation level was set.

Basically this means everything after pg_dump sets the transaction isolation level is not part of this dump.

But you canThe read/write on the database just fineoperations are not affected(locked) during that time.

The dump data is a TRANSACTION ISOLATION LEVEL SERIALIZABLE read the manual on Transaction Isolation and User Discussion about this

The backup will only see transactions that were commited before the isolation level was set (which is the first pg_dump does)

Basically this means everything after pg_dump sets the transaction isolation level is not part of this dump.

But you can read/write on the database just fine during that time.

The dump begins with setting TRANSACTION ISOLATION LEVEL SERIALIZABLE

Please read the manual on Transaction Isolation and for example the User List discussion about this

Qoute:

The backup will only see transactions that were commited before the isolation level was set.

Basically everything after pg_dump sets the transaction isolation level is not part of this dump.

The read/write operations are not affected(locked) during that time.

Source Link
Dennis Nolte
Dennis Nolte
  • 465
  • 6
  • 14

The dump data is a TRANSACTION ISOLATION LEVEL SERIALIZABLE read the manual on Transaction Isolation and User Discussion about this

The backup will only see transactions that were commited before the isolation level was set (which is the first pg_dump does)

Basically this means everything after pg_dump sets the transaction isolation level is not part of this dump.

But you can read/write on the database just fine during that time.