There is no "retention period" in Postgres. If messages are disappearing after 15 days, then your application is deleting them. > On Oct 13, 2017, at 6:42 AM, Ishan Arora <Ishan.Arora@xxxxxxx> 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 details on 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. I would 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
