Thread: Added comments to postgresql.conf file

Added comments to postgresql.conf file

From
Troels Arvin
Date:
I suggest that the following patch be applied. It adds a few more comments
to postgresql.conf.

(I always forget what the magic numbers 0 through 2 means for the "syslog"
option.)

By the way: The "virtual_host" parameter is a bad name for that particular
option, I think. "Virtual host" signals that PostgreSQL will behave
differently according to which IP address it's contacted (like Apache's
virtual host support which makes the web-server serve different sites
according to different criteria). A better word for the options would be
"tcpip_listen_addr" or something like that.

diff -ur pgsql/src/backend/utils/misc/postgresql.conf.sample troels-pgsql/src/backend/utils/misc/postgresql.conf.sample
--- pgsql/src/backend/utils/misc/postgresql.conf.sample    2003-07-27 20:14:50.000000000 +0200
+++ troels-pgsql/src/backend/utils/misc/postgresql.conf.sample    2003-07-27 20:24:07.000000000 +0200
@@ -37,7 +37,7 @@
 #unix_socket_directory = ''
 #unix_socket_group = ''
 #unix_socket_permissions = 0777    # octal
-#virtual_host = ''
+#virtual_host = ''        # what interface to listen on; defaults to any
 #rendezvous_name = ''        # defaults to the computer name

 # - Security & Authentication -
@@ -137,7 +137,7 @@

 # - Syslog -

-#syslog = 0            # range 0-2
+#syslog = 0            # range 0-2; 0=stdout; 1=both; 2=syslog
 #syslog_facility = 'LOCAL0'
 #syslog_ident = 'postgres'

--
Greetings from Troels Arvin, Copenhagen, Denmark


Re: Added comments to postgresql.conf file

From
Bruce Momjian
Date:
Patch applied.  Thanks.

---------------------------------------------------------------------------


Troels Arvin wrote:
> I suggest that the following patch be applied. It adds a few more comments
> to postgresql.conf.
>
> (I always forget what the magic numbers 0 through 2 means for the "syslog"
> option.)
>
> By the way: The "virtual_host" parameter is a bad name for that particular
> option, I think. "Virtual host" signals that PostgreSQL will behave
> differently according to which IP address it's contacted (like Apache's
> virtual host support which makes the web-server serve different sites
> according to different criteria). A better word for the options would be
> "tcpip_listen_addr" or something like that.
>
> diff -ur pgsql/src/backend/utils/misc/postgresql.conf.sample
troels-pgsql/src/backend/utils/misc/postgresql.conf.sample
> --- pgsql/src/backend/utils/misc/postgresql.conf.sample    2003-07-27 20:14:50.000000000 +0200
> +++ troels-pgsql/src/backend/utils/misc/postgresql.conf.sample    2003-07-27 20:24:07.000000000 +0200
> @@ -37,7 +37,7 @@
>  #unix_socket_directory = ''
>  #unix_socket_group = ''
>  #unix_socket_permissions = 0777    # octal
> -#virtual_host = ''
> +#virtual_host = ''        # what interface to listen on; defaults to any
>  #rendezvous_name = ''        # defaults to the computer name
>
>  # - Security & Authentication -
> @@ -137,7 +137,7 @@
>
>  # - Syslog -
>
> -#syslog = 0            # range 0-2
> +#syslog = 0            # range 0-2; 0=stdout; 1=both; 2=syslog
>  #syslog_facility = 'LOCAL0'
>  #syslog_ident = 'postgres'
>
> --
> Greetings from Troels Arvin, Copenhagen, Denmark
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
>                http://archives.postgresql.org
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073