It's just an example. I blow away my databases frequently [grin]. Also, I run postgres on a completely separate, dedicated server.
This particular script is run under the user "postgres". I create all three types of databases even though I don't yet use multi-tenant yet. On Thu, Nov 10, 2011 at 4:10 PM, Matt Warnock <[email protected]> wrote: > 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. > >
