pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pg_dumpall size twist 2+ messages / 2 participants [nested] [flat]
* pg_dumpall size twist @ 2008-10-21 18:37 Marc Fromm <Marc.Fromm@wwu.edu> 2008-10-21 20:55 ` Re: pg_dumpall size twist Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Marc Fromm @ 2008-10-21 18:37 UTC (permalink / raw) To: pgsql-admin 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 other database is growing like this. The pg_dumpall is using the -c flag to drop databases before restoring them. When I do a restore I do this command: psql -U postgres -f alldb postgres. Has it something to do with using postgres as the starting db? I read in the documentation to start the restore with a starting point, and that postgres is a good place to start. Marc ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pg_dumpall size twist 2008-10-21 18:37 pg_dumpall size twist Marc Fromm <Marc.Fromm@wwu.edu> @ 2008-10-21 20:55 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2008-10-21 20:55 UTC (permalink / raw) To: Marc Fromm <Marc.Fromm@wwu.edu>; +Cc: pgsql-admin Marc Fromm <Marc.Fromm@wwu.edu> 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 using the -c flag to drop databases before restoring them. > When I do a restore I do this command: psql -U postgres -f alldb postgres. > Has it something to do with using postgres as the starting db? Well, yeah: you can't drop the database you're connected to. It might be a good idea to pay attention to the errors emitted by the dump script... regards, tom lane ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-10-21 20:55 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2008-10-21 18:37 pg_dumpall size twist Marc Fromm <Marc.Fromm@wwu.edu> 2008-10-21 20:55 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox