X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 946E35E471D for ; Wed, 1 Sep 2004 16:58:40 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 82606-08 for ; Wed, 1 Sep 2004 19:58:32 +0000 (GMT) Received: from mail1.no-ip.com (mail1.no-ip.com [63.215.241.221]) by svr1.postgresql.org (Postfix) with SMTP id BEA635E4710 for ; Wed, 1 Sep 2004 16:58:30 -0300 (ADT) Received: (qmail 30936 invoked by uid 89); 1 Sep 2004 19:58:31 -0000 Received: from unknown (HELO localhost) (jsadove@beltion.net@192.168.15.3) by mail1.no-ip.com with SMTP; 1 Sep 2004 19:58:31 -0000 Received: from 168.215.96.10 ([168.215.96.10]) by webmail.no-ip.com (IMP) with HTTP for ; Wed, 1 Sep 2004 15:58:30 -0400 Message-ID: <1094068710.413629e6d540d@webmail.no-ip.com> Date: Wed, 1 Sep 2004 15:58:30 -0400 From: Joseph Sadove To: pgsql-admin@postgresql.org Subject: DROPped database doesn't go away Postgres7.4 MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit User-Agent: Internet Messaging Program (IMP) 3.2.1 X-WebMail: No-IP.com X-Originating-IP: 168.215.96.10 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/14 X-Sequence-Number: 14717 Hello All, I cannot “re-create” a database properly. I did a dump all of one database that runs on production. I copied the dmp file to dev environment, DROPped the existing database, CREATEd the database anew and then ran the dump in psql to recreate the database. The database (and/or db server) seems all scrambled now. The new database seems unchanged from the one I DROPped. When I DROP it again and just re- CREATE it, without doing anything, all the schemas and objects are there as if I never dropped it. After I DROP the database, I check that it is indeed gone by trying to psql to it. An error comes telling me the DB doesn’t exist. This is extremely bizarre. Any help is vastly appreciated. Thanks, Joe The environment, etc. is: RedHat ES3 (kernel 2.4.21) Postgres 7.4.2-1 unclustered -- "My grandfather once told me that there are two kinds of people: those who work and those who take the credit. He told me to try to be in the first group; there was less competition there." - Indira Gandhi