Re: Streaming replication with sync slave, but disconnects due to missing WAL segments

Hi Jeff.

Thanks for the clarification.

I'll adjust wal_keep_segments for the expected biggest table in the backup.

Best regards,
Mads





From:    Jeff Janes <jeff.janes@gmail.com>
To:    "Mads.Tandrup@schneider-electric.com"
            <Mads.Tandrup@schneider-electric.com>,
Cc:    Albe Laurenz <laurenz.albe@wien.gv.at>,
            "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date:    06-06-2013 18:33
Subject:    Re: [GENERAL] Streaming replication with sync slave, but
            disconnects due to missing WAL segments
Sent by:    pgsql-general-owner@postgresql.org



On Wed, Jun 5, 2013 at 11:26 PM, <Mads.Tandrup@schneider-electric.com>
wrote:
      Hi

      Thanks for your reply. Do you know of any options that I could give
      pg_dump/psql to avoid creating one big transaction? I'm using the
      plain text format for pg_dump.


For the plain text format, it is already not one big transaction, unless
you specify to -1 to the psql.  However, the load of any individual table
will still be a single transaction, so for a very large table it will still
be a very long transaction.

Using pg_dump for --inserts could get around this, but it would probably be
better to fix the fundamental problem by increasing wal_keep_segments or
something of that nature.

Cheers,

Jeff

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
______________________________________________________________________