Odd listen_addresses behavior

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Odd listen_addresses behavior
Date: 2017-03-15 19:46:14
Message-ID: 3dc43c56-88aa-f4c7-569f-217dcf9e6adf@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

-hackers,

I found this today:

jd(at)jd-wks:~/snap/postgresql96/common/data$
/snap/postgresql96/19/usr/bin/pg_ctl -D data stop
pg_ctl: directory "data" does not exist

jd(at)jd-wks:~/snap/postgresql96/common/data$ cd ..

jd(at)jd-wks:~/snap/postgresql96/common$
/snap/postgresql96/19/usr/bin/pg_ctl -D data stop
waiting for server to shut down...LOG: received fast shutdown request
.LOG: aborting any active transactions
LOG: autovacuum launcher shutting down
LOG: shutting down
LOG: database system is shut down
done
server stopped

jd(at)jd-wks:~/snap/postgresql96/common$ grep listen_addresses
data/postgresql.conf
listen_addresses = '192*' # what IP address(es) to listen on;

-- I wasn't actually expecting the above to work. I was just testing.

jd(at)jd-wks:~/snap/postgresql96/common$
/snap/postgresql96/19/usr/bin/pg_ctl -D data start
server starting

jd(at)jd-wks:~/snap/postgresql96/common$ postgresql96.psql -U jd -h
localhost postgres
psql (9.6.2)
Type "help" for help.

postgres=# show listen_addresses ;
listen_addresses
------------------
*
(1 row)

I grant that this is obscure but perhaps we should do something about it?

Thanks,

JD

--
Command Prompt, Inc. http://the.postgres.company/
+1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.
Everyone appreciates your honesty, until you are honest with them.
Unless otherwise stated, opinions are my own.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ashutosh Sharma 2017-03-15 19:54:26 Re: Microvacuum support for Hash Index
Previous Message Pavan Deolasee 2017-03-15 19:44:01 Re: Patch: Write Amplification Reduction Method (WARM)