I think PgAdmin ,in 1.8 at least, is by default set to hide system objects like the template databases. To enable this go to File->Options->Display and make sure to check the "Show system objects in treeview". You may want to check some of the other options as well. Hope that helps, Regina -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Douglas McNaught Sent: Monday, December 10, 2007 11:27 AM To: Ted Byers Cc: Richard Huxton; Tino Wildenhain; Uwe C. Schroeder; pgsql-general@xxxxxxxxxxxxxx Subject: Re: Simpler dump? On 12/10/07, Ted Byers <r.ted.byers@xxxxxxxxxx> wrote: > So, how do I determine whether or not template1 really > exists on my server and is a copy of template0 (as I'd > infer from what I see in postgres) rather than > template_postgis, and then modify things so that the > default is the normal template1 rather than > template_postgis, but leaving the latter in place so I > can use it when I need it? Try using the 'psql' command line tool to list your databases--it sounds like pgAdmin might be hiding some of them from you (which isn't the fault of anyone on this list since pgAdmin is a separate project). It's certainly conceivable that someone before you set up template_postgis as the default template database, but getting an accurate catalog of what you've got sounds like the first step. -Doug ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ ----------------------------------------- The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
