Re: Common case not at all clear

2021-07-29 Thread David G. Johnston
On Thu, Jul 29, 2021 at 8:44 PM Anthony Berglas wrote: > My point is that while I can follow the academic style discussion, most of > my colleagues could not. They just need to have a clear idea of how to > handle the common case, which is to use a database using some programming > language. >

Re: [PATCH] add link to domain data types section from locale documentation

2021-07-29 Thread Laurenz Albe
On Fri, 2021-07-23 at 23:07 +0200, Jürgen Purtz wrote: > On 27.05.21 09:45, Laurenz Albe wrote: > > I like the new link from "src/sgml/charset.sgml", but I think that > > there are a few other places in the documentation that are likely to be > > read by people who don't know about SQL domains and

Re: getting table name from partition

2021-07-29 Thread Bruce Momjian
On Wed, Jul 14, 2021 at 01:45:12PM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/ddl-partitioning.html > Description: > > I would like to add a sentence like this into the description of >

Re: Another pg_dump using split and gzip for large databases

2021-07-29 Thread Daniel Gustafsson
> On 29 Jul 2021, at 21:10, Bruce Momjian wrote: > > On Thu, Jul 29, 2021 at 07:15:21PM +0200, Daniel Gustafsson wrote: >>> On 29 Jul 2021, at 17:29, Bruce Momjian wrote: >>> >>> On Thu, Jul 29, 2021 at 05:23:20PM +0200, Daniel Gustafsson wrote: > On 29 Jul 2021, at 16:58, Bruce Momjian

Re: Another pg_dump using split and gzip for large databases

2021-07-29 Thread Bruce Momjian
On Thu, Jul 29, 2021 at 07:15:21PM +0200, Daniel Gustafsson wrote: > > On 29 Jul 2021, at 17:29, Bruce Momjian wrote: > > > > On Thu, Jul 29, 2021 at 05:23:20PM +0200, Daniel Gustafsson wrote: > >>> On 29 Jul 2021, at 16:58, Bruce Momjian wrote: > >> > >>> OK, I can adjust it to say "GNU

Re: Another pg_dump using split and gzip for large databases

2021-07-29 Thread Daniel Gustafsson
> On 29 Jul 2021, at 17:29, Bruce Momjian wrote: > > On Thu, Jul 29, 2021 at 05:23:20PM +0200, Daniel Gustafsson wrote: >>> On 29 Jul 2021, at 16:58, Bruce Momjian wrote: >> >>> OK, I can adjust it to say "GNU split" or just skip this addition. >> >> I don't have strong feelings either way,

Re: Another pg_dump using split and gzip for large databases

2021-07-29 Thread Bruce Momjian
On Thu, Jul 29, 2021 at 05:23:20PM +0200, Daniel Gustafsson wrote: > > On 29 Jul 2021, at 16:58, Bruce Momjian wrote: > > > OK, I can adjust it to say "GNU split" or just skip this addition. > > I don't have strong feelings either way, with a slight preference for writing > it as "GNU split"

Re: Another pg_dump using split and gzip for large databases

2021-07-29 Thread Daniel Gustafsson
> On 29 Jul 2021, at 16:58, Bruce Momjian wrote: > OK, I can adjust it to say "GNU split" or just skip this addition. I don't have strong feelings either way, with a slight preference for writing it as "GNU split" since it's still a good tip for a large amount of readers. -- Daniel Gustafsson

Re: Common case not at all clear

2021-07-29 Thread David G. Johnston
On Thu, Jul 29, 2021 at 8:04 AM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/transaction-iso.html > Description: > > For all this documentation, it is completely unclear how to handle the most >

Re: Common case not at all clear

2021-07-29 Thread Bruce Momjian
On Wed, Jul 28, 2021 at 03:48:04AM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/13/transaction-iso.html > Description: > > For all this documentation, it is completely unclear how to handle the

Re: Another pg_dump using split and gzip for large databases

2021-07-29 Thread James Doherty
Good point. On Thu, Jul 29, 2021 at 04:27 Daniel Gustafsson wrote: > > On 29 Jul 2021, at 01:46, Bruce Momjian wrote: > > On Sat, Jul 17, 2021 at 03:09:52PM +, PG Doc comments form wrote: > > >> pg_dump ccbank | split -b 2048m --filter='gzip > $FILE.gz' > > > > Wow, odd we didn't have an

Re: Another pg_dump using split and gzip for large databases

2021-07-29 Thread James Doherty
They key to my comment is splits —filter command which allows gzip each of the split files On Wed, Jul 28, 2021 at 18:46 Bruce Momjian wrote: > On Sat, Jul 17, 2021 at 03:09:52PM +, PG Doc comments form wrote: > > The following documentation comment has been logged on the website: > > > >

Common case not at all clear

2021-07-29 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/transaction-iso.html Description: For all this documentation, it is completely unclear how to handle the most common, simple case. I.e. Select balance into :bal ...where key =123;

Re: Another pg_dump using split and gzip for large databases

2021-07-29 Thread Bruce Momjian
On Thu, Jul 29, 2021 at 11:27:20AM +0200, Daniel Gustafsson wrote: > > On 29 Jul 2021, at 01:46, Bruce Momjian wrote: > > On Sat, Jul 17, 2021 at 03:09:52PM +, PG Doc comments form wrote: > > >> pg_dump ccbank | split -b 2048m --filter='gzip > $FILE.gz' > > > > Wow, odd we didn't have an

Re: Another pg_dump using split and gzip for large databases

2021-07-29 Thread Daniel Gustafsson
> On 29 Jul 2021, at 01:46, Bruce Momjian wrote: > On Sat, Jul 17, 2021 at 03:09:52PM +, PG Doc comments form wrote: >> pg_dump ccbank | split -b 2048m --filter='gzip > $FILE.gz' > > Wow, odd we didn't have an example of using gzip and split together; > patch attached. Maybe because the