[GENERAL] Question about loading up a table - Mailing list pgsql-general

From Alex Samad
Subject [GENERAL] Question about loading up a table
Date
Msg-id CAJ+Q1PWaeWsHmCtHrXBxmGfCZknqUKOOB32RWycM2Ohz=6Q+vA@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Question about loading up a table  (vinny <vinny@xs4all.nl>)
List pgsql-general
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+ lines of rows.

Is there a way to tell the master to replicate earlier or is there a way to get pg_dump to bundle into say 100K rows at a time ?

Thanks
Alex

pgsql-general by date:

Previous
From: Alex Samad
Date:
Subject: Re: [GENERAL] vacuum on streaming replication
Next
From: vinny
Date:
Subject: Re: [GENERAL] Question about loading up a table