Re: pg_ctl question
От | Bender, Cheryl |
---|---|
Тема | Re: pg_ctl question |
Дата | |
Msg-id | D5DB5D0D27171247AFEC9648EE98752F032200DD@KCEX2KV1.mri-kc.int обсуждение исходный текст |
Ответ на | pg_ctl question ("Jeff Stout" <jstout@cctus.com>) |
Список | pgsql-admin |
<<I am able to set the database to start upon boot, but can not get pgAdmin to connect. >> The easiest way is to set it in postgresql.conf, which is put in your data folder when you run initdb. Near the beginning of the file you should see something like tcpip_socket=true port=5432 Except that these lines are commented out by default. Uncomment them and restart pgsql after saving this file. I almost forgot--If you haven't already done this, in order to connect from pgadmin you will also need to change your pg_hba.conf file as well to tell it what host(s) to allow. Here is a simple entry to allow all hosts on a subnet to connect to all databases #TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD host all all 192.168.0.0 255.255.255.0 trust Cheryl Bender
В списке pgsql-admin по дате отправления: