Hello there, Currently, we r using, Postgresql v 7.3, on RedHat 9 machines. We provide a hot standby at all times for the Primary server. So, we have to maintain a duplicate of the entire database. The problem arises, when the standby boots. I wanted to know, whenever the standby boots up, what all files shud it copy frm the Primary. All files, under the data directory?? Viz., global, base, clog and xlog? What are those pg_internal.init, pgstat.stat files? What's the difference between global and base directories? If the async feature is used on the primary, shud we copy on the xlog and clog files onto the backup as well? As of now, we shut down postmaster, on the Primary whenever the standby boots up. Duz this ensure, all data is written onto the disk b4 postmaster shut downs? Also, any links for me to find more abt these files used in pgsql? These and more... Regards - Benjamin Jacob. __________________________________ Do you Yahoo!? The all-new My Yahoo! - Get yours free! http://my.yahoo.com ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
