docs:postgres:postgres_notes

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
docs:postgres:postgres_notes [2007/10/07 00:11] billhdocs:postgres:postgres_notes [2008/08/03 00:25] (current) – external edit 127.0.0.1
Line 27: Line 27:
   * to access the db from another host, you must edit data/pg_hba.conf   * to access the db from another host, you must edit data/pg_hba.conf
     * to add a local subnet, use something like: host all all 192.168.0.0/24 md5     * to add a local subnet, use something like: host all all 192.168.0.0/24 md5
 +    * be careful with any lines ending with 'trust', because those hosts will be allowed access unconditionally, without asking for a password
 +  * to reload PostgreSQL, such as for configuration file changes, you can use:<code>
 +pg_ctl reload  [-D DATADIR] [-s]
 +</code>
  
 ===== Queries ===== ===== Queries =====
  • docs/postgres/postgres_notes.1191737495.txt.gz
  • Last modified: 2008/08/03 00:25
  • (external edit)