Re: Installation on CentOS 5.6 with PostgreSQL

Posted by Mike Z on
URL: http://ofbiz.116.s1.nabble.com/Installation-on-CentOS-5-6-with-PostgreSQL-tp4024345p4030425.html

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
<[hidden email]> 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 <[hidden email]>
> RidgeCrest Herbals, Inc.
>
>