Обсуждение: BUG #2333: dropdb ignores the database name argument
The following bug has been logged online: Bug reference: 2333 Logged by: kevin barnes Email address: vinbarnes@gmail.com PostgreSQL version: 8.1 Operating system: ubuntu 5.10 Description: dropdb ignores the database name argument Details: In the 8.1 release on Unbuntu 5.10 there is an error with the dropdb command in /usr/bin. The error manifests itself by not respecting the DBNAME argument. It assumes that you want to connect to a database named 'postgres' and ignores whatever argument you give it. The error returned is: dropdb: database removal failed: ERROR: database "postgres" does not exist The error is actually correct, because I do not have a database named postgres, but the command does not work correctly. I downgraded through apt-get to 8.0 and dropdb works as expected. I believe the version I was running was 8.1.3.
kevin barnes wrote: > > The following bug has been logged online: > > Bug reference: 2333 > Logged by: kevin barnes > Email address: vinbarnes@gmail.com > PostgreSQL version: 8.1 > Operating system: ubuntu 5.10 > Description: dropdb ignores the database name argument > Details: > > In the 8.1 release on Unbuntu 5.10 there is an error with the dropdb command > in /usr/bin. The error manifests itself by not respecting the DBNAME > argument. It assumes that you want to connect to a database named 'postgres' > and ignores whatever argument you give it. The error returned is: > > dropdb: database removal failed: ERROR: database "postgres" does not exist > > The error is actually correct, because I do not have a database named > postgres, but the command does not work correctly. > > I downgraded through apt-get to 8.0 and dropdb works as expected. I believe > the version I was running was 8.1.3. I think something strange is happening in your installation. I can not reproduce your failure. -- Bruce Momjian http://candle.pha.pa.us SRA OSS, Inc. http://www.sraoss.com + If your life is a hard drive, Christ can be your backup. +
kevin barnes wrote: > In the 8.1 release on Unbuntu 5.10 there is an error with the dropdb command > in /usr/bin. The error manifests itself by not respecting the DBNAME > argument. It assumes that you want to connect to a database named 'postgres' > and ignores whatever argument you give it. The error returned is: > > dropdb: database removal failed: ERROR: database "postgres" does not exist > > The error is actually correct, because I do not have a database named > postgres, but the command does not work correctly. I think what is happening here is that dropdb is trying to connect to the postgres database to issue the DROP DATABASE command, and fails because it doesn't exist. I thought it was fixed not long ago to retry by connecting to template1 if postgres didn't exist; maybe it wasn't really done and I'm misremembering, or maybe you're using a version without the fix (and thus you should upgrade). The obvious workaround is to create a database named postgres. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.