> -----Original Message-----
> From: el dorado [mailto:do_ra_do@mail.ru]
> Sent: Thursday, July 08, 2010 3:47 AM
> To: pgsql-general@postgresql.org
> Subject: Re[2]: Problems with Vista and Windows 7
>
> > > 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\1612
> 3\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.
>
So, if you just use binaries (no registry entries created), could you
try to set PGDATA environment variable, and see if this helps?
Regards,
Igor Neyman