Re: Generate test data inserts - 1GB

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Generate test data inserts - 1GB
Date: 2019-08-09 16:59:38
Message-ID: 35286e57-c19c-861b-ebf7-d4f236e85e69@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com <mailto:adrian(dot)klaver(at)aklaver(dot)com>
>
>
> Thanks for the reply Adrian.
>
> Missed one requirement. Will these methods generate wal logs needed
> for replication?
>
> Actually the data is to check if replication catches up. Below is
> scenario :
>
> 1. Have a master slave cluster with replication setup
>
> 2. Kill master so that standby takes over. We are using pacemaker for
> auto failure.
> Insert 1 GB data in new master while replication is broken.
>
> 3 Start oldnode as standby and check if 1GB data gets replicated.
>
> As such testing might be frequent we needed to spend minimum time in
> generating data.
> Master slave are in same network.
>
> Thanks !
How quickly does your production instance grow, in terms of
GB/per-unit-time?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-08-09 16:59:57 Re: Generate test data inserts - 1GB
Previous Message Shital A 2019-08-09 16:51:21 Re: Generate test data inserts - 1GB