Re: session username in default psql prompt?

2023-05-27 Thread Junwang Zhao
I'd like to take this if this is approved ;) On Sat, May 27, 2023 at 8:52 PM Andrew Dunstan wrote: > > I don't recall if this has come up before. > > I'm sometimes mildly annoyed when I get on a new system and find the username > missing in my psql prompt. Or if a customer shows me a screen and

Re: PG 16 draft release notes ready

2023-05-27 Thread Bruce Momjian
On Fri, May 26, 2023 at 12:21:23PM +0200, Álvaro Herrera wrote: > On 2023-May-25, Laurenz Albe wrote: > > > @@ -1335,7 +1335,7 @@ Author: Peter Eisentraut > > > > > > > > -Add Windows process the system collations (Jose Santamaria Flecha) > > +Add Windows to process the system collations

Re: PG 16 draft release notes ready

2023-05-27 Thread Bruce Momjian
On Thu, May 25, 2023 at 11:51:24PM +0200, Laurenz Albe wrote: > On Thu, 2023-05-18 at 16:49 -0400, Bruce Momjian wrote: > > I have completed the first draft of the PG 16 release notes. > > I found two typos. > diff --git a/doc/src/sgml/release-16.sgml b/doc/src/sgml/release-16.sgml > index

Re: PG 16 draft release notes ready

2023-05-27 Thread Bruce Momjian
On Thu, May 25, 2023 at 09:20:11PM +0100, Dagfinn Ilmari Mannsåker wrote: > Bruce Momjian writes: > > > I have completed the first draft of the PG 16 release notes. You can > > see the output here: > > > > https://momjian.us/pgsql_docs/release-16.html > > > > I will adjust it to the

abi-compliance-checker

2023-05-27 Thread Peter Geoghegan
Attached is a html report that was generated by a tool called abi-compliance-checker/abi-dumper [1][2] (by using "abi-compliance-checker -l libTest ... ") . I deliberately introduced 2 ABI compatibility issues affecting postgres, just to see what the tool had to say about it. The first ABI issue

Re: benchmark results comparing versions 15.2 and 16

2023-05-27 Thread MARK CALLAGHAN
Results for 16 beta1 are similar to what I shared above: * no regressions * a few queries are >= 1.5 times faster which make the read-only transaction >= 1.5 times faster http://smalldatum.blogspot.com/2023/05/postgres-16beta1-looks-good-vs-sysbench.html -- Mark Callaghan mdcal...@gmail.com

Document that server will start even if it's unable to open some TCP/IP ports

2023-05-27 Thread Gurjeet Singh
The attached patch clarifies that the server will start even if it is unable to open the port on some of the TCP/IP addresses listed (or implied by a value of '*' or localhost) in listen_addresses parameter. I think it is important to call this out, because I was surprised to see that the server

Re: testing dist tarballs

2023-05-27 Thread Andres Freund
Hi, On 2023-05-26 09:02:33 +0200, Peter Eisentraut wrote: > On 24.05.23 23:24, Andres Freund wrote: > > First thing I noticed that 'make dist' doesn't work in a vpath, failing in a > > somewhat obscure way (likely because in a vpath build the the copy from the > > source dir doesn't include

Re: Why does pg_bsd_indent need to be installed?

2023-05-27 Thread Andres Freund
Hi, On 2023-05-25 13:05:57 -0400, Tom Lane wrote: > Andres Freund writes: > > On 2023-05-25 09:09:45 -0400, Tom Lane wrote: > >> Peter Eisentraut writes: > >>> Why does pgindent require that pg_bsd_indent be installed in the path? > > > Isn't the situation actually *easier* in VPATH builds?

session username in default psql prompt?

2023-05-27 Thread Andrew Dunstan
I don't recall if this has come up before. I'm sometimes mildly annoyed when I get on a new system and find the username missing in my psql prompt. Or if a customer shows me a screen and I have to ask "which user is this". If we're dealing with several roles it can get confusing. My usual

Re: Implement generalized sub routine find_in_log for tap test

2023-05-27 Thread Andrew Dunstan
On 2023-05-26 Fr 20:35, vignesh C wrote: On Fri, 26 May 2023 at 04:09, Michael Paquier wrote: On Thu, May 25, 2023 at 06:34:20PM +0100, Dagfinn Ilmari Mannsåker wrote: However, none of the other functions in ::Utils know anything about node objects, which makes me think it should be a method