You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@james.apache.org by "vttranlina (via GitHub)" <gi...@apache.org> on 2024/01/29 07:46:18 UTC
[PR] JAMES-2586 Introduce sql script to clean up PGSL data [james-project]
vttranlina opened a new pull request, #1959:
URL: https://github.com/apache/james-project/pull/1959
resolve https://github.com/linagora/james-project/issues/5040
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org
For additional commands, e-mail: notifications-help@james.apache.org
Re: [PR] JAMES-2586 Introduce sql script to clean up PGSL data [james-project]
Posted by "vttranlina (via GitHub)" <gi...@apache.org>.
vttranlina commented on code in PR #1959:
URL: https://github.com/apache/james-project/pull/1959#discussion_r1469347113
##########
server/apps/postgres-app/README.adoc:
##########
@@ -124,3 +124,11 @@ To run it, simply type:
....
docker compose -f docker-compose-distributed.yml up -d
....
+
+== Administration Operations
+=== Clean up data
+
+To clean up some specific data, that will never be used again after a long time, you can execute the SQL queries `clean_up.sql`.
+The never used data are:
+- mailbox_change
+- email_change
Review Comment:
I thought it was first, but IMO it is just a cleanup SQL.
how to run it, when to run it, it depends on the Admin. Not specific is cron job
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org
For additional commands, e-mail: notifications-help@james.apache.org
Re: [PR] JAMES-2586 Introduce sql script to clean up PGSL data [james-project]
Posted by "Arsnael (via GitHub)" <gi...@apache.org>.
Arsnael merged PR #1959:
URL: https://github.com/apache/james-project/pull/1959
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org
For additional commands, e-mail: notifications-help@james.apache.org
Re: [PR] JAMES-2586 Introduce sql script to clean up PGSL data [james-project]
Posted by "quantranhong1999 (via GitHub)" <gi...@apache.org>.
quantranhong1999 commented on code in PR #1959:
URL: https://github.com/apache/james-project/pull/1959#discussion_r1469334282
##########
server/apps/postgres-app/README.adoc:
##########
@@ -124,3 +124,11 @@ To run it, simply type:
....
docker compose -f docker-compose-distributed.yml up -d
....
+
+== Administration Operations
+=== Clean up data
+
+To clean up some specific data, that will never be used again after a long time, you can execute the SQL queries `clean_up.sql`.
+The never used data are:
+- mailbox_change
+- email_change
Review Comment:
Should we add a simple cron setup instruction e.g. every day?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org
For additional commands, e-mail: notifications-help@james.apache.org