John,
> LOG: parse_hba: invalid syntax in pg_hba.conf file at line 45, token "TYPE"
> FATAL: Missing or erroneous pg_hba.conf file, see postmaster log for
details
>
> The problem is that line 45 reads as follows:
>
> # TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD
My guess is that something is messed up in the file, such as a wrong line
break character. Take a look at it in a good text editor, such as eMacs or
Vi or Kate.
Failing that, post the whole bottom section of the file.
--
-Josh Berkus
Aglio Database Solutions
San Francisco