Re: pg_hba.conf on win32

From: dima <_pppp(at)mail(dot)ru>
To: david(dot)bear(at)asu(dot)edu
Cc: pglist <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_hba.conf on win32
Date: 2002-10-30 13:36:32
Message-ID: 3DBFE060.4030205@mail.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2002-10-30 15:23:14 Re: postgres xlog crashes - recovery procedure
Previous Message Gareth Kirwan 2002-10-30 13:12:55 Re: Sequences