ADMINIII several minor problems in the process of connecting Linux PostgreSQL

1, postgresql.conf in the main configuration file to configure the PostgreSQL binding IP, if not set, may only be bound to the closed-loop address: 127.0.0.1, can be set to 0.0.0.0; it includes everything. IPV4 address

2, pg_hba.conf in the settings, the main is to add the connection client machine IP, and after the IP to add a/32,/32 is Ipv4, IPv6 is/128. Method is written directly password. Setting method reference:/HTTP Wiki.postgresql.org/wiki/9.1%e7%ac%ac%e5%8d%81%e4%b9%9d%e7%ab%a0

3, configuration modification, you can use the INIT.D directory in the startup script reload overload configuration, restart No, with it, the modified configuration cannot take effect,

4. To say the digression, I installed the PostgreSQL 9.2 version, if the machine installed on the vc++2008 package may lead to PostgreSQL ADMINIII and PostgreSQL service will not start

ADMINIII several minor problems in the process of connecting Linux PostgreSQL