Posted by
Mike Z on
URL: http://ofbiz.116.s1.nabble.com/Installation-on-CentOS-5-6-with-PostgreSQL-tp4024345p4040117.html
Here is script that I used to use when I was flopping back/forth
between mysql and postgres.
#! /bin/bash
HOST=10.2.10.101
DB=ofbiz
USER=ofbiz
PASS=ofbiz
TYPE="psql"
#TYPE="mysql"
if [ "$TYPE" == "mysql" ]; then
mysql -h $HOST -u $USER -p$PASS -A -D $DB
else
export PGPASSWORD=$PASS
psql -h $HOST -U $USER -d $DB
fi
Postgres is annoying because you need to use an environment variable
(PGPASSWORD) in order to log in on the command line.
In your example, HOST would be set to localhost or 127.0.0.1.
On Mon, Nov 14, 2011 at 7:49 AM, champagroup
<
[hidden email]> wrote:
> Sorry for the long break between responses.
>
> Postgresql and ofbiz are on the same machine. I ran
>
> /psql -h localhost -U ofbiz ofbiz /
>
> But, I still get psql: FATAL: Ident authentication failed for user "ofbiz".
> I know there is a user ofbiz that I created. One thing that I noticed is
> that this command doesn't include the password for user ofbiz. Would that be
> necessary since I created the user with one?
>
> --
> View this message in context:
http://ofbiz.135035.n4.nabble.com/Installation-on-CentOS-5-6-with-PostgreSQL-tp4024345p4039872.html> Sent from the OFBiz - User mailing list archive at Nabble.com.
>