Just to provide a quick and more technical description of the difference: All database objects are stored in databases in PostgreSQL. This includes global objects (users/groups), local objects (tables), etc.
PostgreSQL also has the concept of template databases. When a database is created, the template database is basically copied to another location on disk and the catalogs updated. The two main template databases are: template0 (the main base template) and template1 (the secondary template, which could be customized-- most db's start out as copies of template1). Most SQL-Ledger users were adding PLPGSQL to template1 so that when they create databases, they all have the language installed. pg_dumpall dumps all databases including global objects. pg_dump essentially takes the diff of the database from template0. THis means, if you have languages installed in template1, they will be reinstalled via the pg_dump bit as well. Hope this helps, Chris Travers ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys - and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
