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 3
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 diskspace.
>
> I wan
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 curr
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 function on the sla
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 dumps.
>
> I'm also pret
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 wo
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 to not know about
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 finis
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 finished... hard to test when you have M+ line
