Changes between Version 15 and Version 16 of UsersWikiPostGIS21UbuntuPGSQL93Apt

Timestamp:

Jun 21, 2015, 1:07:51 PM (9 years ago)

Author:

robe

Comment:

—

UsersWikiPostGIS21UbuntuPGSQL93Apt

@@ -74 +74 @@
 {{{
 CREATE EXTENSION adminpack;
+}}}
+
+-- find out where core files are located
+-- you may need to edit to pg_hba.conf allow external access 
+-- default location for pg_hba.conf is in folder 
+{{{
+SELECT name, setting FROM pg_settings where category='File Locations';
+}}
+
+Which will output something like:
+
+{{{
+
+       name        |                 setting
+-------------------+------------------------------------------
+ config_file       | /etc/postgresql/9.4/main/postgresql.conf
+ data_directory    | /var/lib/postgresql/9.4/main
+ external_pid_file | /var/run/postgresql/9.4-main.pid
+ hba_file          | /etc/postgresql/9.4/main/pg_hba.conf
+ ident_file        | /etc/postgresql/9.4/main/pg_ident.conf
+
 }}}