Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Implement completely purging a room from the database #11

Open
aperezdc opened this issue Jan 10, 2017 · 4 comments
Open

Implement completely purging a room from the database #11

aperezdc opened this issue Jan 10, 2017 · 4 comments
Assignees
@aperezdc
Labels
enhancement

Comments

@aperezdc
Copy link
Owner

It would be nice to have a command which would completely erase a room from the database. “Completely” means that no trace at all is left, in the fashion of this script, but adapted to work with PostgreSQL.
@aperezdc aperezdc self-assigned this Jan 10, 2017
@aperezdc
Copy link
Owner Author

The referenced script is either outdated (I cannot see some of the tables when exploring the database with the psql CLI), or works only for SQLite. Most likely it's outdated: it doesn't make much sense that Synapse would use different schemas depending on which database is used.

aperezdc added a commit that referenced this issue Jan 10, 2017
@aperezdc
Implement a subcommand to obtain room information
9a2f353 
This can be useful for debugging. Also, if destructive commands get to be
implemented (for exaple, deleting a room completely as per #11), it would
be a good idea to show room information and interactively prompting for
confirmation. Having this in place will allow for that in the future.
@aperezdc
Copy link
Owner Author

PR matrix-org/synapse#1927 updated the example script which nukes rooms from a SQLite database. It should not be too difficult to adapt it to work with PostgreSQL as well.

Maybe @psaavedra is up to implementing this. Shall I assign this issue to you?

@psaavedra
Copy link
Contributor

Working on it

@psaavedra psaavedra mentioned this issue May 16, 2017
Open
@rubo77
Copy link

rubo77 commented Aug 10, 2018

@psaavedra: still working on it?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@aperezdc aperezdc

Labels
enhancement
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@psaavedra @aperezdc @rubo77