Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1e306f-0007Ic-Nb for pgsql-admin@arkaria.postgresql.org; Fri, 13 Oct 2017 13:34:29 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1e306f-0003Fs-AK for pgsql-admin@arkaria.postgresql.org; Fri, 13 Oct 2017 13:34:29 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1e304o-0006hf-6E for pgsql-admin@postgresql.org; Fri, 13 Oct 2017 13:32:34 +0000 Received: from mail-qt0-x235.google.com ([2607:f8b0:400d:c0d::235]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1e304f-00051c-BH for pgsql-admin@postgresql.org; Fri, 13 Oct 2017 13:32:33 +0000 Received: by mail-qt0-x235.google.com with SMTP id v41so9343526qtv.12 for ; Fri, 13 Oct 2017 06:32:24 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=openscg-com.20150623.gappssmtp.com; s=20150623; h=mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=Y/eTQ6p43nntreUAtN7/z5CGGQAJsmK+jLAZtL5MFUM=; b=TVn2uZYP8WRPhJcLJ/zsPm1wVQ2x5613O2dChM6f42KAU2bjI1pby6Hir2NQKQswdO pFKnCQYonkILaflzJKF6jl8cPDX1Uuu5dGUooOMaFXerrvHzWdnNMIrn5uaQo3VsOQJc GO+TjKH7Fd+kmZsgzJwXXXUtXoLTjKZlIyoBic+IALMOYAD8UsV6a3ZAQlGS8Fl4+/Qr snEWZAO6n60cTUR3PDI5gHAe2V5TJFzNrkseF+W+gPtKd3fBPAbOlJWkeZZgQWyMeMtb OzEK4kYV/98UbgX5nW001xmSGqT6z+ktR5mJoGSdC4TJbeSdek2m1JC61Txca0L34CLe MW3Q== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:subject:from:in-reply-to:date:cc :content-transfer-encoding:message-id:references:to; bh=Y/eTQ6p43nntreUAtN7/z5CGGQAJsmK+jLAZtL5MFUM=; b=atCVNNLBIa84Qs5HKofKT/YJIFN2s+WFGO/7JUjfA9ARB5H8uOiT9VwaKsLYaSZnFr E2i0ADgzk6HTU+pWJVzOmP8O8OsG16bJfPbJTyNOfdv3L300OAysb4Z/ivd2u2/4UAif 2/AJ4rIvxNJl6T+xmLQ1pc41I4lKlZD8SgDX5KBMysbacHIu+L6j+Xb9esypD+WfMJL3 MUQLiAgxqNvqqDiLaJqIefQRp8HDl601UTbDeO0j1oVHFL4rNnYmP5gbZSdnS31SnxrY nV/wKxuXwVnEmKxFgkTOzqpGzXW5JuOZJAjOrEQZz46oXxCJGgTBzXDitxbyqNFIus6F VyMQ== X-Gm-Message-State: AMCzsaUmGoA9A7GJoKzoCxlBVcOO+5Lyz53wOHUbEZE8f06NyydeIa7c u7BFwXH7X+4x++ObUyZg6Wp4jWLnF/A= X-Google-Smtp-Source: AOwi7QDs0zeamRYtIQ0gSOcapoacQRDNJc1wT5hWPJvOp/6+CSSP9txqLFI27N3yWZd7fVrHBe3X4A== X-Received: by 10.200.49.188 with SMTP id h57mr2020231qte.115.1507901542923; Fri, 13 Oct 2017 06:32:22 -0700 (PDT) Received: from [192.168.115.100] (cpe-66-66-220-41.rochester.res.rr.com. [66.66.220.41]) by smtp.gmail.com with ESMTPSA id 42sm558435qkx.27.2017.10.13.06.32.21 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 13 Oct 2017 06:32:21 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-8A1E9D8B-8A03-4EFB-A7DE-2CEDABAB40D2 Mime-Version: 1.0 (1.0) Subject: Re: Increase retention period of a table in database From: Scott Mead X-Mailer: iPhone Mail (15A402) In-Reply-To: <37018920e5984732a176436dbd80620c@ANMEX02.adnetman.local> Date: Fri, 13 Oct 2017 09:32:19 -0400 Cc: "pgsql-admin@postgresql.org" Content-Transfer-Encoding: 7bit Message-Id: <4FA290A9-6840-45C4-8639-D5639720C974@openscg.com> References: <37018920e5984732a176436dbd80620c@ANMEX02.adnetman.local> To: Ishan Arora List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --Apple-Mail-8A1E9D8B-8A03-4EFB-A7DE-2CEDABAB40D2 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable > On Oct 13, 2017, at 08:42, Ishan Arora wrote: >=20 > Hello Team, > =20 > I wanted to know if there is a way to increase the retention period of a t= able in database? > I have created a database for storing chat messages; it is integrated with= Cisco IM & Presence application. For details on integration: https://www.ci= sco.com/c/en/us/support/docs/unified-communications/unified-presence-version= -80/117735-cups-postgres-00.html > =20 > In the created db, the chat messages are stored in the =E2=80=98jm=E2=80=99= table for which the retention period seems to be 15 days. I would like to k= now if this can be increased and how. Postgres itself does not have any way to define a retention period for data a= s you describe. Once the data goes in, the user or application must issue a s= tatement to delete the data, This would be done by the application vendor ( C= isco). Most likely it=E2=80=99s a configuration option on the admin section= of the application. I recommend you contact Cisco support for details.=20 > =20 > Any inputs are highly appreciated. > =20 > Thanks & regards, > Ishan Arora > =20 --Apple-Mail-8A1E9D8B-8A03-4EFB-A7DE-2CEDABAB40D2 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

On Oct 13, 2017, at 08:42, Ish= an Arora <Ishan.Arora@anm.com&= gt; wrote:

Hello Team,

 

I wanted to know if there is a way to increase the re= tention period of a table in database?

I have created a database for storing chat messages; i= t is integrated with Cisco IM & Presence application. For details on int= egration: https://www.cisco.com/c/en/us/support/docs/unified-communications/unified-pr= esence-version-80/117735-cups-postgres-00.html

 

In the created db, the chat messages are stored in th= e =E2=80=98jm=E2=80=99 table for which the retention period seems to be 15 d= ays. I would like to know if this can be increased and how.

<= /blockquote>

Postgres itself does not have any way to def= ine a retention period for data as you describe. Once the data goes in, the u= ser or application must issue a statement to delete the data, This would be d= one by the application vendor ( Cisco).  Most likely it=E2=80=99s a con= figuration option on the admin section of the application. I recommend you c= ontact Cisco support for details. 


 

Any inputs are highly appreciated.

 

Thanks & regards,

Ishan Arora

 

= --Apple-Mail-8A1E9D8B-8A03-4EFB-A7DE-2CEDABAB40D2--