Re: [GENERAL] Question about loading up a table

2017-08-02 Thread Alex Samad
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

Re: [GENERAL] Question about loading up a table

2017-08-02 Thread Scott Marlowe
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

Re: [GENERAL] Question about loading up a table

2017-08-01 Thread Alex Samad
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

Re: [GENERAL] Question about loading up a table

2017-08-01 Thread Scott Marlowe
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

Re: [GENERAL] Question about loading up a table

2017-08-01 Thread Alex Samad
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

Re: [GENERAL] Question about loading up a table

2017-07-31 Thread Alex Samad
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

Re: [GENERAL] Question about loading up a table

2017-07-31 Thread Scott Marlowe
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

Re: [GENERAL] Question about loading up a table

2017-07-31 Thread vinny
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