On 12/26/17 4:58 PM, Alvaro Herrera wrote:
pgBackRest will validate all page checksums (including indexes, etc.) in the
cluster during backup. Full backups check everything, incr/differential
backups check only the files that have changed.
If a table or index file is of zero length when back
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
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 dig
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, there seem to be repos
>>
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
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 the primary server, and it corresponds
to a persistent table. I don't ha
> 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 Ubuntu releases includi
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 h
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 c
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 mentio
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
Sent: Thu, Dec 21, 2017 6:09 am
Subject: Re: psycopg2 and
Greetings,
* Edson Carlos Ericksson Richter (rich...@simkorp.com.br) wrote:
> Right now, I do prefer to use pg_basebackup instead - but sometimes
> (when database is just too large), rsync seems more reliable (maybe
> it is the cause of the problem).
I don't generally recommend rsync for various
Alban Hertroys wrote:
> Does that mean that at step 3 one could issue this?:
>
> ./configure `pg_config —configure`
Not exactly, because pg_config emits the arguments in quotes and the
shell passes them as is to configure which doesn't like that. This
works:
eval ./configure `pg_config --co
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 che
Em 26/12/2017 20:42, Martin Marques escreveu:
El 26/12/17 a las 14:46, Edson Carlos Ericksson Richter escribió:
Usually, or by "pg_basebackup" or by "rsync" as described in PostgreSQL
Wiki.
Right now, I'm doing via pg_basebackup.
Nothing extraordinary.
When using rsync:
rsync -e "ssh -2 -C -p
Thanks for the info.
I think, it is not worth to do the migration to v10 now
and then some month later to v11.
I hope, my v9.1 will survive the version jump.
What do you think?
My database has no complex things in it. I keept it realy
on basic level to avoid problems if I have to upgrade.
Than
On Wed, Dec 27, 2017 at 08:53:11AM +0100, Michelle Konzack wrote:
> Is there already a release date for v11?
Based on the pace of the most recent major releases, this could happen
around September. This depends on any issues encountered
post-development though.
--
Michael
signature.asc
Descripti
17 matches
Mail list logo
