[Novice] questions on pg_hba.conf and stopping postmaster in cygwin

From: "Juliet May" <jmay(at)speark(dot)com>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: [Novice] questions on pg_hba.conf and stopping postmaster in cygwin
Date: 2002-04-08 21:43:30
Message-ID: 001401c1df46$6ea5d0f0$a1d2a8c0@sweetbeet2k
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi,

I installed postgresql using cygwin. I got everything up and going fine. I read a suggestion on a help page that said I should run the postmaster in a separate cygwin window. That works fine too, but do I need to leave the cygwin shell open continously in order for the database to run? If I do need to shut the shell down how do I stop postmaster? It continually posts error messages but I no longer have a cursor to type.

My second question relates to using pgadmin. I keep getting a syntax error in the pg_hba.conf file. I have it set up exactly as the documentation says. The error message is ('single quotes added by me')

'Missing or erroneous pg_hba.conf file'

The postmaster log says ' "arse_hba: invalid syntax in pg_hba.conf file at line 1, token "trust'

The first line in the pg_hba file says

'host all 127.0.0.1 255.255.255.255 trust'

I edited the pg_hba.conf file in notepad and I think that could be causing the error. Is there another option for editing the file that I should use?

Cygwin and postgresql are running on an NT server. I am running pgadmin on a W2K machine.

Any thoughts? TIA

Julie

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2002-04-08 22:30:05 Re: [Novice] questions on pg_hba.conf and stopping postmaster in cygwin
Previous Message Tom Lane 2002-04-08 20:09:34 Re: table vs. column constraints