Re: [GENERAL] pg_dump fundenental question

2016-07-06 Thread Francisco Olarte
On Tue, Jul 5, 2016 at 7:39 PM, J. Cassidy wrote: > My input (source) DB is 1TB in size, using the options as stated in my > original email (i.e. no compression it would seem) the output file size is > "only" 324GB. > I presume all of the formatting/indices have been ommited. As I said before, >

Re: [GENERAL] pg_dump fundenental question

2016-07-05 Thread trafdev
"less" is much better for opening huge text files in *nix for reading. On 07/05/16 15:13, Christofer C. Bell wrote: On Tue, Jul 5, 2016 at 3:17 PM, Paul Linehan mailto:lineh...@tcd.ie>> wrote: > a good point, but I would prefer NOT to open a 324GB backup file in a text > editor. I can h

Re: [GENERAL] pg_dump fundenental question

2016-07-05 Thread Christofer C. Bell
On Tue, Jul 5, 2016 at 3:17 PM, Paul Linehan wrote: > > a good point, but I would prefer NOT to open a 324GB backup file in a > text > > editor. I can however cat/less/head/tail the file in Linux. > > Use vi (or flavour thereof) - it doesn't load the entire file in order to > read the contents of

Re: [GENERAL] pg_dump fundenental question

2016-07-05 Thread Paul Linehan
> a good point, but I would prefer NOT to open a 324GB backup file in a text > editor. I can however cat/less/head/tail the file in Linux. Use vi (or flavour thereof) - it doesn't load the entire file in order to read the contents of lines 1 - 100 (say). Paul... -- Sent via pgsql-general mail

Re: [GENERAL] pg_dump fundenental question

2016-07-05 Thread Sameer Kumar
On Wed, 6 Jul 2016, 1:39 a.m. J. Cassidy, wrote: > Francisco, > > appreciate the tips/hints. > > My input (source) DB is 1TB in size, using the options as stated in my > original email (i.e. no compression it would seem) the output file size is > "only" 324GB. > It would be because of indexes d

Re: [GENERAL] pg_dump fundenental question

2016-07-05 Thread J. Cassidy
Thank you all for the information. On 07/05/2016 10:10 AM, J. Cassidy wrote: > Hello Adrian, > > appreciate the prompt reply, thank you. > > As stated in the original email, I want to know whether compression > (whatever level) is on by default (or not) - if I supply NO extra > switches/options

Re: [GENERAL] pg_dump fundenental question

2016-07-05 Thread J. Cassidy
Francisco, appreciate the tips/hints. My input (source) DB is  1TB in size, using the options as stated in my original email (i.e. no compression it would seem) the output file size is "only" 324GB.  I presume all of the formatting/indices have been ommited. As I said before, I can browse the b

Re: [GENERAL] pg_dump fundenental question

2016-07-05 Thread Joshua D. Drake
On 07/05/2016 10:10 AM, J. Cassidy wrote: Hello Adrian, appreciate the prompt reply, thank you. As stated in the original email, I want to know whether compression (whatever level) is on by default (or not) - if I supply NO extra switches/options. There is no compression by default. -- Com

Re: [GENERAL] pg_dump fundenental question

2016-07-05 Thread Francisco Olarte
On Tue, Jul 5, 2016 at 4:54 PM, J. Cassidy wrote: > I have hopefully an "easy" question. > If I issue the pg_dump command with no switches or options i.e. > /usr/local/pgsql/bin/pg_dump -v dbabcd > /data3TB/Backup/dbabcd > Is their any "default" compression involved or not? Does pg_dump talk to >

Re: [GENERAL] pg_dump fundenental question

2016-07-05 Thread Alvaro Herrera
J. Cassidy wrote: > As stated in the original email, I want to know whether compression > (whatever level) is on by default (or not) -  if I supply NO extra > switches/options. I have read the documentation and it is unclear in > this respect. I am a Mainframer and perhaps have a different world

Re: [GENERAL] pg_dump fundenental question

2016-07-05 Thread J. Cassidy
Rob, appreciate the reply but I have never used nor never will use "that" os (small capitals intentional. Regards, Henk

Re: [GENERAL] pg_dump fundenental question

2016-07-05 Thread J. Cassidy
Hello David, a good point, but I would prefer NOT to open a 324GB backup file in a text editor. I can however cat/less/head/tail the file in Linux. Regards, Henk  

Re: [GENERAL] pg_dump fundenental question

2016-07-05 Thread J. Cassidy
Hello Adrian, appreciate the prompt reply, thank you. As stated in the original email, I want to know whether compression (whatever level) is on by default (or not) -  if I supply NO extra switches/options. I have read the documentation and it is unclear in this respect. I am a Mainframer and

Re: [GENERAL] pg_dump fundenental question

2016-07-05 Thread Rob Sargent
On 07/05/2016 10:54 AM, David G. Johnston wrote: On Tue, Jul 5, 2016 at 10:54 AM, J. Cassidy >wrote: Hello all, I have hopefully an "easy" question. If I issue the pg_dump command with no switches or options i.e. /usr/local/pgsql/bin/pg_dump -v dbab

Re: [GENERAL] pg_dump fundenental question

2016-07-05 Thread David G. Johnston
On Tue, Jul 5, 2016 at 10:54 AM, J. Cassidy wrote: > Hello all, > > I have hopefully an "easy" question. > > If I issue the pg_dump command with no switches or options i.e. > > /usr/local/pgsql/bin/pg_dump -v dbabcd > /data3TB/Backup/dbabcd > > Is their any "default" compression involved or not?

Re: [GENERAL] pg_dump fundenental question

2016-07-05 Thread Adrian Klaver
On 07/05/2016 07:54 AM, J. Cassidy wrote: Hello all, I have hopefully an "easy" question. If I issue the pg_dump command with no switches or options i.e. /usr/local/pgsql/bin/pg_dump -v dbabcd > /data3TB/Backup/dbabcd Is their any "default" compression involved or not? Does pg_dump talk to zl

[GENERAL] pg_dump fundenental question

2016-07-05 Thread J. Cassidy
Hello all, I have hopefully an "easy" question. If I issue the pg_dump command with no switches or options i.e. /usr/local/pgsql/bin/pg_dump -v dbabcd > /data3TB/Backup/dbabcd Is their any "default" compression involved or not? Does pg_dump talk to zlib during the dump process given that I ha