Re: Another pg_dump using split and gzip for large databases

2021-08-03 Thread Bruce Momjian
On Thu, Jul 29, 2021 at 03:10:34PM -0400, 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,

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 wr

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 split"

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, wi

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" sin

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: 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 ex

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: > > > > Pa

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 exa

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 --

Re: Another pg_dump using split and gzip for large databases

2021-07-28 Thread Bruce Momjian
On Sat, Jul 17, 2021 at 03:09:52PM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/10/backup-dump.html > Description: > > pg_dump ccbank | split -b 2048m --filter='gzip > $FILE.gz' Wow, odd we didn

Another pg_dump using split and gzip for large databases

2021-07-19 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/10/backup-dump.html Description: pg_dump ccbank | split -b 2048m --filter='gzip > $FILE.gz'