Re: [Chasers-general] running initial chasers scripts

[shua <shua@u.washington.edu>]

so that seems to do something. now i am getting tons of errors on teh
run such as:


> psql:/var/www/html/chasers/chasers-schema/schema.desc_abrc_locator.sql:16548: ERROR:  role "desc_abrc_lo" does not exist
> psql:/var/www/html/chasers/chasers-schema/schema.desc_abrc_locator.sql:16549: ERROR:  role "desc_abrc_lo" does not exist
> psql:/var/www/html/chasers/chasers-schema/schema.desc_abrc_locator.sql:16556: ERROR:  relation "user_login" does not exist
> psql:/var/www/html/chasers/chasers-schema/schema.desc_abrc_locator.sql:16557: ERROR:  relation "user_login" does not exist
> psql:/var/www/html/chasers/chasers-schema/schema.desc_abrc_locator.sql:16558: ERROR:  relation "user_login" does not exist
> psql:/var/www/html/chasers/chasers-schema/schema.desc_abrc_locator.sql:16565: ERROR:  relation "user_login_latest" does not exist
> psql:/var/www/html/chasers/chasers-schema/schema.desc_abrc_locator.sql:16566: ERROR:  relation "user_login_latest" does not exist
> psql:/var/www/html/chasers/chasers-schema/schema.desc_abrc_locator.sql:16567: ERROR:  relation "user_login_latest" does not exist
> REVOKE

i assume that this means i have to go through and change all such
identifiers to fit my db and users, or is there a shortcut? the
install.schemas does not have any explanation of this other than "If
your names are different, you may need to tweak these scripts."

j
On Tue, 2007-01-23 at 14:27 -0800, Jonathan Hedstrom wrote:
> 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