Re: [ADMIN] pg_dumpall size

2008-10-21 Thread Scott Marlowe
On Tue, Oct 21, 2008 at 11:56 AM, Marc Fromm <[EMAIL PROTECTED]> wrote: > I have the same postgresql databases on two different servers. > > Boteh servers have the same version of postgresql, 8.1. > > The following backup command creates a file twice as big on one server, > compared to the other se

Re: [ADMIN] pg_dumpall size twist

2008-10-21 Thread Tom Lane
Marc Fromm <[EMAIL PROTECTED]> writes: > It turns out that one specific database called postgres is growing each time > I perform a restore from the pg_dumpall files. > The database postgres has gone from 5.1MB to 10MB to 15MB to 20MB. No other > database is growing like this. The pg_dumpall is u

[ADMIN] pg_dumpall size twist

2008-10-21 Thread Marc Fromm
I submitted a post about my pg_dumpall file being twice as big on one server compared to the other. It turns out that one specific database called postgres is growing each time I perform a restore from the pg_dumpall files. The database postgres has gone from 5.1MB to 10MB to 15MB to 20MB. No oth

[ADMIN] pg_dumpall size

2008-10-21 Thread Marc Fromm
I have the same postgresql databases on two different servers. Boteh servers have the same version of postgresql, 8.1. The following backup command creates a file twice as big on one server, compared to the other server. pg_dumpall -c -U postgres | gzip > alldb.gz Red Hat 5EL: alldb.gz is 29MB Fe