Taking Base Backup in PostgreSQL

We can use the simple command to take base backup as below:

Pg_basebackup[options..];
 
---e.g.;---
 
[...yourserver]$ pg_basebackup -h mydbserver -D /usr/local/pgsql/data
 
 
----Options are:----
 
-D (directory)
-F (Format with options -t for tar)
-R
--write-recovery-conf (to write recovery.conf file with minimal options)

pg_basebackup takes physical backup of databases

like0

Comments

Every post is pleasantly kept

Erik G Robberts's picture

Every post is pleasantly kept up and correct wonderful substance. I like to read your news to get good learning on current happenings. The ideas which you have partaken in this blog are good. I got an organized writing style from your blog. I am exceptionally inspired with that. You have good writing ability and it makes the reader to read your articles to an ever increasing extent. Thank you such a great amount for this incredible post. custom essay writing service has affordable and best quality papers.

like0