[ADMIN] Increase retention period of a table in database
[ADMIN] Increase retention period of a table in database
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
Re: [ADMIN] Increase retention period of a table in database
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 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] Increase retention period of a table in database
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