Linux (Debian Woody), psql: Can't delete or create databases

Поиск
Список
Период
Сортировка
Искать

Linux (Debian Woody), psql: Can't delete or create databases

От:
Qbert@t-online.de (Phillip R. aka Qbert)
Дата:
Hi.
I'm having some serious trouble with Postgres on Debian Linux (3.0 aka 
Woody), and hope somebody can help.

The PostgreSQL DB Server I'm running is the default that comes with 
Debian Linux 3.0. From the Information the APT packaging tool can 
provide the version number is something between 7.0 and 7.2.
The postgresql-client (whatever that is..'psql'?) is the version 
7.1.1-4 and everything else seems to group around this version 
number.

Anyway, I've installed postgres and it seem to be running smooth. I 
can log onto the db-server (do you say that that way? 'log onto the 
db-server'?) using psql (client?, cli frontend?) and it seems 
coherent the way it manages user rights, as it won't let me log on in 
all scenarios, only in those where /etc/postgresql/pg_hba.conf would 
let me.

Along the line of setting up postgres I was able to create a db 
'elefant-data'. \l on psql outputs this:
>>>
template1-# \l
         List of databases
     Name     |  Owner   | Encoding
--------------+----------+----------
 elefant-data | postgres | LATIN9
 template0    | postgres | LATIN9
 template1    | postgres | LATIN9
(3 rows)
<<<

I was postive that I'd created elefant-data as user 'phillip', but 
that's a different story. From what I understand, it's a PIA to 
change useres for db's once they're created. Is that right?

Along witth the installation I installed the standard Debian Woody 
Linux 'jdbc' drivers and, after no effect, the odbc drivers.

Whatever I do it seems absolutely impossible to connect to the db via 
jdbc or odbc, no matter how. I've done all configuration possible 
with ODBCconfig - no light so far.
But then this:
I figured it's a user problem, so I thought it might be a good idea to 
drop my test-db elefant-data, and try to create a new one, this time 
making shure it'd be with the user it was intendend for - phillip.

It was then that I found out that I couldn't either create a new or 
drop an existing database, no matter which user was logged in via 
psql.

Where could this problem lie? Is my enviroment totally borked up and 
would you recommend a reinstall or should I look somewhere for the 
problem. And where would that be?

This has been going on for days, I by know though it would be the 
right thing to ask this question in this ML.

Thanks for your help in advance.

Phillip

Re: Linux (Debian Woody), psql: Can't delete or create databases

От:
Qbert@t-online.de (Phillip R. aka Qbert)
Дата:
Am Mittwoch, 25. Februar 2004 16:49 schrieb Phillip R. aka Qbert:
> TIP 6: Have you searched our
> list archives?
>  http://archives.postgresql.org

I just did, I returned a 'URL not found'.
I actually get that quite often using the search....

And results that return posts with URL cause those URL to return a 
'URL not found' aswell...

Phillip

Solution! (was: Re: Linux (Debian Woody)...)

От:
Qbert@t-online.de (Phillip R. aka Qbert)
Дата:
Am Mittwoch, 25. Februar 2004 16:49 schrieb Phillip R. aka Qbert:
>...
> I figured it's a user problem, so I thought it might be a good idea
> to drop my test-db elefant-data, and try to create a new one, this
> time making shure it'd be with the user it was intendend for -
> phillip.
>
> It was then that I found out that I couldn't either create a new or
> drop an existing database, no matter which user was logged in via
> psql.

I found out the following:
It's not possible to delete a database when logged on to the database 
server via psql.

Shouldn't this be documented somewhere?
Anybody from the documentation team here?

Phillip

Re: Solution! (was: Re: Linux (Debian Woody)...)

От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
Phillip R. aka Qbert wrote:
> I found out the following:
> It's not possible to delete a database when logged on to the database
> server via psql.
>
> Shouldn't this be documented somewhere?

It is.  Read the "Notes" section on this page:

http://www.postgresql.org/docs/7.4/static/sql-dropdatabase.html

Re: Solution! (was: Re: Linux (Debian Woody)...)

От:
Stephan Szabo <sszabo@megazone.bigpanda.com>
Дата:

On Fri, 27 Feb 2004, Phillip R. aka Qbert wrote:

> Am Mittwoch, 25. Februar 2004 16:49 schrieb Phillip R. aka Qbert:
> >...
> > I figured it's a user problem, so I thought it might be a good idea
> > to drop my test-db elefant-data, and try to create a new one, this
> > time making shure it'd be with the user it was intendend for -
> > phillip.
> >
> > It was then that I found out that I couldn't either create a new or
> > drop an existing database, no matter which user was logged in via
> > psql.
>
> I found out the following:
> It's not possible to delete a database when logged on to the database
> server via psql.
>
> Shouldn't this be documented somewhere?

7.4s interactive docs for DROP DATABASE has a statement in the
description, "Also, it cannot be executed while you or anyone else are
connected to the target database."
FAQ