Hi, Le lun. 26 avr. 2021 à 22:59, <luis.robe...@siscobra.com.br> a écrit :
> > ----- Mensagem original ----- > > De: "Alvaro Herrera" <alvhe...@alvh.no-ip.org> > > Para: "luis.roberto" <luis.robe...@siscobra.com.br> > > Cc: "pgsql-general" <pgsql-general@lists.postgresql.org> > > Enviadas: Segunda-feira, 26 de abril de 2021 17:45:34 > > Assunto: Re: DB size > > > I would guess that there are leftover files because of those crashes you > > mentioned. You can probably look for files in the database subdir in > > the data directory that do not appear in the pg_class.relfilenode > > listing for the database. > > > -- > > Álvaro Herrera 39°49'30"S 73°17'W > > <inflex> really, I see PHP as like a strange amalgamation of C, Perl, > Shell > > <crab> inflex: you know that "amalgam" means "mixture with mercury", > > more or less, right? > > <crab> i.e., "deadly poison" > > > Thanks Alvaro! > > That's what I read in an old thread, back in the 8.3 days... Can you point > me in the right direction as to where sould I look and how do I know which > files exactly are safe to remove? > > pg_orphaned is probably what you need. See https://github.com/bdrouvot/pg_orphaned for details. -- Guillaume.