Re: [GENERAL] Archeiving and Purging

2015-03-19 Thread Adrian Klaver
On 03/18/2015 11:38 PM, adityagis wrote: HI David/John, Thanks for the support. But as of now I have not done any configuaration for the archieving process. I hope once my configuarations are done then may be I can proceed with your suggestions. I am still looking for the intial process that

Re: [GENERAL] Archeiving and Purging

2015-03-19 Thread adityagis
HI David/John, Thanks for the support. But as of now I have not done any configuaration for the archieving process. I hope once my configuarations are done then may be I can proceed with your suggestions. I am still looking for the intial process that need to be performed for archeiving. Thank

Re: [GENERAL] Archeiving and Purging

2015-03-19 Thread Samuel Smith
On 03/18/2015 09:20 AM, adityagis wrote: Dear Users, I have lots of data in my DB. I need to do archeiving and purging of my data. Can anyone please help me with step by step riles? Thanks in Advance. Aditya Kumar -- View this message in context: http://postgresql.nabble.com/Archeiving-an

Re: [GENERAL] Archeiving and Purging

2015-03-18 Thread David G. Johnston
On Wednesday, March 18, 2015, John R Pierce wrote: > On 3/18/2015 7:20 AM, adityagis wrote: > >> I have lots of data in my DB. I need to do archeiving and purging of my >> data. >> Can anyone please help me with step by step riles? >> > > like this? > > select * from table where datefield < cur

Re: [GENERAL] Archeiving and Purging

2015-03-18 Thread John R Pierce
On 3/18/2015 7:20 AM, adityagis wrote: I have lots of data in my DB. I need to do archeiving and purging of my data. Can anyone please help me with step by step riles? like this? select * from table where datefield < current_date-interval '6 months'; delete from table where datefield < curre

[GENERAL] Archeiving and Purging

2015-03-18 Thread adityagis
Dear Users, I have lots of data in my DB. I need to do archeiving and purging of my data. Can anyone please help me with step by step riles? Thanks in Advance. Aditya Kumar -- View this message in context: http://postgresql.nabble.com/Archeiving-and-Purging-tp5842393.html Sent from the Post