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.
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) |