[DOCS] pg_dump locking info

2010-08-15 Thread Thom Brown
Is this right? I'm looking at http://www.postgresql.org/docs/current/static/backup-dump.html It says, "pg_dump does not block other operations on the database while it is working. (Exceptions are those operations that need to operate with an exclusive lock, such as most forms of ALTER TABLE.)" S

Re: [DOCS] pg_dump locking info

2010-08-15 Thread Thom Brown
On 15 August 2010 10:01, Thom Brown wrote: > Is this right?  I'm looking at > http://www.postgresql.org/docs/current/static/backup-dump.html > > It says, "pg_dump does not block other operations on the database > while it is working. (Exceptions are those operations that need to > operate with an

Re: [DOCS] pg_dump locking info

2010-08-15 Thread Thom Brown
On 15 August 2010 10:29, Thom Brown wrote: > On 15 August 2010 10:01, Thom Brown wrote: >> Is this right?  I'm looking at >> http://www.postgresql.org/docs/current/static/backup-dump.html >> >> It says, "pg_dump does not block other operations on the database >> while it is working. (Exceptions a

Re: [DOCS] pg_dump locking info

2010-08-15 Thread Stefan Kaltenbrunner
On 08/15/2010 11:01 AM, Thom Brown wrote: Is this right? I'm looking at http://www.postgresql.org/docs/current/static/backup-dump.html It says, "pg_dump does not block other operations on the database while it is working. (Exceptions are those operations that need to operate with an exclusive l

Re: [DOCS] pg_dump locking info

2010-08-15 Thread Thom Brown
On 15 August 2010 10:38, Thom Brown wrote: > On 15 August 2010 10:29, Thom Brown wrote: >> On 15 August 2010 10:01, Thom Brown wrote: >>> Is this right?  I'm looking at >>> http://www.postgresql.org/docs/current/static/backup-dump.html >>> >>> It says, "pg_dump does not block other operations on

Re: [DOCS] pg_dump locking info

2010-08-15 Thread Thom Brown
On 15 August 2010 10:45, Stefan Kaltenbrunner wrote: > On 08/15/2010 11:01 AM, Thom Brown wrote: >> >> Is this right?  I'm looking at >> http://www.postgresql.org/docs/current/static/backup-dump.html >> >> It says, "pg_dump does not block other operations on the database >> while it is working. (E

Re: [DOCS] pg_dump locking info

2010-08-15 Thread Thom Brown
On 15 August 2010 10:47, Thom Brown wrote: > On 15 August 2010 10:38, Thom Brown wrote: >> On 15 August 2010 10:29, Thom Brown wrote: >>> On 15 August 2010 10:01, Thom Brown wrote: Is this right?  I'm looking at http://www.postgresql.org/docs/current/static/backup-dump.html

Re: [DOCS] pg_dump locking info

2010-08-15 Thread Scott Marlowe
On Sun, Aug 15, 2010 at 3:47 AM, Thom Brown wrote: > On 15 August 2010 10:38, Thom Brown wrote: >> >> Another thing I noticed, going back to >> http://www.postgresql.org/docs/current/static/backup-file.html , is >> that it makes no mention of the fact that file system level backups >> are useless

Re: [DOCS] pg_dump locking info

2010-08-15 Thread Thom Brown
On 15 August 2010 15:38, Scott Marlowe wrote: > On Sun, Aug 15, 2010 at 3:47 AM, Thom Brown wrote: >> On 15 August 2010 10:38, Thom Brown wrote: >>> >>> Another thing I noticed, going back to >>> http://www.postgresql.org/docs/current/static/backup-file.html , is >>> that it makes no mention of

Re: [DOCS] pgbench acronym tps

2010-08-15 Thread Tom Lane
Robert Haas writes: > On Fri, Aug 6, 2010 at 7:43 PM, Erik Rijkers wrote: >> I noticed that pgbench.sgml (or the manual elsewhere) >> does not explicitly mention what TPS stands for; >> I thought it might be useful to add. >> >> (reason I checked: someone on #postgresql took tps >> to mean 'tupl

Re: [DOCS] Patch for some typos in pgarchivecleanup.sgml

2010-08-15 Thread Tom Lane
Fujii Masao writes: > 2010/8/11 Satoshi Nagayasu : >> -archive_cleanup_command = 'pg_archivecleanup -d .../archive %r >> 2>>cleanup.log' >> +archive_cleanup_command = 'pg_archivecleanup -d ../archive %r >> 2>>cleanup.log' > This is not a typo. Triple dots ... is used as replaceable part of the

Re: [DOCS] pg_dump locking info

2010-08-15 Thread Robert Haas
On Sun, Aug 15, 2010 at 5:29 AM, Thom Brown wrote: > And whilst I was perusing the docs, I also noticed this on > http://www.postgresql.org/docs/current/static/backup.html > > "Each has its own strengths and weaknesses. Each is discussed in turn below." > > That sentence is at the bottom of the pa

Re: [DOCS] pg_dump locking info

2010-08-15 Thread Robert Haas
On Sun, Aug 15, 2010 at 5:38 AM, Thom Brown wrote: > Another thing I noticed, going back to > http://www.postgresql.org/docs/current/static/backup-file.html , is > that it makes no mention of the fact that file system level backups > are useless if being used to restore in a different major versio

Re: [DOCS] pg_dump locking info

2010-08-15 Thread Robert Haas
On Sun, Aug 15, 2010 at 5:47 AM, Thom Brown wrote: > In the docs for version 9.0, I think the following from > http://www.postgresql.org/docs/9.0/static/migration.html should be > updated to make mention of streaming replication: > > "It is also possible to use replication methods, such as Slony,

Re: [DOCS] pg_dump locking info

2010-08-15 Thread Tom Lane
Robert Haas writes: > On Sun, Aug 15, 2010 at 5:29 AM, Thom Brown wrote: >> And whilst I was perusing the docs, I also noticed this on >> http://www.postgresql.org/docs/current/static/backup.html >> >> "Each has its own strengths and weaknesses. Each is discussed in turn below." >> >> That sent

Re: [DOCS] pg_dump locking info

2010-08-15 Thread Tom Lane
I did something about Thom's various gripes. See what you think ... regards, tom lane -- Sent via pgsql-docs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-docs

Re: [DOCS] pg_dump locking info

2010-08-15 Thread Thom Brown
On 16 August 2010 00:05, Tom Lane wrote: > I did something about Thom's various gripes.  See what you think ... > >                        regards, tom lane > That's great Tom. Thanks. :) The note about restoring to a different architecture hadn't crossed my mind. -- Thom Brown Registered Lin