Could you point the better approach on PostgreSQL backup/ restore ?
Hi Experts
Could you point the better approach on PostgreSQL backup/ restore ?
(Windows OS)
Thanks in advance!
Could you point the better approach on PostgreSQL backup/ restore ?
(Windows OS)
Thanks in advance!
Last Comment
ASKER
Hello
Better explaining what I mean:
1st The test server instalation, where the DB is installed
2st The homologation instalation where PostgreSQL is installed and the test DB must be migrated.
Is it possible just to copy file(s) from one instalation to another to make the homologation have na equivalent DB ?
Better explaining what I mean:
1st The test server instalation, where the DB is installed
2st The homologation instalation where PostgreSQL is installed and the test DB must be migrated.
Is it possible just to copy file(s) from one instalation to another to make the homologation have na equivalent DB ?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Storage Software
The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.
35K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
http://www.postgresql.org/docs/9.3/static/wal-intro.html
basically you save changes from a particular baseline and reapply those changes to the baseline to establish recovery point.