Re[2]: [GENERAL] Problems with Vista and Windows 7

[el dorado]

  I've notice that in some special cases PG uses folder 
  %APPDATA% for Windows user 'postgres', instead of the 
  PostgreSQL-specific application data folder (f.e., 
  C:\PostgreSQL\8.4\data). It results in some unexpected bugs. 

 
 Could you please be more specific in describing what problems are you
 seeing on Win7?
 Regards, Igor Neyman 
 
 What files are being created in %APPDATA% for the postgres user? Or
 what's it looking for there that's causing issues?
 Craig Ringer

Thank you for your answers.
Well, the beginning of the story in details is here 
(http://archives.postgresql.org/pgsql-general/2010-06/msg01135.php). Shortly, I 
tried to use functions from my own dll, but got an error Could not open 
relation base\16123\16222: No such file or directory. Later I found out, using 
'Process Monitor', that for some reason process 'postgres.exe' looked for this 
relation not in 'C:\PostgreSQL\8.4\data\base\16123\16222' but in 
'C:\Users\postgres\AppData\Roaming\MyApplicationName\base\16123\16222' - 
certainly, there is no such file.


 Did you check, that registry key Data Directory is set properly in
 HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-8.4
 folder?
Usually I don't use standard Windows Installer but take binaries. So there is 
no such branch in registry. When I tried to make test and install it from 
Installer I got the same result. :( Data Directory was set to PG-specific 
application dir.

Regards, Marina.



-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re[2]: [GENERAL] Problems with Vista and Windows 7

[el dorado]

Thank you, Andrew, it's very interesting and cognitive article. 
Though it couldn't resolve my problem now. It looks like recommendations - 
where to put your application data. But I put my data in some definite location 
and postgres looks for it in another one - that's the strangeness of situation 
for me.

Regards, Marina.

 It is a vexed issue with Vista/Windows 7. 
 I found this somewhere on a blog on the web (it may help):
 
 Regards
Andrew


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general