Re: [ADMIN] Increase retention period of a table in database - Mailing list pgsql-admin

From scott ribe
Subject Re: [ADMIN] Increase retention period of a table in database
Date
Msg-id 09FB7EFC-BAE2-4591-93B0-F720C80FAED5@elevated-dev.com
Whole thread Raw
In response to [ADMIN] Increase retention period of a table in database  (Ishan Arora <Ishan.Arora@anm.com>)
List pgsql-admin
There is no "retention period" in Postgres. If messages are disappearing after 15 days, then your application is
deletingthem. 

> On Oct 13, 2017, at 6:42 AM, Ishan Arora <Ishan.Arora@anm.com> wrote:
>
> Hello Team,
>
> I wanted to know if there is a way to increase the retention period of a table in database?
> I have created a database for storing chat messages; it is integrated with Cisco IM & Presence application. For
detailson
integration:https://www.cisco.com/c/en/us/support/docs/unified-communications/unified-presence-version-80/117735-cups-postgres-00.html
>
> In the created db, the chat messages are stored in the ‘jm’ table for which the retention period seems to be 15 days.
Iwould like to know if this can be increased and how. 
>
> Any inputs are highly appreciated.
>
> Thanks & regards,
> Ishan Arora

--
Scott Ribe
https://www.linkedin.com/in/scottribe/
(303) 722-0567



--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

pgsql-admin by date:

Previous
From: Ishan Arora
Date:
Subject: [ADMIN] Increase retention period of a table in database
Next
From: Ashok Kumar Tiwari
Date:
Subject: [ADMIN] Database goes in recovery mode