I am use Postgres 7.1 going to upgrade to 7.2 run in Redhat Linux 7.2. Each time user do update, insert and delete will save to the logfile, right?
1) Where is that log file? 2 ) How do I do partial dump the log file in SQL statements? For example, I want to dump all log from 6:00 to 9:00 , from 9:00 to 12:00 , from 12:00 to 15:00, from 15:00 to 18:00, etc. I can use these partial dump as incremental backup instead full dump. I can also use these partial dump as replicate data to other Postgres server. Please tell me how do these. P.S. our NNTP USENET server doesn't have all *.pgsql-* news groups. Therefore, please CC a copy to me if you response my message. Thank Q!
begin:vcard n:Chui;Raymond tel;work:301-713-0624 x168 x-mozilla-html:FALSE url:http://www.nws.noaa.gov/ org:NWS, NOAA;OHD13 version:2.1 email;internet:[EMAIL PROTECTED] title:CS adr;quoted-printable:;;1325 East-West Highway=0D=0ASSMC2, Room 8112;Silver Spring;MD;20910-3282;U.S.A. fn:Raymond Chui end:vcard
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
