Thread: BUG #5613: cannot delete
The following bug has been logged online: Bug reference: 5613 Logged by: Scott Email address: wheels7271@hotmail.com PostgreSQL version: 8.4 Operating system: vista Description: cannot delete Details: I have recently tried to install PostgreSQL to use with poker tracker. I have having problems connecting to the server, where then i was advised to completly remove and download again. I have come accross a file located in c:\programfilmes, called PostgresSQL. I am unable to delete this folder file, even when using CMD it says the file cannot be found. I then proceeded to open this file and delete the items individually to see what was left, all the files were able to delete except one: pg_stat_tmp Please could you help with this as i have spoke to comuter technichian company and they were unable to remove the file.
On Wed, Aug 11, 2010 at 1:41 PM, Scott <wheels7271@hotmail.com> wrote: > > The following bug has been logged online: > > Bug reference: =A0 =A0 =A05613 > Logged by: =A0 =A0 =A0 =A0 =A0Scott > Email address: =A0 =A0 =A0wheels7271@hotmail.com > PostgreSQL version: 8.4 > Operating system: =A0 vista > Description: =A0 =A0 =A0 =A0cannot delete > Details: > > I have recently tried to install PostgreSQL to use with poker tracker. I > have having problems connecting to the server, where then i was advised to > completly remove and download again. I have come accross a file located in > c:\programfilmes, called PostgresSQL. I am unable to delete this folder > file, even when using CMD it says the file cannot be found. I then procee= ded > to open this file and delete the items individually to see what was left, > all the files were able to delete except one: pg_stat_tmp =A0Please could= you > help with this as i have spoke to comuter technichian company and they we= re > unable to remove the file. I think you have a Windows program rather than a PostgreSQL problem. Based on my limited previous experience with Windows, problems like this are often caused by trying to delete a file while it's in use. Perhaps you need to stop the PostgreSQL service. An even better idea might be to uninstall PostgreSQL using Add/Remove Programs, or whatever uninstaller came with the installer you used. --=20 Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise Postgres Company
I already have done this but this file still remains. There is no problem w= ith windows, the compute is like new and runs everyting else smooth. This i= s the only problem i have ever had, i have even tried deleting the file thr= ough CMD but no luck it still will not delete. Can you tell me what the pg_= stat_tmp file is used for?=20 =20 > Date: Thu, 12 Aug 2010 16:39:54 -0400 > Subject: Re: [BUGS] BUG #5613: cannot delete > From: robertmhaas@gmail.com > To: wheels7271@hotmail.com > CC: pgsql-bugs@postgresql.org >=20 > On Wed, Aug 11, 2010 at 1:41 PM, Scott <wheels7271@hotmail.com> wrote: > > > > The following bug has been logged online: > > > > Bug reference: 5613 > > Logged by: Scott > > Email address: wheels7271@hotmail.com > > PostgreSQL version: 8.4 > > Operating system: vista > > Description: cannot delete > > Details: > > > > I have recently tried to install PostgreSQL to use with poker tracker. I > > have having problems connecting to the server, where then i was advised= to > > completly remove and download again. I have come accross a file located= in > > c:\programfilmes, called PostgresSQL. I am unable to delete this folder > > file, even when using CMD it says the file cannot be found. I then proc= eeded > > to open this file and delete the items individually to see what was lef= t, > > all the files were able to delete except one: pg_stat_tmp Please could= you > > help with this as i have spoke to comuter technichian company and they = were > > unable to remove the file. >=20 > I think you have a Windows program rather than a PostgreSQL problem. > Based on my limited previous experience with Windows, problems like > this are often caused by trying to delete a file while it's in use. > Perhaps you need to stop the PostgreSQL service. >=20 > An even better idea might be to uninstall PostgreSQL using Add/Remove > Programs, or whatever uninstaller came with the installer you used. >=20 > --=20 > Robert Haas > EnterpriseDB: http://www.enterprisedb.com > The Enterprise Postgres Company =20=09=09=20=09=20=20=20=09=09=20=20=
Scott Wheeler <wheels7271@hotmail.com> wrote: > Can you tell me what the pg_stat_tmp file is used for? It's not a file; it's a subdirectory. The statistics information is periodically written to a file within that subdirectory when PostgreSQL is running. I concur with prior advice -- make sure you don't have a postgres process running, and the rest is all Windows skills -- there should be nothing special caused by PostgreSQL. -Kevin