Re: [GENERAL] Strange result using pg_dump gzip or split.

2014-11-10 Thread Adrian Klaver
On 11/10/2014 03:34 AM, Condor wrote: Hello, I found strange result when I use pg_dump described on postgresql site: http://www.postgresql.org/docs/9.3/static/backup-dump.html I have a database with 30 gb data and decide to archive it, postgresql is 9.3.5 x64_86, ext4 file system, kernel 3.14.

Re: [GENERAL] Strange result using pg_dump gzip or split.

2014-11-10 Thread Francisco Olarte
Followup, second try. First of all, I'd like to apologize to the list for my previous message, I borked some finger gymnastics when switching tabs and sent and incomplete one. My fault. Sorry. Now what I tried to say was: I did not spot it at first, looking at http://www.gzip.org/zlib/rfc-gzip.h

Re: [GENERAL] Strange result using pg_dump gzip or split.

2014-11-10 Thread Francisco Olarte
Hi Condor. Followup, I did not spot it at first, looking at http://www.gzip.org/zlib/rfc-gzip.html#file-format I see: On Mon, Nov 10, 2014 at 12:34 PM, Condor wrote: > > Hello, > > I found strange result when I use pg_dump described on postgresql site: > http://www.postgresql.org/docs/9.3/stati

Re: [GENERAL] Strange result using pg_dump gzip or split.

2014-11-10 Thread Francisco Olarte
Hi Condor. On Mon, Nov 10, 2014 at 12:34 PM, Condor wrote: > I have a database with 30 gb data and decide to archive it, postgresql is > 9.3.5 x64_86, ext4 file system, kernel 3.14.18 Slackware 14.2 (current) > You should have a look at your tools, it seems you have a file size problem >

Re: [GENERAL] Strange result using pg_dump gzip or split.

2014-11-10 Thread John R Pierce
On 11/10/2014 3:34 AM, Condor wrote: Did the database dump is corrupt or not ? try restoring them to a new database -- john r pierce 37N 122W somewhere on the middle of the left coast -- Sent via pgsql-general mailing list (pgsql-general@postgresql

[GENERAL] Strange result using pg_dump gzip or split.

2014-11-10 Thread Condor
Hello, I found strange result when I use pg_dump described on postgresql site: http://www.postgresql.org/docs/9.3/static/backup-dump.html I have a database with 30 gb data and decide to archive it, postgresql is 9.3.5 x64_86, ext4 file system, kernel 3.14.18 Slackware 14.2 (current) Firs