Labels

.net (1) *nix (1) administration (1) Android (2) Axis2 (2) best practice (5) big-data (1) business-analysis (1) code re-use (1) continuous-integration (1) Cordova-PhoneGap (1) database (2) defect (1) design (3) Eclipse (7) education (1) groovy (2) https (2) Hudson (4) Java (1) JAX-RS (2) Jersey (3) Jetty (1) localization (1) m2eclipse (2) MapForce (1) Maven (12) MySQL (1) Nexus (4) notes (4) OO (1) Oracle (4) performance (1) Perl (1) PL/SQL (1) podcast (1) PostgreSQL (1) requirement (1) scripting (1) serialization (1) shell (1) SoapUI (1) SQL (1) SSH (2) stored procedure (1) STS (2) Subclipse (1) Subversion (3) TOAD (3) Tomcat (4) UML (2) unit-testing (2) WAMP (1) WAS (3) Windows (3) WP8 (2) WTP (2) XML (4) XSLT (1)

Tuesday, August 16, 2011

PostgreSQL server starts up but then stops immediately

On Windows, starting through the Services window will indicate the above with a message similar to "The PostgreSQL Server 8.4 service on Local Computer started and then stopped.  Some services stop automatically if they have no work to do, for example, the Performance Logs and Alerts service".


Check the Event Viewer (shortcut:  Type "eventvwr" in Start > Run). In my situation, the data directory I specified at installation time appeared to not exist as indicated by the error message "FATAL:  data directory "XXXXXXXXXXXX" does not exist".  However it appears to be a permission problem, as the directory indeed existed. 
 
The easiest solution is to uninstall and reinstall and specify a directory that you know the postgres user ID will have no issues accessing (e.g. the default data directory suggested by the installer)

Tuesday, August 9, 2011

Maven project has errors in Eclipse (no changes were made)

Possible fixes:

  1. More common:  If Project > Build Automatically is checked off, do a Project > Clean on the problematic project.  Usually this fixes the issue.
  2. If compile errors persist, especially indicating dependencies that should be resolved by Maven, Project > Update All Maven Dependencies.  This may be needed if the local repository was moved; Eclipse may need to be refreshed of this.  
    • Speaking of which, after moving the Maven local repository, simply update the path in the settings.xml file in the .m2 directory in your home directory (e.g. C:\Documents and Settings\alan.leung\.m2 or ~/.m2 on *nix)