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.
With best regards,
Ramkumar Yelai
Siemens Technology and Services Private Limited
CT DC AA I HOUSE DEV GL4
84, Hosur Road
Bengaluru 560100, Indien
Tel.: +91 80 33136494
Fax: +91 80 33133389
Mobil: +91 9886182031
Registered Office: 130, Pandurang Budhkar Marg, Worli, Mumbai 400 018. Telephone +91 22 39677000. Fax +91 22 39677075. Other Offices: Bangalore, Chennai, Gurgaon, Noida, Kolkata, Pune. Corporate Identity number:U99999MH1986PLC093854
