Re: [GENERAL] bloated postgres data folder, clean up

2016-03-04 Thread Rémi Cura
​Hey Julien, thanks for the original query ! ​ There was a slight mistake in the query, it was comparing the file name with pg_class.relfilenode. It is not safe in some case (see doc : "caution" in here ) , so better use the pg

Re: [GENERAL] bloated postgres data folder, clean up

2016-03-03 Thread Julien Rouhaud
On 03/03/2016 18:15, Rémi Cura wrote: > Hey, Hello Rémi, > first I forgot something in the querry to remove the annoying .XXX : > --- > SELECT distinct substring(file_name from '\d+' ) > FROM find_useless_postgres_file('your_database_name') ; > --- > Thanks for working on this :

Re: [GENERAL] bloated postgres data folder, clean up

2016-03-03 Thread Rémi Cura
; > ________ > > > > *Johnny Morano | Principal Systems Engineer* > > > > PAY.ON GmbH | AN ACI WORLDWIDE COMPANY | WWW.PAYON.COM > <http://www.payon.com/> > > Jakob-Haringer-Str. 1 | 5020 Salzburg | Aust

Re: [GENERAL] bloated postgres data folder, clean up

2016-03-02 Thread Johnny Morano
upon this information by unintended recipients is prohibited. Any opinions expressed in this email are those of the author personally. From: Rémi Cura [mailto:remi.c...@gmail.com] Sent: Mittwoch, 2. März 2016 17:49 To: Johnny Morano Cc: Alvaro Herrera; PostgreSQL General Subject: Re: [GENERAL]

Re: [GENERAL] bloated postgres data folder, clean up

2016-03-02 Thread Rémi Cura
ising as a result of > any virus being passed on or arising from any alteration of this message by > a third party. PAY.ON may monitor e-mails sent to and from PAY.ON. > > > > > > > > > > *From:* pgsql-general-ow...@postgresql.org [mailto: > pgsql-general-ow...@

Re: [GENERAL] bloated postgres data folder, clean up

2016-03-02 Thread Johnny Morano
o Herrera Cc: PostgreSQL General Subject: Re: [GENERAL] bloated postgres data folder, clean up Would gladly do it, but still this "wiki cooloff" stuff, can't create a page Cheers, Rémi-C 2016-02-29 20:44 GMT+01:00 Alvaro Herrera mailto:alvhe...@2ndquadrant.com>>: Rémi Cura w

Re: [GENERAL] bloated postgres data folder, clean up

2016-03-02 Thread Rémi Cura
Would gladly do it, but still this "wiki cooloff" stuff, can't create a page Cheers, Rémi-C 2016-02-29 20:44 GMT+01:00 Alvaro Herrera : > Rémi Cura wrote: > > Hey dear list, > > after a fex years of experiments and crash, > > I ended up with a grossly bloated postgres folder. > > I had about 8 Go

Re: [GENERAL] bloated postgres data folder, clean up

2016-02-29 Thread Alvaro Herrera
Rémi Cura wrote: > Hey dear list, > after a fex years of experiments and crash, > I ended up with a grossly bloated postgres folder. > I had about 8 Go of useless files. Would you add a new page to the wiki with this? https://wiki.postgresql.org/wiki/Category:Administrative_Snippets -- Álvaro H

Re: [GENERAL] bloated postgres data folder, clean up

2016-02-29 Thread Peter Devoy
> Hope this may be useful Thanks for sharing! Peter -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] bloated postgres data folder, clean up

2016-02-29 Thread Rémi Cura
Hey dear list, after a fex years of experiments and crash, I ended up with a grossly bloated postgres folder. I had about 8 Go of useless files. All is in a virtualbox, so I'm sure to be able to reproduce exactly, and fried my postgres folder a couple of time before getting it right. Julien (Rouha