Re: failure on database drop

Merlin Moncure wrote:

>Had a failure dropping a database follow a crashed connection (crash was
>due to application error). Test was on win32 port d/l and compiled
>fresh this morning.
>
>Here is the psql log (immediately after the crash):
>data3=# \ctemplate1
>You are now connected to database "template1".
>template1=# drop database data3;
>WARNING: could not remove database directory
>"c:\postgres\data/base/17293"
>DETAIL: Failing system command was: rmdir /s /q
>"c:\postgres\data/base/17293"
>HINT: Look in the postmaster's stderr log for more information.
>DROP DATABASE
>
>Here is the postmaster log:
>LOG: could not receive data from client: No connection could be made
>because the target machine act
>ively refused it.
> LOG: could not receive data from client: No connection could be
>made because the target mac
>hine actively refused it.
>
>LOG: unexpected EOF on client connection
>
>LOG: unexpected EOF on client connection
>The directory is not empty.
>WARNING: could not remove database directory
>"c:\postgres\data/base/17293"
>DETAIL: Failing system command was: rmdir /s /q
>"c:\postgres\data/base/17293"
>HINT: Look in the postmaster's stderr log for more information.
>
>
>

The first thing I see is that the path has not been canonicalised ....
probably not the problem, but it needs to be fixed, I think.

cheers

andrew