Re: Problem upgrading from 10 to 14 with pg_upgrade: unexpected error upgrading "template1" database for some clusters

2022-07-12 Thread Laurenz Albe
On Wed, 2022-07-13 at 02:53 +, Ken Yeung wrote: > From: Laurenz Albe > Sent: Wednesday, July 13, 2022 3:16 AM > > > You configured "pg_hba.conf" so that a local login without password is > > not possible.  The easiest solution is to change the "pg_hba.conf" > > entries for "localhost" in IPv4

Re: Problem upgrading from 10 to 14 with pg_upgrade: unexpected error upgrading "template1" database for some clusters

2022-07-12 Thread Ken Yeung
Hi, From: Thomas Boussekey Sent: Tuesday, July 12, 2022 3:39 AM > Hi, > > Le lun. 11 juil. 2022 à 21:22, Ken Yeung a > > écrit : > > In the course of upgrading a bunch of database clusters from 10 to 14 using > > pg_upgrade tool, some databases result in the following error recorded in > > p

Re: PostgreSQL 14.4 ERROR: out of memory issues

2022-07-12 Thread Michael Paquier
On Mon, Jul 11, 2022 at 10:50:23AM +0200, Aleš Zelený wrote: > So far, it has happened three times (during a single week) from the 14.3 -> > 14.4 upgrade, before 14.4 we haven't suffered from such an issue. > > Questions: > 1) Can we safely downgrade from 14.4 to 14.3 by shutting down the instanc

Re: equivalent thing of mtr in mysql

2022-07-12 Thread Peter J. Holzer
On 2022-07-12 13:07:41 -0600, Rob Sargent wrote: > I thought OP was hinting at WAL stuff defn here So did I. hp -- _ | Peter J. Holzer| Story must make more sense than reality. |_|_) || | | | h...@hjp.at |-- Charles Stross, "Creative writing __/

Re: Problem upgrading from 10 to 14 with pg_upgrade: unexpected error upgrading "template1" database for some clusters

2022-07-12 Thread Laurenz Albe
On Mon, 2022-07-11 at 05:37 +, Ken Yeung wrote: > In the course of upgrading a bunch of database clusters from 10 to 14 using > pg_upgrade tool, some databases result in the following error recorded in > pg_upgrade_dump_1.log, such that cluster upgrade > fails. > FATAL:  password authenticati

Re: equivalent thing of mtr in mysql

2022-07-12 Thread Rob Sargent
On 7/12/22 12:57, Peter J. Holzer wrote: On 2022-07-12 22:39:31 +0800, merryok wrote: Hi, guys. I'm new here. I'm eager to figure out what is the equivalent thing of mtr in mysql in PG. What is MTR? A search for "mtr mysql" yields "mysql test run" and "multi-threaded replication", neither of w

Re: equivalent thing of mtr in mysql

2022-07-12 Thread Peter J. Holzer
On 2022-07-12 22:39:31 +0800, merryok wrote: > Hi, guys. I'm new here. > > I'm eager to figure out what is the equivalent thing of mtr in mysql in PG. What is MTR? A search for "mtr mysql" yields "mysql test run" and "multi-threaded replication", neither of which seems to be what you are talking

equivalent thing of mtr in mysql

2022-07-12 Thread merryok
Hi, guys. I'm new here. I'm eager to figure out what is the equivalent thing of mtr in mysql in PG. When a dml operation occurs, it may modify multiple pages and gererate multiple redo log records. mtr can make those logs atomically be transferred to log buffer and written to disk. I think sa