Re: [Chasers-general] software setup

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

Joshua Aaron Ginzler, PhD wrote:
> thanks jonathan. yes, the other runs were in error, which i realized when i
> went back to the log last night. all of this is always making sense to me,
> in that yesterday i kept searching and searching for permission_date in the
> system_user file. then i went looking for create language commands, but i
> couldn't make heads or tails of it all as far as edits.
>
> so i am to put that exact text with quotes at the command line:
> su -c "psql -f [file] marsptdb" postgres
>
>   
The exact text, except you would replace [file] with the path and name
of the schema file, and you might be better off starting with a fresh,
empty database, which you can easily do with:

su postgres
dropdb [dbname]
createdb -O mars [dbname]
> also, in the configuration file, i set a password phrase as you folks
> suggest in wiki as "false" instead of "md5". does that sound right since i
> am not setting the method as md5 in the pg_hba file? 
>   
This md5 field is unrelated to the pg_hba conf file md5, and should be
left as true (it basically tells CHASERS that user passwords are stored
as md5 hashes).
> as well in the pg_hba, you told me to replace language for the ipv4 but do i
> also need to do it for the ipv6?
>   
I don't think you need to do anything with the ipv6 stuff
> one last thing, in the pg_mail file i think i am supposed to insert my own
> mail server and data server. i believe my mail server is smtp.washington.edu
> (obviously outgoing server) whereas my incoming is personalized. so i put in
> the smtp address. for the data server i just put in localhost. 
>   
That should be fine...it's relatively easy to change later on if email
isn't working from CHASERS.

-Jonathan