Re: dropdb to a remote host

From: Jason Earl <jason(dot)earl(at)simplot(dot)com>
To: Alex Avriette <a_avriette(at)acs(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: dropdb to a remote host
Date: 2001-11-13 22:02:41
Message-ID: 87n11qjpmm.fsf@npa01zz001.simplot.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)acs(dot)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(at)acs(dot)org
> $dbh -> do('unhose');
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Command Prompt, Inc. 2001-11-13 22:12:28 Practical PostgreSQL over 5,000 copies already!
Previous Message Bruce Momjian 2001-11-13 21:57:47 Re: dropdb to a remote host