I have run into a problem with the vanilla pg_hba.conf with 7.34. While most
normal local operations work as they ought, I found that when attempting use
postgresqs from GRASS that an error was returned due to a problem with the
pg_hba.conf file. The error message is:

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

It seems to be a comment describing the datastructure that follows it. This
is the basic pg_hba.conf that is created when initdb is run and has not been
modified in any way.

I am running grass on the same system that I am running postgresql on and
there are no networking issues that I need to resolve, or at least I don't
think so.

John


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

John,

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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)

Does anyone know of a function that I can use to send HTML formatted email
from the database? Actually I currently use pgMail, but I cannot get it to
send HTML formatted email.

Thanks,
Derrick


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

When I place the HTML tags in the body of the email, I just get the tags
showing as text. Is this what you meant? I currently use a function to
create the concatenate the HTML and variables together, and then I pass that
string as the body of the email, but it is delivered as text.

Is there anything I should do that I am missing?

Thanks,
Derrick

----- Original Message -----
From: "V i s h a l Kashyap @ [Sai Hertz And Control Systems]"
<sank89 (AT) sancharnet (DOT) in>
To: "Derrick Betts" <Derrick (AT) grifflink (DOT) com>
Cc: <pgsql-novice (AT) postgresql (DOT) org>
Sent: Friday, February 20, 2004 3:55 PM
Subject: Re: [NOVICE] HTML email



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Dear Derrick Betts ,

HTML tag in a simple pgsql function.
If you want more help just pass on the text you want to mail

--
Best Regards,
Vishal Kashyap
Director / Lead Developer,
Sai Hertz And Control Systems Pvt Ltd,
http://saihertz.rediffblogs.com
Jabber IM: vishalkashyap (AT) jabber (DOT) org
ICQ : 264360076
-----------------------------------------------
You yourself, as much as anybody in the entire
universe, deserve your love and affection.
- Buddha
---------------
I am usually called as Vishal Kashyap
and my Girlfriend calls me Vishal CASH UP.
Because everyone loves me as Vishal Kashyap
and my Girlfriend loves me as CASH.
___
//\\\
( 0_0 )
----------------o0o-----o0o---------------------


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

On Fri, 20 Feb 2004, Derrick Betts wrote:

Read the standards as to what HTTP and HTML do? For me (and
emacs) HTTP/HTML can be strict. If what you generate for an
attachment is strict HTML, it should display in any browser. Or,
any browser which understands (or has HTML processing turned on).

For me, there is NO html formatted email. If you send HTML only,
it is spam. Include a text only version of what you send as the
main body.

Gord
--
Matter Realisations http://www.materialisations.com/
Gordon Haverland, B.Sc. M.Eng.. President
101 9504 182 St. NW Edmonton, AB, CA T5T 3A7
780/481-8019 ghaverla @ freenet.edmonton.ab.ca
780/993-1274 (alt.)


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

JWDougherty <jwdougherty (AT) mcihispeed (DOT) net> writes:
I've been trying to think of an explanation for this, but it's hard to
come up with one, if your pg_hba.conf is indeed factory-stock. Did you
build PG from source, or is it from somebody's RPM distribution? (Some
distributions supply modified pg_hba files.) For that matter, what
platform is this on anyway?

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org