From: | "Raymond Chui" <Raymond(dot)Chui(at)noaa(dot)gov> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org, pgadmin-support(at)postgresql(dot)org |
Subject: | How to partial dump the log in SQL? |
Date: | 2002-05-29 14:42:27 |
Message-ID: | 3CF4E8D3.8FDFF1A8@noaa.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support pgsql-admin |
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!
Attachment | Content-Type | Size |
---|---|---|
raymond.chui.vcf | text/x-vcard | 312 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | nimeshb | 2002-05-29 17:00:59 | ecpg not found |
Previous Message | Dave Page | 2002-05-29 11:32:55 | Re: Migration from MS Sql server using the plug-in |
From | Date | Subject | |
---|---|---|---|
Next Message | Masaru Sugawara | 2002-05-29 15:37:41 | Re: Problems in query |
Previous Message | bangh | 2002-05-29 14:35:37 | Re: how to install postgresql!! |