Nuxeo Server Cannot Connect to PostgreSQL database

[BW1982_]

First installation failed to install JDK 7. I downloaded/installed the latest version manually from the Java.com website. Second install returned an error while configuring the PostgreSQL database, but the error message popped up and out too quickly for me to read during installation.

When starting the server, it returns an error (copy/pasted the text that was red in the log):

2013-03-12 14:20:01,527 ERROR [org.nuxeo.launcher.config.ConfigurationGenerator] org.postgresql.util.PSQLException: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections. 2013-03-12 14:20:01,528 ERROR [org.nuxeo.launcher.NuxeoLauncher] Could not run configuration: Failed to connect on database: Connection refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

This software could potentially solve a lot of things for my business. Any help would be appreciated.

[bruce_Grant]

Would be helpful to know your OS, version of Nuxeo, and in all likelihood the content of nuxeo.conf related to postgresql.

[BW1982_]

OS

[bruce_Grant]

First check to make sure that Postgresql is running as a service. If not then try and start it.

[BW1982_]

Strange. No service by the name of PostgreSQL is listed. Even stranger

[bruce_Grant]

It's been a while since I installed a Windows copy using the installer, but I recall there was a question to install Postgresql as part of the process (it may have been experimental at the time). Did you see this question and try to install Postgresql?

[BW1982_]

1. Yes, there was an option to also install PostgreSQL and I opted in.

[bruce_Grant]

Probably a good idea since it's clear that there was some hiccup in the original install.

[BW1982_ · Accepted solution]

Thanks to Bruce for his assistance in helping me identify the issue. Upon reinstalling each package individually, I was able to pinpoint the location of my problem: the default Windows PostgreSQL installation database location.

The PostgreSQL one-click installation pre-packaged with Nuxeo is actually problematic for Windows installs. On the PostgreSQL site I learned that when prompted to point the installation to a database location, you cannot use the default location provided. The default subdirectory name "9.6" within the installation directory (C:\Program Files\PostgreSQL\9.6) causes a conflict with the rest of the installation because of the "." in the subdirectory name. Instead, point the PostgreSQL install when it asks for a database directory location to C:\Data, or something within the proper Windows directory naming conventions for it to work.

When installing on a Windows system for users like me that aren't adept to development, download the JDK7 (Java Development Kit 7) from Java.com, then download the PostgreSQL from PostgreSQL.org and then install Nuxeo. It will already identify the existence of the other two components and will only install the core Nuxeo files.

[bruce_Grant]

Good to hear it's resolved!