Re: [GENERAL] postgres MultiXact 9.3 corruption resolved but advice needed

2016-10-16 Thread Yvonne Murphy
Thank you kindly for your reply, I've read that the wraparound has to do with the amount of files in pg_multicast/members. So once the wraparound error happens once will it keep recurring until we upgrade even though we've truncated most of the database, If we exported the db dropped it and

Re: [GENERAL] Query generator

2016-10-16 Thread Andreas Seltenreich
Vinicius Segalin writes: > 2016-09-29 16:32 GMT-03:00 Julien Rouhaud : > > > You should try sqlsmith (https://github.com/anse1/sqlsmith), which works > > very well. > > I had found this one before, but all I could get was queries using > "standard" tables, like the ones from pg_catalog and > in

Re: [GENERAL] custom average window function failure

2016-10-16 Thread Sebastian Luque
On Sat, 15 Oct 2016 22:24:31 -0400, Tom Lane wrote: > Sebastian Luque writes: >> Tom Lane wrote: >>> Are you in a position to apply patches? It's a one-line fix: >>> https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=dca25c2562199ce1e7e26367613912a8eadbbde8 >> I'd like to try

Re: [GENERAL] could not connect to server

2016-10-16 Thread Adrian Klaver
On 10/15/2016 09:09 PM, Antonio Silva wrote: Dear Adrian and Tom, thanks for your attention. I did an upgrade on Friday. I use to do this every week. Log file informed: 2016-10-15 06:15:20 BRT [995-1] FATAL: data directory "/var/lib/postgresql/9.5/main" has group or world access 2016-10-15 06

Re: [GENERAL] could not connect to server

2016-10-16 Thread Adrian Klaver
On 10/15/2016 09:09 PM, Antonio Silva wrote: Dear Adrian and Tom, thanks for your attention. I did an upgrade on Friday. I use to do this every week. Log file informed: 2016-10-15 06:15:20 BRT [995-1] FATAL: data directory "/var/lib/postgresql/9.5/main" has group or world access 2016-10-15 06

Re: [GENERAL] could not connect to server

2016-10-16 Thread Christoph Berg
Re: Antonio Silva 2016-10-16 > 2016-10-15 06:15:20 BRT [995-1] FATAL: data directory > "/var/lib/postgresql/9.5/main" has group or world access > 2016-10-15 06:15:20 BRT [995-2] DETAIL: Permissions should be u=rwx (0700). > > The problem with permissions was already indicated to .pgpass Hi,

Re: [GENERAL] Query generator

2016-10-16 Thread Vinicius Segalin
2016-10-16 8:54 GMT-02:00 Andreas Seltenreich : > Vinicius Segalin writes: > > > 2016-09-29 16:32 GMT-03:00 Julien Rouhaud : > > > > > You should try sqlsmith (https://github.com/anse1/sqlsmith), which > works > > > very well. > > > > I had found this one before, but all I could get was queries