Re: [GENERAL] starting PG command line options vs postgresql.con
On Mon, Oct 30, 2017 at 2:08 PM, David G. Johnston wrote: > On Mon, Oct 30, 2017 at 6:48 AM, rakeshkumar464 > wrote: >> >> I would prefer using postgresql.conf. what is the consensus in this forum >> regarding command line vs postgresql.conf. > > I suspect that most people administering a PostgreSQL database would expect > that the configuration file would be changed in lieu of passing options via > the command line. Disagreement here. For one, it makes pg_upgrade more complicated because it would need to track and then rewrite postgresql.conf, or just copy it temporarily. The current way of doing things gives the best of both worlds. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] starting PG command line options vs postgresql.con
On Mon, Oct 30, 2017 at 6:48 AM, rakeshkumar464 wrote: > I would prefer using postgresql.conf. what is the consensus in this forum > regarding command line vs postgresql.conf. I suspect that most people administering a PostgreSQL database would expect that the configuration file would be changed in lieu of passing options via the command line. Also if conflicting, which one > takes priority. > https://www.postgresql.org/docs/9.6/static/config-setting.html#AEN32498 David J.
Re: [GENERAL] starting PG command line options vs postgresql.con
rakeshkumar464 writes: > I am new to Docker env and I see that PG, as a container is started with > [ lots of command-line parameters ] > I would prefer using postgresql.conf. what is the consensus in this forum > regarding command line vs postgresql.conf. Also if conflicting, which one > takes priority. The command line takes priority, IIRC, which means that nothing set on the command line can be overridden without a restart. I like to specify -p on the command line so that it's easy to tell which postmaster is which in "ps" listings (of course, this only matters if you're running multiple postmasters). Otherwise it's better to leave as much as you can to postgresql.conf. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
[GENERAL] starting PG command line options vs postgresql.con
I am new to Docker env and I see that PG, as a container is started with parameters like this: docker run -it \ --detach \ --name name \ --restart=unless-stopped \ -p 5432:5432 \ -e PGDATA=/var/lib/postgresql/data/pg10 -N 500 \ -B 3GB \ -S 6291kB \ -c listen_addresses=* \ -c effective_cache_size=9GB \ -c maintenance_work_mem=768MB \ -c min_wal_size=2GB \ -c max_wal_size=4GB \ I would prefer using postgresql.conf. what is the consensus in this forum regarding command line vs postgresql.conf. Also if conflicting, which one takes priority. thanks -- Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general