From: johann at 2ndquadrant.com (Johann 'Myrkraverk' Oskarsson) Date: Fri, 24 Jun 2011 22:09:09 +0000 Subject: [Pljava-dev] Failed to create Java VM, WinXP In-Reply-To: (david sahagian's message of "Fri, 24 Jun 2011 15:49:59 -0400") References: Message-ID: writes: > () > I added the following entries to the PATH var: > > set PATH=%PATH%;C:\Program Files\Java\jre6\bin;C:\Program > Files\Java\jre6\bin\client Where do you apply these settings? The PATH with the Java installation has to be visible to the Postgres process. Going overly technical on you, the environment variables are cloned between processes in Unix systems. Process A sets X=V. It then spawns a new process B. This causes B to inherit all settings from A, including X=V. Process B sets X=W. On reading X, process A still has the value V. They are not shared. Process C spawned from B will now have X=W. It inherits the new settings from B. I've been told they behave exactly like this on Windows as well so it matters a lot where and how the PATH settings are applied so the Postgres server process, started as a Windows Service will read the new values. If you have another scripting language installed, you may be able to read the server process' environment. Or with a C module. -- Johann Oskarsson http://www.2ndquadrant.com/ |[] PostgreSQL Development, 24x7 Support, Training and Services --+-- | Blog: http://my.opera.com/myrkraverk/blog/