How to partial dump the log in SQL?

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

Browse pgadmin-support by date

  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

Browse pgsql-admin by date

  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!!