psql \du no more showing "member of" column

2023-10-13 Thread Luca Ferrari
Hi all, in version 16 psql does not show anymore the "member of" group information when showing users with \du. The query (still working fine) in previous versions was: SELECT r.rolname, r.rolsuper, r.rolinherit, r.rolcreaterole, r.rolcreatedb, r.rolcanlogin, r.rolconnlimit, r.rolvaliduntil, A

RE: Postgresql HA cluster

2023-10-13 Thread Jason Grammenos
Thank you for the feedback, I have used pacemaker for other purposes previously so am a little familiar with it. It appears that in this scenario pacemaker is being used to manage a floating ip as well as deal with split brain scenarios. What isn’t clear is how effective master-> master replica

Re: psql \du no more showing "member of" column

2023-10-13 Thread Ian Lawrence Barwick
2023年10月13日(金) 20:47 Luca Ferrari : > > Hi all, > in version 16 psql does not show anymore the "member of" group > information when showing users with \du. > > The query (still working fine) in previous versions was: > > SELECT r.rolname, r.rolsuper, r.rolinherit, > r.rolcreaterole, r.rolcreatedb,

Re: Postgresql HA cluster

2023-10-13 Thread Jehan-Guillaume de Rorthais
On Fri, 13 Oct 2023 12:02:53 + Jason Grammenos wrote: > Thank you for the feedback, > > I have used pacemaker for other purposes previously so am a little familiar > with it. So you might be familiar with shared-storage cluster, that are the simpler one you could deploy (baring you have a

Re: psql \du no more showing "member of" column

2023-10-13 Thread Luca Ferrari
On Fri, Oct 13, 2023 at 3:04 PM hubert depesz lubaczewski wrote: > > On Fri, Oct 13, 2023 at 01:39:17PM +0200, Luca Ferrari wrote: > > at least, as it is shown by `psql -E`. > > I wonder why this information has been removed, I'm not able to find > > this in the documentation. > > Release notes sh

Re: Question About PostgreSQL Extensibility

2023-10-13 Thread felix . quintgz
For the same reason that you can use python or perl in postgresql. It's just another language. I have .net code running on several sql servers and to change the database to postgresql I have to reprogram them. On Thursday, October 12, 2023 at 09:44:08 AM GMT-4, Laurenz Albe wrote: On Thu, 2

Re: psql \du no more showing "member of" column

2023-10-13 Thread Lele Gaifax
Ian Lawrence Barwick writes: > and also noted in the release notes: > > https://www.postgresql.org/docs/16/release-16.html#RELEASE-16-PSQL FWIW, I noticed a small typo in the relevant entry: s/informaion/information/ ciao, lele. -- nickname: Lele Gaifax | Dire che Emacs è "conveniente" è com

Re: Postgresql HA cluster

2023-10-13 Thread Laura Smith
--- Original Message --- On Friday, October 13th, 2023 at 14:10, Jehan-Guillaume de Rorthais wrote: > But really, double check first why a simple primary-standby architecture > doesn't > meet your needs. The simpler the architecture is, the better. Even from the > application point of

Re: psql \du no more showing "member of" column

2023-10-13 Thread Pavel Luzanov
Hi, On 13.10.2023 16:06, Ian Lawrence Barwick wrote: 2023年10月13日(金) 20:47 Luca Ferrari : Hi all, in version 16 psql does not show anymore the "member of" group information when showing users with \du. FWIW the explanation is in commit 0a1d2a7df8: https://git.postgresql.org/gitweb/?p=pos

JSON fields with backslashes

2023-10-13 Thread Greig Wise
Hello. I have run into an issue when using the copy command on tables with json columns where Postgres seems to improperly escape backslashes under certain conditions thus creating invalid JSON. Here is an example I have of the behavior: create table test_json(json_data json); insert into tes

Re: JSON fields with backslashes

2023-10-13 Thread David G. Johnston
On Fri, Oct 13, 2023 at 2:53 PM Greig Wise wrote: > Hello. I have run into an issue when using the copy command on tables > with json columns where Postgres seems to improperly escape backslashes > under certain conditions thus creating invalid JSON. Here is an example I > have of the behavior:

Re: JSON fields with backslashes

2023-10-13 Thread Tom Lane
Greig Wise writes: > Hello. I have run into an issue when using the copy command on tables > with json columns where Postgres seems to improperly escape backslashes > under certain conditions thus creating invalid JSON. AFAICS this is COPY's normal behavior: it doubles backslashes in the default

Re: psql \du no more showing "member of" column

2023-10-13 Thread hubert depesz lubaczewski
On Fri, Oct 13, 2023 at 01:39:17PM +0200, Luca Ferrari wrote: > at least, as it is shown by `psql -E`. > I wonder why this information has been removed, I'm not able to find > this in the documentation. Release notes show: https://why-upgrade.depesz.com/show?from=15.4&to=16&keywords=%5Cdu > Add

Re: JSON fields with backslashes

2023-10-13 Thread Erik Wienhold
On 2023-10-14 00:01 +0200, David G. Johnston write: > On Fri, Oct 13, 2023 at 2:53 PM Greig Wise wrote: > > > Hello. I have run into an issue when using the copy command on tables > > with json columns where Postgres seems to improperly escape backslashes > > under certain conditions thus creati