Skip site navigation (1) Skip section navigation (2)

Re: dropdb weirdness

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: Geoffrey <lists(at)serioustechnology(dot)com>
Subject: Re: dropdb weirdness
Date: 2010-06-29 20:22:47
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On Tuesday 29 June 2010 1:04:27 pm Geoffrey wrote:
> So running the following command:
> dropdb -p 5443 swr
> I get:
> dropdb: could not connect to database postgres: FATAL:  database
> "postgres" does not exist
> Why is it not 'seeing' the database name I'm passing to it?  Why is it
> trying to drop a database named postgres??
> --

It needs to connect to the database cluster to run the DROP DATABASE command and 
is trying to use the system database postgres. Did you drop the postgres 
database? Does the user you are connecting as have the permissions to postgres?

Adrian Klaver

In response to


pgsql-general by date

Next:From: Tom LaneDate: 2010-06-29 21:00:30
Subject: Re: dropdb weirdness
Previous:From: Merlin MoncureDate: 2010-06-29 20:20:26
Subject: Re: dropdb weirdness

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group