ALTER TABLE .. SET STATISTICS

2018-08-04 Thread Ron
v9.6.9 For columns of type bytea which store image data (PDFs, JPGs, etc) would it speed up the ANALYZE process to SET STATISTICS = 0? That way, default_statistics_target could be cranked higher -- giving better statistics for needed columns -- without polluting pg_statistics with unneeded

Re: jndi jdbc url with ssl authenticat in tomcat ... fails org.xml.sax.SAXParseException columnNumber: 79; The reference to entity "ssl" must end with the ';' delimiter

2018-08-04 Thread Peter Hicks
The & need to be replaced by & Peter On Sat, 4 Aug 2018, 22:47 Dave Cramer, wrote: > Pretty sure this is a tomcat error . > > The connection string looks fine > > Dave Cramer > > da...@postgresintl.com > www.postgresintl.com > > On 30 July 2018 at 11:32, Didier Wiroth > wrote: > >> Hello, >>

Re: jndi jdbc url with ssl authenticat in tomcat ... fails org.xml.sax.SAXParseException columnNumber: 79; The reference to entity "ssl" must end with the ';' delimiter

2018-08-04 Thread Dave Cramer
Pretty sure this is a tomcat error . The connection string looks fine Dave Cramer da...@postgresintl.com www.postgresintl.com On 30 July 2018 at 11:32, Didier Wiroth wrote: > Hello, > I'm trying to configure a postgres jndi resource in tomcat that needs to > connect via ssl and client certifi

Re: Pg_rewind cannot load history wal

2018-08-04 Thread Christophe Pettus
> On Aug 4, 2018, at 13:50, Michael Paquier wrote: > > Hm? The specific situation is if pg_rewind is attached to the target before the forced post-recovery checkpoint completes, the target can be corrupted: https://www.postgresql.org/message-id/ece3b665-e9dd-43ff-b6a6-734e74352...@

Re: Pg_rewind cannot load history wal

2018-08-04 Thread Michael Paquier
On Sat, Aug 04, 2018 at 07:54:36AM -0700, Christophe Pettus wrote: > Would having pg_rewind do a checkpoint on the source actually cause > anything to break, as opposed to a delay while the checkpoint > completes? Users relying only on streaming without archives would be impacted as potentially tw

Re: Add column with If Not Exists

2018-08-04 Thread Dmitry Igrishin
сб, 4 авг. 2018 г. в 18:57, Simon White : > > Hi > > I would like to suggest the addition of the "If not exists" to the Add > Column feature of Postgres. There are quite common situations where > ensuring a column exists is important so that an update to remote > devices will not fail but it is no

Re: Add column with If Not Exists

2018-08-04 Thread Adrian Klaver
On 08/04/2018 08:56 AM, Simon White wrote: Hi I would like to suggest the addition of the "If not exists" to the Add Column feature of Postgres.  There are quite common situations where ensuring a column exists is important so that an update to remote devices will not fail but it is not so im

Add column with If Not Exists

2018-08-04 Thread Simon White
Hi I would like to suggest the addition of the "If not exists" to the Add Column feature of Postgres.  There are quite common situations where ensuring a column exists is important so that an update to remote devices will not fail but it is not so important that deprecated fields be removed. 

Re: PANIC: could not open critical system index 2662

2018-08-04 Thread Tom Lane
C GG writes: > When trying to restart the PostgreSQL 9.2 database for our JIRA > installation, we're getting > "PANIC: could not open critical system index 2662" ... I've tried various > things like turning on zero_damaged_pages but postmaster still crashes on > connect when attempting to pg_dump

Re: Pg_rewind cannot load history wal

2018-08-04 Thread Christophe Pettus
> On Aug 4, 2018, at 06:13, Michael Paquier wrote: > > Well, since its creation we have the tool behave this way. I am not > sure either that we can have pg_rewind create a checkpoint on the source > node each time a rewind is done, as it may not be necessary, and it > would enforce WAL segmen

PANIC: could not open critical system index 2662

2018-08-04 Thread C GG
This comes at the end of a long cascade of problems stemming from a lightning strike to our datacenter causing our battery backup systems to fail, and overvoltage from the commercial power company to damage our storage arrays which run some services and contain our on-site backups. No problem, rig

Re: Pg_rewind cannot load history wal

2018-08-04 Thread Michael Paquier
On Sat, Aug 04, 2018 at 04:59:45AM -0700, Andres Freund wrote: > On 2018-08-04 10:54:22 +0100, Simon Riggs wrote: >> pg_rewind doesn't work correctly. Documenting a workaround doesn't change >> that. > > Especially because most people will only understand this after they've > been hit, as test sc

Re: Pg_rewind cannot load history wal

2018-08-04 Thread Andres Freund
On 2018-08-04 10:54:22 +0100, Simon Riggs wrote: > On 4 August 2018 at 07:56, Michael Paquier wrote: > >> Sounds like we should write a pending timeline change to the control > >> file and have pg_rewind check that instead. > >> > >> I'd call this a timing bug, not a doc issue. > > > > Well, havin

Re: Pg_rewind cannot load history wal

2018-08-04 Thread Simon Riggs
On 4 August 2018 at 07:56, Michael Paquier wrote: > On Sat, Aug 04, 2018 at 07:44:59AM +0100, Simon Riggs wrote: >> I think the problem is that writing the online checkpoint is deferred >> after promotion, so this is a timing issue that probably doesn't show >> in our regression tests. > > Somewha