Thread: Malfunction in dropping database with pgAdmin
Platform: Windows XP, 5.1 (Build 2600).Language: Russain. Distribution used: Binary. pgAdmin version: 1.10.0. PostgreSQL version: 8.4.0-1. Bug description: When I use pgAdmin's menu command 'Delete/drop' to drop database, especially just created, PostgreSQL server reports: WARNING: could not remove file or directory "base/16435": Directory not empty WARNING: some useless files may be left behind in old database directory "base/16435". However, specified directory appears empty and I have to delete it manually. Database cluster is situated on local NTFS-drive (or local FAT-drive, just for the experiment). Note, that using dropdb.exe does not cause such a problem. I've already reported this to pgAdmin's support team, they replied it is PostgreSQL server that operates wrong...
On Tue, Aug 11, 2009 at 2:40 AM, Sergei Abramov<auspex@rambler.ru> wrote: > Platform: Windows XP, 5.1 (Build 2600).Language: Russain. > Distribution used: Binary. > pgAdmin version: 1.10.0. > PostgreSQL version: 8.4.0-1. > > Bug description: When I use pgAdmin's menu command 'Delete/drop' to drop > database, especially just created, PostgreSQL server reports: > WARNING: could not remove file or directory "base/16435": Directory not > empty > WARNING: some useless files may be left behind in old database directory > "base/16435". > > However, specified directory appears empty and I have to delete it manually. > Database cluster is situated on local NTFS-drive (or local FAT-drive, just > for the experiment). > Note, that using dropdb.exe does not cause such a problem. > I've already reported this to pgAdmin's support team, they replied it is > PostgreSQL server that operates wrong... Do you have a link to the email message from the pgadmin folks? I'd be curious what is causing this. ...Robert
On Fri, Aug 14, 2009 at 4:29 AM, Robert Haas<robertmhaas@gmail.com> wrote: > On Tue, Aug 11, 2009 at 2:40 AM, Sergei Abramov<auspex@rambler.ru> wrote: >> Platform: Windows XP, 5.1 (Build 2600).Language: Russain. >> Distribution used: Binary. >> pgAdmin version: 1.10.0. >> PostgreSQL version: 8.4.0-1. >> >> Bug description: When I use pgAdmin's menu command 'Delete/drop' to drop >> database, especially just created, PostgreSQL server reports: >> WARNING: could not remove file or directory "base/16435": Directory not >> empty >> WARNING: some useless files may be left behind in old database directory >> "base/16435". >> >> However, specified directory appears empty and I have to delete it manua= lly. >> Database cluster is situated on local NTFS-drive (or local FAT-drive, ju= st >> for the experiment). >> Note, that using dropdb.exe does not cause such a problem. >> I've already reported this to pgAdmin's support team, they replied it is >> PostgreSQL server that operates wrong... > > Do you have a link to the email message from the pgadmin folks? =A0I'd > be curious what is causing this. No link offhand, but what I said was that we just do a "drop database" via libpq, exactly the same as dropdb would do, or as would happen via psql. The only possible difference I could see was the database used for the connection, but that shouldn't make any difference. --=20 Dave Page EnterpriseDB UK: http://www.enterprisedb.com