Pgbasebackup help - Mailing list pgsql-general

Hi All,

 

I need some help in postgresql base backup.

 

We are currently using multiple DBMS in our project and postgresql is one of them. Our private DBMS keeps the online data and postgresql keeps online as well as historical data.

 

At present, we are doing the backup/restore process for our project. So we planned to use Pg_basebackup instead of  pg_dump. 

 

Below is the backup steps.

 

Time-T1   = Start the backup of private DBMS.

Time-T2   = Finished the private backup DBMS.

Time-T3   = Start the pg_basebackup.

Time-T4   = End the Pg_basebackup.

 

Here the requirement is we don’t want to restore the data after Time-T3.  But when I followed this approach https://opensourcedbms.com/dbms/point-in-time-recovery-pitr-using-pg_basebackup-with-postgresql-9-2/, I am still getting the information’s archived from Time-T3 to TimeT4.

 

Seems, WAL archives are holding all the transactions, which are happened between Time T3 – Time T4.

 

Also, I don’t want enable archive_mode = on as it needs to maintain archives files.

 

So I decided the enable only these parameters.

 

Postgresql.conf

---------------------------------

wal_level = hot_standby

max_wal_senders = 1

 

And added replication permissions for the current user in pg_hba.conf.

 

It does, what I need it. In the backup I did not have the data between T3-T4.

 

Is this correct or is there anything I missing it.

 

Please let me know.