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

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
PAY.ON GmbH | AN ACI WORLDWIDE COMPANY | WWW.PAYON.COM > <http://www.payon.com/> > > Jakob-Haringer-Str. 1 | 5020 Salzburg | Austria > > > > This email message and any attachments may contain confidential, > proprietary or non-public information. This inf

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

2016-03-02 Thread Johnny Morano
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] bloated postgres data folder, clean up Hey, this is quite the *opposite*. The function find files in the postgres database folder that are not

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

2016-03-02 Thread Rémi Cura
s arising 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 <alvhe...@2ndquadrant.com<mailto:alvhe...@2ndquadrant

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

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

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