pg_hba.conf on win32

Поиск
Список
Период
Сортировка
Искать

pg_hba.conf on win32

От:
David Bear <iddwb@moroni.pp.asu.edu>
Дата:
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

От:
dima <_pppp@mail.ru>
Дата:
 > 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

От:
Peter Eisentraut <peter_e@gmx.net>
Дата:
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

От:
"working4aliving" <working4aliving@hotmail.com>
Дата:
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" 
To: 
Cc: "pglist" 
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
>
FAQ