Skip site navigation (1) Skip section navigation (2)

Re: BUG #4797: Uninstall : impossible to delete some files (base...)

From: Dave Page <dpage(at)pgadmin(dot)org>
To: "eric(dot)saudraix" <eric(dot)saudraix(at)laposte(dot)net>, Pg Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #4797: Uninstall : impossible to delete some files (base...)
Date: 2009-05-08 13:48:15
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
On Fri, May 8, 2009 at 2:17 PM, eric.saudraix <eric(dot)saudraix(at)laposte(dot)net> wrote:
> Thanks for your quick reply.
> I know I have to be the administrator of my data. Indeed, I am the
> administrator of my computer.
> On Linux it would not be a problem to find the key that leads to the
> problem.
> In fact to explain what's wrong : a database was created - or attempted to
> be created - with PostGreSQL. When I uninstall PostGreSql I didn't know I
> had to delete my database before I can uninstall this software. Now the

You don't have to delete the database before uninstalling - in fact,
many users rely on the fact that you don't.

> problem is Windows Vista thinks files of my database were created by an
> other user, who does not exist anymore. It is due to some security
> restrictions of NTFS. Consequently I can not delete the files. What can I do

The uninstallation process doesn't delete the user account that should
own the files - it has no way of knowing if you're using the account
for other installations.

To remove the old data directory, just take ownership of it and then
you can do whatever you like with it. There's a howto document here: (I'm
not that familiar with Vista, so don't know the specifics on that

> ? On Linux it is quite difficult to find the "user key", but on Vista I don
> not know what to do.

I don't know what you mean by 'user key'. There's a fundamental
difference between Linux and Windows though - on Linux, the root user
can do *anything*. On Windows, that is not the case for
administrators. File permissions can still keep them out of files,
requiring additional steps such as taking ownership to access them.

Dave Page
EnterpriseDB UK:

pgsql-bugs by date

Next:From: Tom LaneDate: 2009-05-08 15:33:32
Subject: Re: 42804: structure of query does not match error where using RETURN QUERY
Previous:From: Pavel StehuleDate: 2009-05-08 13:09:15
Subject: Re: 42804: structure of query does not match error where using RETURN QUERY

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group