david wrote:
On Thu, 2006-12-07 at 17:04 -0800, Chris Travers wrote:It does a pg_dump and compresses it.Is there a significant difference between pg_dump and pg_dumpall?
Yes, there is. Pg_dumpall will dump all databases in your installation. If you have multiple databases installed then all of them will be dumped along with all of your custom functions, views, etc.
pg_dump simply dumps a specific db with all of it's attendant customizations.
pg_dump: http://www.postgresql.org/docs/8.2/static/app-pgdump.html pg_dumpall: http://www.postgresql.org/docs/8.2/static/app-pg-dumpall.html Hope that helps... Charley