smeserver-postgresql/contribs8/smeserver-postgresql-0.0.1.tcpip_socket.patch4

diff -Nur -x '*.orig' -x '*.rej' smeserver-postgresql-0.0.1/root/etc/e-smith/templates/var/lib/pgsql/data/postgresql.conf/tcpip_socket mezzanine_patched_smeserver-postgresql-0.0.1/root/etc/e-smith/templates/var/lib/pgsql/data/postgresql.conf/tcpip_socket
--- smeserver-postgresql-0.0.1/root/etc/e-smith/templates/var/lib/pgsql/data/postgresql.conf/tcpip_socket       2007-09-11 18:51:57.000000000 -0400
+++ mezzanine_patched_smeserver-postgresql-0.0.1/root/etc/e-smith/templates/var/lib/pgsql/data/postgresql.conf/tcpip_socket     2007-09-11 18:51:33.000000000 -0400
@@ -1,13 +1,21 @@
 {
     my $local = $postgresql{LocalNetworkingOnly} || 'yes';
+    my $access = $postgresql{access} || 'localhost';
     if (scalar </usr/share/doc/postgresql-7.*>)
     {
        $OUT = "tcpip_socket = ";
        $OUT .= ($local eq 'yes') ? 'false' : 'true';
+        unless ($access eq 'public')
+        {
+           $OUT .= "\nvirtual_host = ";
+           $OUT .= ($access eq 'private') ? "$LocalIP" : '127.0.0.1';
+        }
     }
     else
     {
        $OUT = "listen_addresses = ";
-       $OUT .= ($local eq 'yes') ? 'localhost' : "127.0.0.1,$LocalIP";
+       $OUT .= ($local eq 'yes') ? 'localhost' :
+               ($access eq 'public') ? '*' :
+                   ($access eq 'private') ? "127.0.0.1,$LocalIP" : '127.0.0.1';
     }
 }
1	unnilennium	1.1	diff -Nur -x '.orig' -x '.rej' smeserver-postgresql-0.0.1/root/etc/e-smith/templates/var/lib/pgsql/data/postgresql.conf/tcpip_socket mezzanine_patched_smeserver-postgresql-0.0.1/root/etc/e-smith/templates/var/lib/pgsql/data/postgresql.conf/tcpip_socket
2			--- smeserver-postgresql-0.0.1/root/etc/e-smith/templates/var/lib/pgsql/data/postgresql.conf/tcpip_socket 2007-09-11 18:51:57.000000000 -0400
3			+++ mezzanine_patched_smeserver-postgresql-0.0.1/root/etc/e-smith/templates/var/lib/pgsql/data/postgresql.conf/tcpip_socket 2007-09-11 18:51:33.000000000 -0400
4			@@ -1,13 +1,21 @@
5			{
6			my $local = $postgresql{LocalNetworkingOnly} \|\| 'yes';
7			+ my $access = $postgresql{access} \|\| 'localhost';
8			if (scalar </usr/share/doc/postgresql-7.*>)
9			{
10			$OUT = "tcpip_socket = ";
11			$OUT .= ($local eq 'yes') ? 'false' : 'true';
12			+ unless ($access eq 'public')
13			+ {
14			+ $OUT .= "\nvirtual_host = ";
15			+ $OUT .= ($access eq 'private') ? "$LocalIP" : '127.0.0.1';
16			+ }
17			}
18			else
19			{
20			$OUT = "listen_addresses = ";
21			- $OUT .= ($local eq 'yes') ? 'localhost' : "127.0.0.1,$LocalIP";
22			+ $OUT .= ($local eq 'yes') ? 'localhost' :
23			+ ($access eq 'public') ? '*' :
24			+ ($access eq 'private') ? "127.0.0.1,$LocalIP" : '127.0.0.1';
25			}
26			}