From: Joseph Sadove <jsadove@beltion.net>
To: pgsql-admin@postgresql.org
Subject: DROPped database doesn't go away Postgres7.4
Date: Wed, 1 Sep 2004 15:58:30 -0400
Message-ID: <1094068710.413629e6d540d@webmail.no-ip.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: jsadove@beltion.net
Subject: Re: DROPped database doesn't go away Postgres7.4
In-Reply-To: <1094068710.413629e6d540d@webmail.no-ip.com>
References: <1094068710.413629e6d540d@webmail.no-ip.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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