Re: To wim.bert...@ucll.be 2019-02-27 <20190227143731.gc25...@msg.df7cb.de>
> 4. Patch PostgreSQL such that it puts the port into external_pid_file,
> i.e. into /var/run/postgresql/11-main.pid
>
> The bottom line is that #4 looks most attractive, but I'm not fixing
> this in postgresql-common now.
: alter system set port ignored by
pg-commands
I was looking into several ideas that all have some problems.
0. Look into pg_settings
Doesn't work because we can only query the database if we already know
the port
1. Put the port on the postgres command line (postgres -p )
Works, but
I was looking into several ideas that all have some problems.
0. Look into pg_settings
Doesn't work because we can only query the database if we already know
the port
1. Put the port on the postgres command line (postgres -p )
Works, but then restarting the server is hard once the port got
Re: Wim Bertels 2019-02-26 <1551198329.5922.23.ca...@ucll.be>
> why are they different? if it's important that postgresql.auto.conf
> isn't readable by other, then why is postgresql.conf,
The problem is the PGDATA directory permissions, not so much the
permissions of the file. PG checks if the per
> But in actual practise, there is a problem, postgresql.auto.conf is
> stored inside PGDATA, which is not readable by anyone except postgres
> and root, so settings modified that way are only visible (and used)
> for these users.
ok, thank you for the clarification Christoph,
root and postgres do
Control: tag -1 moreinfo
Re: wim 2019-01-15 <154755510710.20704.3906668621163200728.reportbug@zwerfkat>
> 1. connect with psql to your local instance
> 2. use alter system to set the port to a non default port
> 3. restart postgresql
> 4. you will notice that pg_lsclusters still lists the old port
Source: postgresql-common
Severity: normal
Hallo,
this report is long overdue,
but i tested i today and still exists,
probably debian specific for --cluster version/db option
how to reproduce:
1. connect with psql to your local instance
2. use alter system to set the port to a non default port
3
7 matches
Mail list logo
