Re: Does PostgreSQL check database integrity at startup?

2017-12-27 Thread Alvaro Herrera
For context: this was first reported in the Barman forum here: https://groups.google.com/forum/#!msg/pgbarman/3aXWpaKWRFI/weUIZxspDAAJ They are using Barman for the backups. Stephen Frost wrote: > > But at some point in time, slave became corrupt (one of the base > > files are zero size where it

Re: Does PostgreSQL check database integrity at startup?

2017-12-27 Thread Stephen Frost
Edson, * Edson Carlos Ericksson Richter (rich...@simkorp.com.br) wrote: > Em 27/12/2017 15:02, Stephen Frost escreveu: > >* Alvaro Herrera (alvhe...@2ndquadrant.com) wrote: > >>Stephen Frost wrote: > >> > >>>* Edson Carlos Ericksson Richter (rich...@simkorp.com.br) wrote: > Anyway, instead

Re: postgresql-10 for ubuntu-17.10 (artful)?

2017-12-27 Thread Stuart McGraw
On 12/27/2017 11:07 AM, Steve Atkins wrote: >> On Dec 26, 2017, at 6:21 PM, Stuart McGraw wrote: >> Is there a repository for Postgresql-10 available at >> http://apt.postgresql.org/pub/repos/apt for Ubuntu-17.10 (artful)? >> When I look at the dist/ subdirectory there,

Re: Does PostgreSQL check database integrity at startup?

2017-12-27 Thread Stephen Frost
Alvaro, * Alvaro Herrera (alvhe...@alvh.no-ip.org) wrote: > Stephen Frost wrote: > > > It's entirely unclear to me what the problem being complained about in > > this thread actually is. > > As Edson explained, a relfilenode in the standby server is zero bytes > long when it is not that size in

Re: postgresql-10 for ubuntu-17.10 (artful)?

2017-12-27 Thread Steve Atkins
> On Dec 26, 2017, at 6:21 PM, Stuart McGraw wrote: > > Is there a repository for Postgresql-10 available at > http://apt.postgresql.org/pub/repos/apt > for Ubuntu-17.10 (artful)? When I look at the dist/ > subdirectory there, there seem to be repos for all the > other

Re: Does PostgreSQL check database integrity at startup?

2017-12-27 Thread Edson Carlos Ericksson Richter
Em 27/12/2017 15:02, Stephen Frost escreveu: Alvaro, * Alvaro Herrera (alvhe...@2ndquadrant.com) wrote: Stephen Frost wrote: * Edson Carlos Ericksson Richter (rich...@simkorp.com.br) wrote: Anyway, instead digging into rsync functionality (or bugs - I doubt, but who knows?), I do prefer to

Re: Does PostgreSQL check database integrity at startup?

2017-12-27 Thread Stephen Frost
Alvaro, * Alvaro Herrera (alvhe...@2ndquadrant.com) wrote: > Stephen Frost wrote: > > > * Edson Carlos Ericksson Richter (rich...@simkorp.com.br) wrote: > > > > Anyway, instead digging into rsync functionality (or bugs - I doubt, > > > but who knows?), I do prefer to have a script I can run to

Re: Does PostgreSQL check database integrity at startup?

2017-12-27 Thread Alvaro Herrera
Stephen Frost wrote: > * Edson Carlos Ericksson Richter (rich...@simkorp.com.br) wrote: > > Anyway, instead digging into rsync functionality (or bugs - I doubt, > > but who knows?), I do prefer to have a script I can run to check if > > there is obvious failures in standby servers. > > As

Re: psycopg2 and java gssapi questions

2017-12-27 Thread Mike Feld
What about when the ticket expires? Are there any libraries that manage this for the application? Is this common practice by anyone? Mike -Original Message- From: Dave Cramer To: Magnus Hagander Cc: Mike Feld ; pgsql-general

Re: Does PostgreSQL check database integrity at startup?

2017-12-27 Thread Edson Carlos Ericksson Richter
Em 26/12/2017 20:11, rob stone escreveu: Hello, On Tue, 2017-12-26 at 18:58 -0300, Alvaro Herrera wrote:Hello, David Steele wrote: pgBackRest will validate all page checksums (including indexes, etc.) in the cluster during backup. Full backups check everything, incr/differential backups