Re: [Chasers-general] running initial chasers scripts

[Jonathan H. <jhe...@de...>]

shua wrote:
>> [root@d-128-95-80-227 ~]# psql -U mars -f schema.desc_abrc_locator marsptdb
>> psql: FATAL:  Ident authentication failed for user "mars"
>>     
>
> does this mean that i have yet to get something properly loaded in so
> that my user can be recognized (authenticated?)?
>
>   

You'll need to edit /var/lib/pgsql/data/pg_hba.conf to allow connections
for this user, something like this should work:

#this will allow local connections w/o a password, change trust to md5
if you want password
local marsptdb mars trust

#this allows connections from localhost
host marsptdb mars 127.0.0.1/32 md5

Once you edit this file, you'll need to reload the configuration (from
the command line) :

/sbin/service postgresql reload

-Jonathan