That assumes that the postgresql server is named "ofbiz" as well (which seems weird, I'd expect sql or dbms or something). It also assumes that postgres is configured to listen on its external host interfaces, and to respond to queries from the host where ofbiz is installed, neither of which is default behavior for postgresql.
Default behavior for postgres is that it only listens on localhost (127.0.0.*). So if "ofbiz" resolves to a real public or private host IP address (not localhost or 127.0.0.1), then postgres isn't listening. You can test with the numeric addresses to see if that is the issue. If you need to open postgres to listen on a non-localhost interface, change the "listen" line in /etc/postgresql/8.4/main/postgresql.conf. Is the postgresql server on the same server as the ofbiz install (i.e. localhost)? If so, you don't need to reconfigure postgresql, just change "-h ofbiz" to "-h localhost" in the line you gave, and it will probably just work, assuming that the ofbiz user and database exist. On Thu, 2011-11-10 at 15:26 -0800, champagroup wrote: > Well, it doesn't seem that I can. I ran > > psql -h ofbiz -U ofbiz ofbiz > > It seems that everything is ofbiz. Hmm. I don't know if that could be a > problem of not. Thoughts? > > -- > View this message in context: > http://ofbiz.135035.n4.nabble.com/Installation-on-CentOS-5-6-with-PostgreSQL-tp4024345p4029874.html > Sent from the OFBiz - User mailing list archive at Nabble.com. -- Matt Warnock <[email protected]> RidgeCrest Herbals, Inc.
