Postgres Pro
Downloads
Home   >   mailing lists

Thread: Problem in pg_basebackup of 1.7 TB database while replicating in PostgreSQL 9.4.( Master and slave both are in postgreSQL 9.4)

Problem in pg_basebackup of 1.7 TB database while replicating in PostgreSQL 9.4.( Master and slave both are in postgreSQL 9.4)

From
Amal Chakravarty
Date:
Hi all. I am working with a database of 1.7 TB size which is in PostgreSQL 9.4. Kindly suggest how to take the pg_basebackup of such a huge data while replicating from master to slave. 

Regards, 
Amal Chakravarty.

Re: Problem in pg_basebackup of 1.7 TB database while replicating in PostgreSQL 9.4.( Master and slave both are in postgreSQL 9.4)

From
Tomas Vondra
Date:
On 10/4/21 9:28 AM, Amal Chakravarty wrote:
> Hi all. I am working with a database of 1.7 TB size which is in 
> PostgreSQL 9.4. Kindly suggest how to take the pg_basebackup of such a 
> huge data while replicating from master to slave.
> 

And what exactly is the issue? Does it fail in some way or are you 
looking for a faster / more efficient way to transfer the data?


regards

-- 
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

Re: Problem in pg_basebackup of 1.7 TB database while replicating in PostgreSQL 9.4.( Master and slave both are in postgreSQL 9.4)

From
Ron
Date:
On 10/4/21 2:28 AM, Amal Chakravarty wrote:
> Hi all. I am working with a database of 1.7 TB size which is in PostgreSQL 
> 9.4. Kindly suggest how to take the pg_basebackup of such a huge data 
> while replicating from master to slave.

Obligatory "9.4 is EOL" comment.

-- 
Angular momentum makes the world go 'round.