Re: [GENERAL] pg_dump issues

2010-02-02 Thread Reece Hart
On 02/02/2010 03:41 PM, DM wrote: You were right, after zipping the dump file it came out to 6.9G Also check out the "custom" pg_dump format (pg_dump -Fc ...), which is compressed. There are caveats regarding portability across PG versions with the custom format, which you may want to resear

Re: [GENERAL] pg_dump issues

2010-02-02 Thread DM
You were right, after zipping the dump file it came out to 6.9G Thanks for your help. thanks Deepak On Tue, Feb 2, 2010 at 3:20 PM, Scott Marlowe wrote: > On Tue, Feb 2, 2010 at 4:07 PM, DM wrote: > > Hi All, > > I have a database with only one schema with 5 tables > > nspname | relname

Re: [GENERAL] pg_dump issues

2010-02-02 Thread Jean-Yves F. Barbier
DM a écrit : > Hi All, > > I have a database with only one schema with 5 tables > > nspname | relname | size > -+-+- > sch | job1 | 211 MB > sch | job2 | 5611 MB > sch |

Re: [GENERAL] pg_dump issues

2010-02-02 Thread Scott Marlowe
On Tue, Feb 2, 2010 at 4:07 PM, DM wrote: > Hi All, > I have a database with only one schema with 5 tables > nspname |       relname           |  size >      -+-+- >      sch     | job1                      | 211 MB >      sch     | job2                      | 5

Re: [GENERAL] pg_dump issues

2010-02-02 Thread DM
Hi All, I have a database with only one schema with 5 tables nspname | relname | size -+-+- sch | job1 | 211 MB sch | job2 | 5611 MB sch | job3 | 658

[GENERAL] pg_dump issues

2010-02-02 Thread DM
Hi All, I have a database with only one schema with 5 tables nspname | relname | size -+-+- sch | job1 | 211 MB sch | job2 | 5611 MB sch | job3 | 658