On Apr 18, 2008, at 2:00 PM, Bayless Kirtley wrote:
First, I am new to Postgres. I am hoping to migrate an existing Java application from a couple of tried but unreliable open source Java databases. I have a fair amount of experience with Oracle, Informix and DB2 but it has been a few years. No on to my problem.I finally got PostgreSQL installed on Windows XP as a service. After restarting the computer, the Task Manager shows 5 postgres.exe processes running. From a CMD window, I issue a pg_ctl status command and get the response: "No server running." What am I doing wrong. I took all the defaults on installation except for assigning a password rather than a random generated one.Earlier today, I had it installed as a program and all worked fine after creating and initializing the database cluster. I was able to start the database from a non-admin user. Then I could check status and even shutdown as an admin user. I have added the ...\bin directory to the PATH and added the PGDATA environment variable. After this, I decided to remove Postgres and reinstall it as a service.
I suspect that PGDATA might be set incorrectly; you should verify that. You can see what directory it's actually using by connecting and doing a SHOW data_directory;
-- Decibel!, aka Jim C. Nasby, Database Architect decibel@xxxxxxxxxxx Give your computer some brain candy! www.distributed.net Team #1828
<<attachment: smime.p7s>>
