Hi
I don't have an extra 4T of filespace. I could potentially move the
attached lun from one server and attach to the other
well that was my question how to check if its pg_dump thats bound. I have
checked network performance - 9.8Gb and I can write more data to disk
I do have 1 index
A
On
On Tue, Aug 1, 2017 at 4:27 PM, Alex Samad wrote:
> Hi
>
> So just to go over what i have
>
>
> server A (this is the original pgsql server 9.2)
>
> Server X and Server Y ... PGSQL 9.6 in a cluster - streaming replication
> with hot standby.
>
>
> I have 2 tables about 2.5T of
Hi
So just to go over what i have
server A (this is the original pgsql server 9.2)
Server X and Server Y ... PGSQL 9.6 in a cluster - streaming replication
with hot standby.
I have 2 tables about 2.5T of diskspace.
I want to get the date from A into X and X will replicate into Y.
I am
On Mon, Jul 31, 2017 at 11:16 PM, Alex Samad wrote:
> Hi
>
> I double checked and there is data going over, thought I would correct that.
>
> But it seems to be very slow. Having said that how do I / what tools do I
> use to check through put
Try the pg_current_xlog_location
Hi
I double checked and there is data going over, thought I would correct that.
But it seems to be very slow. Having said that how do I / what tools do I
use to check through put
A
On 1 August 2017 at 08:56, Alex Samad wrote:
> Hi
>
> I'm using pg_dump 9.6 to do the
Hi
I'm using pg_dump 9.6 to do the dumps.
I'm also pretty sure no data is being replicated until the end of the copy
stdin as I was watching tcpdump output and I can see data from the orig
master to the new master and no traffic between new master and the standby,
pretty sure my replication is
On Mon, Jul 31, 2017 at 2:31 AM, vinny wrote:
> On 2017-07-31 11:02, Alex Samad wrote:
>>
>> Hi
>>
>> I am using pg_dump | psql to transfer data from my old 9.2 psql into a
>> 9.6 psql.
Note that you should be doing pg_dump with 9.6's pg_dump, as it's
possible for 9.2's pg_dump
On 2017-07-31 11:02, Alex Samad wrote:
Hi
I am using pg_dump | psql to transfer data from my old 9.2 psql into a
9.6 psql.
The new DB server is setup as master replicating to a hot standby
server.
What I have noticed is that the rows don't get replicated over until
the copy from stdin is