Thread: BUG #6281: need to remove
The following bug has been logged online: Bug reference: 6281 Logged by: Jim Jackson Email address: jimjackson@judgefite.com PostgreSQL version: ?? Operating system: Windows 7 Description: need to remove Details: I need to remove the postgres from my PC. it does not work and has made certain files on my pc inaccessible.
On 11/02/2011 01:53 AM, Jim Jackson wrote: > > The following bug has been logged online: > > Bug reference: 6281 > Logged by: Jim Jackson > Email address: jimjackson@judgefite.com > PostgreSQL version: ?? > Operating system: Windows 7 > Description: need to remove > Details: > > I need to remove the postgres from my PC. it does not work and has made > certain files on my pc inaccessible. "Certain files" ? Which files, and where? Give their paths, eg "C:\Users\Fred\Desktop\abc.doc". This is interesting because of a recent discussion about the icacls command run by the installer, but more information would be necessary to help you. As for removal: use the add/remove programs to uninstall like you do any other program. If that doesn't work, provide the FULL ERROR MESSAGE you get (if any). Make sure to "reply all" to this email so the mailing list gets your reply. -- Craig Ringer
So do you have an answer to this issue??? I have not heard from anyone. Thanks Jim Jackson=20=20 Realtor Regional Sales Manager Century 21 Judge Fite Company Arlington Regional Office (817) 804-3282 Office (817) 233-2385 Cell -----Original Message----- From: Jim Jackson (817) 233-2385 [mailto:jimjackson@judgefite.com]=20 Sent: Wednesday, November 02, 2011 8:31 AM To: 'Craig Ringer' Cc: 'pgsql-bugs@postgresql.org' Subject: RE: [BUGS] BUG #6281: need to remove See attached screen shots. Two examples of the restriction that is cause by= this software. Postgres does not show in programs list for removal. What e= lse do you need to help? Thanks Jim Jackson Realtor Regional Sales Manager Century 21 Judge Fite Company Arlington Regional Office (817) 804-3282 Office (817) 233-2385 Cell -----Original Message----- From: Craig Ringer [mailto:ringerc@ringerc.id.au] Sent: Wednesday, November 02, 2011 4:39 AM To: Jim Jackson Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #6281: need to remove On 11/02/2011 01:53 AM, Jim Jackson wrote: > > The following bug has been logged online: > > Bug reference: 6281 > Logged by: Jim Jackson > Email address: jimjackson@judgefite.com > PostgreSQL version: ?? > Operating system: Windows 7 > Description: need to remove > Details: > > I need to remove the postgres from my PC. it does not work and has=20 > made certain files on my pc inaccessible. "Certain files" ? Which files, and where? Give their paths, eg "C:\Users\Fr= ed\Desktop\abc.doc". This is interesting because of a recent discussion about the icacls command= run by the installer, but more information would be necessary to help you. As for removal: use the add/remove programs to uninstall like you do any ot= her program. If that doesn't work, provide the FULL ERROR MESSAGE you get (= if any). Make sure to "reply all" to this email so the mailing list gets your reply. -- Craig Ringer
On Fri, Nov 4, 2011 at 11:30 AM, Jim Jackson (817) 233-2385 <jimjackson@judgefite.com> wrote: > So do you have an answer to this issue??? I have not heard from anyone. Your email with the attachments doesn't seem to have gotten through to the list. If you could perhaps answer the question in a text-format email, it would make it easier to help people. The symptoms that you are describing sound pretty odd to me. PostgreSQL is a database, not a piece of malware. How exactly did you install it in the first place? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
"Jim Jackson (817) 233-2385" <jimjackson@judgefite.com> wrote: > So do you have an answer to this issue??? I have not heard from > anyone. Your reply to Craig did not show up on the list. Did you "reply all" when you sent it? If you did, the screen shots you mentioned might perhaps have caused the post to be filtered as spam. Text versions in the post would probably be more useful than screen shots, if practicable. People will be better positioned to help you if they know the specific files (with path) that seem to be inaccessible, and what exact error you get on an attempt to access them. Also, it would help to know where you got the installer, and what version it was. -Kevin
Thank you for the response. I hope this is useful.
I downloaded it as part of a poker tracking software. I do not remember what
one when this started causing issues I removed that.
PostgreSQL 8.4.1
Two example file pathes;
C:\users\Jim\Local Settings
C:\users\postgres
Example of message
"C:\users\Jim\Local Settings is not accessible
Access Denied"
Thanks
Jim Jackson
Realtor
Regional Sales Manager
Century 21 Judge Fite Company
Arlington Regional Office
(817) 804-3282 Office
(817) 233-2385 Cell
-----Original Message-----
From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov]
Sent: Friday, November 04, 2011 11:14 AM
To: Jim Jackson (817) 233-2385; 'Craig Ringer'
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #6281: need to remove
"Jim Jackson (817) 233-2385" <jimjackson@judgefite.com> wrote:
> So do you have an answer to this issue??? I have not heard from
> anyone.
Your reply to Craig did not show up on the list. Did you "reply
all" when you sent it? If you did, the screen shots you mentioned
might perhaps have caused the post to be filtered as spam. Text
versions in the post would probably be more useful than screen
shots, if practicable.
People will be better positioned to help you if they know the
specific files (with path) that seem to be inaccessible, and what
exact error you get on an attempt to access them. Also, it would
help to know where you got the installer, and what version it was.
-Kevin
On Fri, Nov 4, 2011 at 12:39 PM, Jim Jackson (817) 233-2385 <jimjackson@judgefite.com> wrote: > Thank you for the response. I hope this is useful. > > I downloaded it as part of a poker tracking software. I do not remember w= hat > one when this started causing issues I removed that. Probably Holdem Manager. We get regular bug reports here about that software, even though we don't produce it or support it. I am going to go out on a limb here and say that the problem you're experiencing has nothing to do with PostgreSQL and everything to do with that poker-tracking software. It sounds to me like that software installed PostgreSQL when you installed it, and then didn't uninstall PostgreSQL when you uninstalled it. That's a problem with their installers, not PostgreSQL, and we have no control over those installers. > PostgreSQL 8.4.1 > > Two example file pathes; > > C:\users\Jim\Local Settings > > C:\users\postgres > > Example of message > > "C:\users\Jim\Local Settings is not accessible > > =A0 =A0 =A0 =A0Access Denied" That's pretty annoying, but it's not PostgreSQL's fault. Our server doesn't change any permissions. Our installers might, but probably not on those directories, and you didn't use our installers anyway; you used something provided by Holdem Manager, and I think you need to complain to them, not us. --=20 Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
"Jim Jackson (817) 233-2385" <jimjackson@judgefite.com> wrote: > The postgreSQL was a separate installation step that had to be > done separately from the poker software load to support the poker > software. The question is, where did you get the installation software for that step? If you got it from the poker software provider, it is probably something nobody on this list has ever seen. We would like to help you if we could, but it doesn't sound like it is our software causing you the problems. When you download software from somewhere, the download source is where you should go with problems with it. We have no special knowledge of what their installer does. I see that while I've been typing this you asked whether re-installing would help. Again, if it's not an installer we've seen, so we don't know. The right people to be asking are the people you got it from. -Kevin
"Jim Jackson (817) 233-2385" <jimjackson@judgefite.com> wrote: > Does any of that help determine how to get rid of it? It appears that they copied some documentation to your hard drive. I imagine those pages look something like these: http://www.postgresql.org/docs/8.4/static/release.html http://www.postgresql.org/docs/8.4/static/index.html I imagine that they also copied in software that people on this list have developed as well as software of their own. None of that really provides any clue about why they would have done anything to lock down certain directories or how they did it. If the people that supplied the installer aren't responding, you could probably engage consultants who could dig through your registry and clean things up. To describe how the people on this list fit into the situation, we provide a tool -- the PostgreSQL database -- which others can use for whatever they want. Let's compare that to a television set. Someone else put together some sort of black box with one of those television sets, to provide certain programming. By running their installer, you invited them into your living room to build one of those boxes with our TV in it. We've never seen their programming and know nothing about their box or how they bolt it into your house. Now you want it out of your house and you can't cut through their bolts. Just because they locked one of our TVs in the box doesn't mean we know anything about how to get the box out of your house. You either need to call the folks who put in the black box about how to take it out, or hire someone who has the tools and knowledge to do it. -Kevin
The postgreSQL was a separate installation step that had to be done separately from the poker software load to support the poker software. After it was loaded it would not respond to the passwords that were provided so neither functioned. I did not bother with it for a while then realized I no longer have access to my files such as my Outlook.pst file that are in the Local Settings directory.=20=20 Are you saying there is no other way to get rid of this? Thanks Jim Jackson=20=20 Realtor Regional Sales Manager Century 21 Judge Fite Company Arlington Regional Office (817) 804-3282 Office (817) 233-2385 Cell -----Original Message----- From: Robert Haas [mailto:robertmhaas@gmail.com]=20 Sent: Friday, November 04, 2011 2:46 PM To: Jim Jackson (817) 233-2385 Cc: Kevin Grittner; Craig Ringer; pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #6281: need to remove On Fri, Nov 4, 2011 at 12:39 PM, Jim Jackson (817) 233-2385 <jimjackson@judgefite.com> wrote: > Thank you for the response. I hope this is useful. > > I downloaded it as part of a poker tracking software. I do not remember what > one when this started causing issues I removed that. Probably Holdem Manager. We get regular bug reports here about that software, even though we don't produce it or support it. I am going to go out on a limb here and say that the problem you're experiencing has nothing to do with PostgreSQL and everything to do with that poker-tracking software. It sounds to me like that software installed PostgreSQL when you installed it, and then didn't uninstall PostgreSQL when you uninstalled it. That's a problem with their installers, not PostgreSQL, and we have no control over those installers. > PostgreSQL 8.4.1 > > Two example file pathes; > > C:\users\Jim\Local Settings > > C:\users\postgres > > Example of message > > "C:\users\Jim\Local Settings is not accessible > > =A0 =A0 =A0 =A0Access Denied" That's pretty annoying, but it's not PostgreSQL's fault. Our server doesn't change any permissions. Our installers might, but probably not on those directories, and you didn't use our installers anyway; you used something provided by Holdem Manager, and I think you need to complain to them, not us. --=20 Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
If I were to reload postgreSQL would it over ride the current software on my PC and allow proper access to the files inside the postgre directory? Thanks Jim Jackson=20=20 Realtor Regional Sales Manager Century 21 Judge Fite Company Arlington Regional Office (817) 804-3282 Office (817) 233-2385 Cell -----Original Message----- From: Robert Haas [mailto:robertmhaas@gmail.com]=20 Sent: Friday, November 04, 2011 2:46 PM To: Jim Jackson (817) 233-2385 Cc: Kevin Grittner; Craig Ringer; pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #6281: need to remove On Fri, Nov 4, 2011 at 12:39 PM, Jim Jackson (817) 233-2385 <jimjackson@judgefite.com> wrote: > Thank you for the response. I hope this is useful. > > I downloaded it as part of a poker tracking software. I do not remember what > one when this started causing issues I removed that. Probably Holdem Manager. We get regular bug reports here about that software, even though we don't produce it or support it. I am going to go out on a limb here and say that the problem you're experiencing has nothing to do with PostgreSQL and everything to do with that poker-tracking software. It sounds to me like that software installed PostgreSQL when you installed it, and then didn't uninstall PostgreSQL when you uninstalled it. That's a problem with their installers, not PostgreSQL, and we have no control over those installers. > PostgreSQL 8.4.1 > > Two example file pathes; > > C:\users\Jim\Local Settings > > C:\users\postgres > > Example of message > > "C:\users\Jim\Local Settings is not accessible > > =A0 =A0 =A0 =A0Access Denied" That's pretty annoying, but it's not PostgreSQL's fault. Our server doesn't change any permissions. Our installers might, but probably not on those directories, and you didn't use our installers anyway; you used something provided by Holdem Manager, and I think you need to complain to them, not us. --=20 Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Can you tell anything from these documents? postgreSQL release notes.url PostgreSQL documentation.url Thanks Jim Jackson Realtor Regional Sales Manager Century 21 Judge Fite Company Arlington Regional Office (817) 804-3282 Office (817) 233-2385 Cell -----Original Message----- From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov] Sent: Friday, November 04, 2011 3:19 PM To: Jim Jackson (817) 233-2385 Cc: pgsql-bugs@postgresql.org; 'Craig Ringer' Subject: RE: [BUGS] BUG #6281: need to remove "Jim Jackson (817) 233-2385" <jimjackson@judgefite.com> wrote: > The postgreSQL was a separate installation step that had to be > done separately from the poker software load to support the poker > software. The question is, where did you get the installation software for that step? If you got it from the poker software provider, it is probably something nobody on this list has ever seen. We would like to help you if we could, but it doesn't sound like it is our software causing you the problems. When you download software from somewhere, the download source is where you should go with problems with it. We have no special knowledge of what their installer does. I see that while I've been typing this you asked whether re-installing would help. Again, if it's not an installer we've seen, so we don't know. The right people to be asking are the people you got it from. -Kevin
Can you tell anything from these documents? postgreSQL release notes.url PostgreSQL documentation.url Thanks Jim Jackson Realtor Regional Sales Manager Century 21 Judge Fite Company Arlington Regional Office (817) 804-3282 Office (817) 233-2385 Cell -----Original Message----- From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov] Sent: Friday, November 04, 2011 3:19 PM To: Jim Jackson (817) 233-2385 Cc: pgsql-bugs@postgresql.org; 'Craig Ringer' Subject: RE: [BUGS] BUG #6281: need to remove "Jim Jackson (817) 233-2385" <jimjackson@judgefite.com> wrote: > The postgreSQL was a separate installation step that had to be > done separately from the poker software load to support the poker > software. The question is, where did you get the installation software for that step? If you got it from the poker software provider, it is probably something nobody on this list has ever seen. We would like to help you if we could, but it doesn't sound like it is our software causing you the problems. When you download software from somewhere, the download source is where you should go with problems with it. We have no special knowledge of what their installer does. I see that while I've been typing this you asked whether re-installing would help. Again, if it's not an installer we've seen, so we don't know. The right people to be asking are the people you got it from. -Kevin
PostgreSQL 8.4.1 Documentation Prev Fast Backward Fast Forward Next ---------------------------------------------------------------------------- ---- Appendix D. SQL Conformance Table of ContentsD.1. Supported FeaturesD.2. Unsupported Features This section attempts to outline to what extent PostgreSQL conforms to the current SQL standard. The following information is not a full statement of conformance, but it presents the main topics in as much detail as is both reasonable and useful for users. The formal name of the SQL standard is ISO/IEC 9075 "Database Language SQL". A revised version of the standard is released from time to time; the most recent update appearing in 2008. The 2008 version is referred to as ISO/IEC 9075:2008, or simply as SQL:2008. The versions prior to that were SQL:2003, SQL:1999, and SQL-92. Each version replaces the previous one, so claims of conformance to earlier versions have no official merit. PostgreSQL development aims for conformance with the latest official version of the standard where such conformance does not contradict traditional features or common sense. The PostgreSQL project is not represented in the ISO/IEC 9075 Working Group during the preparation of the SQL standard releases, but even so, many of the features required by the SQL standard are supported, though sometimes with slightly differing syntax or function. Further moves towards conformance can be expected over time. SQL-92 defined three feature sets for conformance: Entry, Intermediate, and Full. Most database management systems claiming SQL standard conformance were conforming at only the Entry level, since the entire set of features in the Intermediate and Full levels was either too voluminous or in conflict with legacy behaviors. Starting with SQL:1999, the SQL standard defines a large set of individual features rather than the ineffectively broad three levels found in SQL-92. A large subset of these features represents the "Core" features, which every conforming SQL implementation must supply. The rest of the features are purely optional. Some optional features are grouped together to form "packages", which SQL implementations can claim conformance to, thus claiming conformance to particular groups of features. The SQL:2008 and SQL:2003 standard versions are also split into a number of parts. Each is known by a shorthand name. Note that these parts are not consecutively numbered. . ISO/IEC 9075-1 Framework (SQL/Framework) . ISO/IEC 9075-2 Foundation (SQL/Foundation) . ISO/IEC 9075-3 Call Level Interface (SQL/CLI) . ISO/IEC 9075-4 Persistent Stored Modules (SQL/PSM) . ISO/IEC 9075-9 Management of External Data (SQL/MED) . ISO/IEC 9075-10 Object Language Bindings (SQL/OLB) . ISO/IEC 9075-11 Information and Definition Schemas (SQL/Schemata) . ISO/IEC 9075-13 Routines and Types using the Java Language (SQL/JRT) . ISO/IEC 9075-14 XML-related specifications (SQL/XML) The PostgreSQL core covers parts 1, 2, 9, 11, and 14. Part 3 is covered by the ODBC driver, and part 13 is covered by the PL/Java plug-in, but exact conformance is currently not being verified for these components. There are currently no implementations of parts 4 and 10 for PostgreSQL. PostgreSQL supports most of the major features of SQL:2008. Out of 179 mandatory features required for full Core conformance, PostgreSQL conforms to at least 160. In addition, there is a long list of supported optional features. It might be worth noting that at the time of writing, no current version of any database management system claims full conformance to Core SQL:2008. In the following two sections, we provide a list of those features that PostgreSQL supports, followed by a list of the features defined in SQL:2008 which are not yet supported in PostgreSQL. Both of these lists are approximate: There might be minor details that are nonconforming for a feature that is listed as supported, and large parts of an unsupported feature might in fact be implemented. The main body of the documentation always contains the most accurate information about what does and does not work. Note: Feature codes containing a hyphen are subfeatures. Therefore, if a particular subfeature is not supported, the main feature is listed as unsupported even if some other subfeatures are supported. ---------------------------------------------------------------------------- ---- Prev Home Next SQL Key Words Up Thanks Jim Jackson Realtor Regional Sales Manager Century 21 Judge Fite Company Arlington Regional Office (817) 804-3282 Office (817) 233-2385 Cell -----Original Message----- From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov] Sent: Friday, November 04, 2011 3:19 PM To: Jim Jackson (817) 233-2385 Cc: pgsql-bugs@postgresql.org; 'Craig Ringer' Subject: RE: [BUGS] BUG #6281: need to remove "Jim Jackson (817) 233-2385" <jimjackson@judgefite.com> wrote: > The postgreSQL was a separate installation step that had to be > done separately from the poker software load to support the poker > software. The question is, where did you get the installation software for that step? If you got it from the poker software provider, it is probably something nobody on this list has ever seen. We would like to help you if we could, but it doesn't sound like it is our software causing you the problems. When you download software from somewhere, the download source is where you should go with problems with it. We have no special knowledge of what their installer does. I see that while I've been typing this you asked whether re-installing would help. Again, if it's not an installer we've seen, so we don't know. The right people to be asking are the people you got it from. -Kevin
Does any of that help determine how to get rid of it? Thanks Jim Jackson Realtor Regional Sales Manager Century 21 Judge Fite Company Arlington Regional Office (817) 804-3282 Office (817) 233-2385 Cell -----Original Message----- From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov] Sent: Friday, November 04, 2011 3:19 PM To: Jim Jackson (817) 233-2385 Cc: pgsql-bugs@postgresql.org; 'Craig Ringer' Subject: RE: [BUGS] BUG #6281: need to remove "Jim Jackson (817) 233-2385" <jimjackson@judgefite.com> wrote: > The postgreSQL was a separate installation step that had to be > done separately from the poker software load to support the poker > software. The question is, where did you get the installation software for that step? If you got it from the poker software provider, it is probably something nobody on this list has ever seen. We would like to help you if we could, but it doesn't sound like it is our software causing you the problems. When you download software from somewhere, the download source is where you should go with problems with it. We have no special knowledge of what their installer does. I see that while I've been typing this you asked whether re-installing would help. Again, if it's not an installer we've seen, so we don't know. The right people to be asking are the people you got it from. -Kevin
PostgreSQL 8.4.1 Documentation The PostgreSQL Global Development Group Copyright C 1996-2009 The PostgreSQL Global Development Group ---------------------------------------------------------------------------- ---- Table of ContentsPrefaceWhat is PostgreSQL?A Brief History of PostgreSQLConventionsFurther InformationBug Reporting GuidelinesI. Tutorial1. Getting Started2. The SQL Language3. Advanced FeaturesII. The SQL Language4. SQL Syntax5. Data Definition6. Data Manipulation7. Queries8. Data Types9. Functions and Operators10. Type Conversion11. Indexes12. Full Text Search13. Concurrency Control14. Performance TipsIII. Server Administration15. Installation from Source Code16. Installation from Source Code on Windows17. Server Setup and Operation18. Server Configuration19. Client Authentication20. Database Roles and Privileges21. Managing Databases22. Localization23. Routine Database Maintenance Tasks24. Backup and Restore25. High Availability, Load Balancing, and Replication26. Monitoring Database Activity27. Monitoring Disk Usage28. Reliability and the Write-Ahead Log29. Regression TestsIV. Client Interfaces30. libpq - C Library31. Large Objects32. ECPG - Embedded SQL in C33. The Information SchemaV. Server Programming34. Extending SQL35. Triggers36. The Rule System37. Procedural Languages38. PL/pgSQL - SQL Procedural Language39. PL/Tcl - Tcl Procedural Language40. PL/Perl - Perl Procedural Language41. PL/Python - Python Procedural Language42. Server Programming InterfaceVI. ReferenceI. SQL CommandsII. PostgreSQL Client ApplicationsIII. PostgreSQL Server ApplicationsVII. Internals43. Overview of PostgreSQL Internals44. System Catalogs45. Frontend/Backend Protocol46. PostgreSQL Coding Conventions47. Native Language Support48. Writing A Procedural Language Handler49. Genetic Query Optimizer50. Index Access Method Interface Definition51. GiST Indexes52. GIN Indexes53. Database Physical Storage54. BKI Backend Interface55. How the Planner Uses StatisticsVIII. AppendixesA. PostgreSQL Error CodesB. Date/Time SupportC. SQL Key WordsD. SQL ConformanceE. Release NotesF. Additional Supplied ModulesG. External ProjectsH. The CVS RepositoryI. DocumentationJ. AcronymsBibliographyIndex ---------------------------------------------------------------------------- ---- Next Thanks Jim Jackson Realtor Regional Sales Manager Century 21 Judge Fite Company Arlington Regional Office (817) 804-3282 Office (817) 233-2385 Cell -----Original Message----- From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov] Sent: Friday, November 04, 2011 3:19 PM To: Jim Jackson (817) 233-2385 Cc: pgsql-bugs@postgresql.org; 'Craig Ringer' Subject: RE: [BUGS] BUG #6281: need to remove "Jim Jackson (817) 233-2385" <jimjackson@judgefite.com> wrote: > The postgreSQL was a separate installation step that had to be > done separately from the poker software load to support the poker > software. The question is, where did you get the installation software for that step? If you got it from the poker software provider, it is probably something nobody on this list has ever seen. We would like to help you if we could, but it doesn't sound like it is our software causing you the problems. When you download software from somewhere, the download source is where you should go with problems with it. We have no special knowledge of what their installer does. I see that while I've been typing this you asked whether re-installing would help. Again, if it's not an installer we've seen, so we don't know. The right people to be asking are the people you got it from. -Kevin
On 11/04/11 1:07 PM, Jim Jackson (817) 233-2385 wrote: > The postgreSQL was a separate installation step that had to be done > separately from the poker software load to support the poker software. After > it was loaded it would not respond to the passwords that were provided so > neither functioned. I did not bother with it for a while then realized I no > longer have access to my files such as my Outlook.pst file that are in the > Local Settings directory. normally, postgresql creates and runs as its own special non-privileged user, typically called "postgres", and the only profile it would touch at all would be the profile for this "postgres" user (and, it hardly uses this). There's two levels of passwords involved, one for the system (windows) user "postgres", this password is only used to start the postgresql service in the windows service manager, and the other possible password is for the 'postgres' role within the postgresql database server (note that a SQL role/user is distinct from a system user, even if they have the same name). *nothing* any postgres installer I've ever seen should affect your Local Settings or your outlook.pst files. Now, I *have* seen Windows, when it gets particularly aggravated at something, decide that a user's profile is wonky, and go and create a new profile. if you were to look in the "C:\Documents and Settings" folder (on XP) or "C:\Users" (on Vista/Win7), you'd see like yourusername and yourusername.001 in this case, or something like that. Of course, windows does its best to keep you from even looking in there, as those are considered 'system folders' and they think they can keep stuff from getting messed up by hiding it from you. Doesn't make it any easier to fix when so much of the systems activity is hidden away. Sigh. this all conspires to make it really hard to help someone out remotely. -- john r pierce N 37, W 122 santa cruz ca mid-left coast
On 11/05/2011 04:09 AM, Jim Jackson (817) 233-2385 wrote: > If I were to reload postgreSQL would it over ride the current software on my > PC and allow proper access to the files inside the postgre directory? That's pretty unlikely. As you've already been told, the PostgreSQL installer doesn't change permissions for anything except the data directory. I guess if you put the datadir in your C:\Users\myname\Local Settings folder it could *add* access to that folder for the "postgres" user. It'd never remove access during installation, though, nor would it ever add or remove permissions for your normal user account. The first thing to do is fix your system's access permissions, anyway. Rather than assuming PostgreSQL broke them so PostgreSQL has to fix them, try fixing them yourself. Get properties on the Local Settings folder and in the Security tab add yourself with "full control" then apply the change to that folder and all folders within it. Apply the same procedure to any other folders you lack access to. Alternately, if you'd prefer you can do this en-masse on the command line. See: http://lallousx86.wordpress.com/2009/06/14/resetting-ntfs-files-security-and-permission-in-windows-7/ (I have not tested this and cannot verify that it is safe to do on a Windows drive with a C:\Windows and C:\Program Files directory. Use at your own risk.). As for PostgreSQL's involvement: Because there's both poker tracker / holdem and Pg involved, it's hard to know what happened. You haven't explained whether you got PostgreSQL from postgresql.org or from the poker tracker people. You haven't confirmed whether it's a standard PostgreSQL installer made by EnterpriseDB or whether it's some different, custom installer made by the poker tracker people. Without that, helping you is nearly impossible. If you can find the installer file for the version of PostgreSQL you installed and can report its file name and file size along with (if possible) where you downloaded it from, that might help. -- Craig Ringer
On Fri, Nov 4, 2011 at 4:07 PM, Jim Jackson (817) 233-2385 <jimjackson@judgefite.com> wrote: > The postgreSQL was a separate installation step that had to be done > separately from the poker software load to support the poker software. After > it was loaded it would not respond to the passwords that were provided so > neither functioned. I did not bother with it for a while then realized I no > longer have access to my files such as my Outlook.pst file that are in the > Local Settings directory. > > Are you saying there is no other way to get rid of this? Oh, I'm sure it's possible to get rid of it. I doubt that will magically fix your Access Denied errors, though. You haven't explained why you think those things are connected, and my guess is they aren't. People on this mailing list are going out of their way to help you because no one here wants you to walk away with a bad impression of PostgreSQL. But the fact is that you haven't really provided nearly enough information to actually help you. You've provided some out-takes from our manual, which proves that however you installed PostgreSQL, that process also installed the manual. But, uh, so what? If you had installed PostgreSQL using the usual PostgreSQL installers, you would be able to uninstall it using Add/Remove Programs. If you can't, then either you used some other installer or there's something else weird going on on your system. But if it was another installer, where did it come from? If there's something else screwed up on the machine, what is it? It's pretty well impossible for anyone on this mailing list to know those things. And even if we did, and could tell you how to get PostgreSQL uninstalled from your machine, I don't think that's going to fix the permissions on your home directory. My guess is that you've got a lot of random junk installed on this machine, not just PostgreSQL. That's partly based on what you've said, but mostly based on the fact that nearly every Windows machine I've ever seen has a lot of random junk installed on it. You might be better off taking it to your local computer shop, rather than consulting this mailing list. Somebody who can actually sit down in front of the computer can probably fix up whatever is wrong with it in an hour or two, or at least tell you what will be required to get it fixed. There are several people on this mailing list (not including me, I'm afraid) who are knowledgeable enough to talk you through fixing just about whatever you real problem is here, but whether they want to volunteer their time to fix a problem that's probably only tangentially related to PostgreSQL - if at all - I'm not sure. Getting someone knowledgeable to sit down in front of the computer and poke at it a bit seems likely to get you the results you are looking for quite a bit more quickly. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
I appreciate the efforts. Thanks Jim Jackson Realtor Regional Sales Manager Century 21 Judge Fite Company Arlington Regional Office (817) 804-3282 Office (817) 233-2385 Cell -----Original Message----- From: Robert Haas [mailto:robertmhaas@gmail.com] Sent: Sunday, November 06, 2011 12:35 AM To: Jim Jackson (817) 233-2385 Cc: Kevin Grittner; Craig Ringer; pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #6281: need to remove On Fri, Nov 4, 2011 at 4:07 PM, Jim Jackson (817) 233-2385 <jimjackson@judgefite.com> wrote: > The postgreSQL was a separate installation step that had to be done > separately from the poker software load to support the poker software. After > it was loaded it would not respond to the passwords that were provided so > neither functioned. I did not bother with it for a while then realized I no > longer have access to my files such as my Outlook.pst file that are in the > Local Settings directory. > > Are you saying there is no other way to get rid of this? Oh, I'm sure it's possible to get rid of it. I doubt that will magically fix your Access Denied errors, though. You haven't explained why you think those things are connected, and my guess is they aren't. People on this mailing list are going out of their way to help you because no one here wants you to walk away with a bad impression of PostgreSQL. But the fact is that you haven't really provided nearly enough information to actually help you. You've provided some out-takes from our manual, which proves that however you installed PostgreSQL, that process also installed the manual. But, uh, so what? If you had installed PostgreSQL using the usual PostgreSQL installers, you would be able to uninstall it using Add/Remove Programs. If you can't, then either you used some other installer or there's something else weird going on on your system. But if it was another installer, where did it come from? If there's something else screwed up on the machine, what is it? It's pretty well impossible for anyone on this mailing list to know those things. And even if we did, and could tell you how to get PostgreSQL uninstalled from your machine, I don't think that's going to fix the permissions on your home directory. My guess is that you've got a lot of random junk installed on this machine, not just PostgreSQL. That's partly based on what you've said, but mostly based on the fact that nearly every Windows machine I've ever seen has a lot of random junk installed on it. You might be better off taking it to your local computer shop, rather than consulting this mailing list. Somebody who can actually sit down in front of the computer can probably fix up whatever is wrong with it in an hour or two, or at least tell you what will be required to get it fixed. There are several people on this mailing list (not including me, I'm afraid) who are knowledgeable enough to talk you through fixing just about whatever you real problem is here, but whether they want to volunteer their time to fix a problem that's probably only tangentially related to PostgreSQL - if at all - I'm not sure. Getting someone knowledgeable to sit down in front of the computer and poke at it a bit seems likely to get you the results you are looking for quite a bit more quickly. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company