Re: dropdb to a remote host - Mailing list pgsql-general

From Jason Earl
Subject Re: dropdb to a remote host
Date
Msg-id 87n11qjpmm.fsf@npa01zz001.simplot.com
Whole thread Raw
In response to dropdb to a remote host  (Alex Avriette <a_avriette@acs.org>)
List pgsql-general
I believe that dropdb simply connects to template1 and issues the
"drop database" command.  If you don't have access to the template1
database then you can't drop other databases.

Jason

Alex Avriette <a_avriette@acs.org> writes:

> when I do:
>
> /usr/local/pgsql/bin/dropdb -h myhost -U myuser dbname
>
> it complains that there isnt an entry in pg_hba.conf for 'template1', when i
> rather explicitly told it to drop 'dbname'. am i missing something?
>
> alex
>
> --
> alex j. avriette
> perl hacker.
> a_avriette@acs.org
> $dbh -> do('unhose');
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Behavior of nextval() and currval()
Next
From: "John Gray"
Date:
Subject: Re: xml support