Re: pg_repack and locks

2025-01-19 Thread Boris Zentner
janvier 2025 16:42 > À : nicolas > Cc : pgsql-general@lists.postgresql.org > Objet : Re: pg_repack and locks > >> On Mon, Jan 13, 2025 at 12:40:06PM +, nicolas wrote: >> Hello everyone, >> >> We are using postgresql v12 and added the pg_repack package >>

RE: pg_repack and locks

2025-01-19 Thread nicolas75_fr
d'origine- De : dep...@depesz.com Envoyé : lundi 13 janvier 2025 16:42 À : nicolas Cc : pgsql-general@lists.postgresql.org Objet : Re: pg_repack and locks On Mon, Jan 13, 2025 at 12:40:06PM +, nicolas wrote: > Hello everyone, > > We are using postgresql v12 and added

Re: pg_repack and locks

2025-01-13 Thread hubert depesz lubaczewski
On Mon, Jan 13, 2025 at 12:40:06PM +, nicolas wrote: > Hello everyone, > > We are using postgresql v12 and added the pg_repack package > > Since I cannot stop other process, I use the “--no-kill-backend” and > Pg_repack will wait indefinitly until pg_repack get the lock > > I get sometimes