> > 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
