I tried it and it ran without any error but my table wasn't created so problem is going on. compress level isn't important because when I controlled it gave me same results ( 5 or 9 )
Unfortunately, only plain-old dump works correctly while restoring. if command contains any compress option, it won't work any suggestion ? -- Yasin MALLI System & Software Development Engineer yasinma...@gmail.com , yasinma...@yahoo.com On Mon, Aug 30, 2010 at 11:38 PM, Alban Hertroys < dal...@solfertje.student.utwente.nl> wrote: > On 31 Aug 2010, at 8:17, yasin malli wrote: > > Don't reply to just me, include the list. > > > if I took my dump file with 'pg_dump -Ft ' command, I would use > 'pg_restore', but I take my dump file at plain-old format for compressing > data ( tar format dump hasn't compress feature ) > > when I tried your suggestion, I take this error : pg_restore: [archiver] > input file does not appear to be a valid archive > > Ah right, most people use --compress in combination with the custom format > (-Fc). > > > I have little space on my device so I have to compress db files. > > For example; when I took dump_file with 'pg_dump -Ft' dump_files size : > 56K > > 'pg_dump > --compress=5' : 4K > > Try pg_dump -Fc --compress=5, I think you'll reach comparable sizes and > you'll get much more flexibility to restore your database. > Shouldn't you be using level 9 btw, if you're worried about disk space? > > > I can take a dump_file but I can't restore it. Is there any other way to > restore compressed data ? > > Didn't you read the man page for the --compress option? You can just pipe > your dump through gunzip. > > Alban Hertroys > > -- > Screwing up is an excellent way to attach something to the ceiling. > > > !DSPAM:1164,4c7ca36210403062783909! > > >