Thread: pg_hba.conf on win32

pg_hba.conf on win32

From
David Bear
Date:
We have a system that someone setup on cygwin.  We are trying to locate where
the pg_hba.conf file is and found one but it doesn't seem that it is being
used.

How might we (1) locate which pg_hba.conf file postgres uses on cygwin and (2)
where pg is storing the data.  I looked into the environment but couldn't
find anything there.

Also, since postgres starts as a windows service, how does one put commandline
parms on the postmaster so that it listens to a socket.  Sorry about the
newbie questions but all the docs I found point to runing pg on various
unicies.
--
David Bear
College of Public Programs/ASU

Re: pg_hba.conf on win32

From
dima
Date:
 > How might we (1) locate which pg_hba.conf file postgres uses on
cygwin and (2)
 > where pg is storing the data.  I looked into the environment but
couldn't
 > find anything there.
1) try to copy pg_hba.conf.sample or pg_hba.conf (wherever it is @ your
host) to $PGHOME/data & edit it then.
2) database directories should be either @ $PGHOME/data/base or @
/var/lib/pgsql/data/base. well, i run postgresql on freebsd & so i don't
have a default directory for my databases; i use the one i ran initdb on
instead.

 > Also, since postgres starts as a windows service, how does one put
commandline
 > parms on the postmaster so that it listens to a socket.  Sorry about the
 > newbie questions but all the docs I found point to runing pg on various
 > unicies.
try to figure out what control_panel->services item contains ;)
it can be in the registry as well. i don't remember for sure since i
didn't use ms windows intenssively for about 5 years already.

try the following link for info on installing & tuning postgresql on ms
windows.
http://www.gnumed.org/documentation/user-manual/win9x.html



Re: pg_hba.conf on win32

From
Peter Eisentraut
Date:
David Bear writes:

> Also, since postgres starts as a windows service, how does one put commandline
> parms on the postmaster so that it listens to a socket.  Sorry about the
> newbie questions but all the docs I found point to runing pg on various
> unicies.

Consider reading the Administrator's Guide.

--
Peter Eisentraut   peter_e@gmx.net


Re: pg_hba.conf on win32

From
"working4aliving"
Date:
check out "un remming" a line in postgresql.conf (clue... the line has to do
with tcp/ip and it has the word false, which should be changed to true)

By the way, don't think that if it runs as a windows service, you can't pass
command line parms to it.


----- Original Message -----
From: "Peter Eisentraut" <peter_e@gmx.net>
To: <david.bear@asu.edu>
Cc: "pglist" <pgsql-admin@postgresql.org>
Sent: Wednesday, October 30, 2002 1:53 PM
Subject: Re: [ADMIN] pg_hba.conf on win32


> David Bear writes:
>
> > Also, since postgres starts as a windows service, how does one put
commandline
> > parms on the postmaster so that it listens to a socket.  Sorry about the
> > newbie questions but all the docs I found point to runing pg on various
> > unicies.
>
> Consider reading the Administrator's Guide.
>
> --
> Peter Eisentraut   peter_e@gmx.net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>