trac: lost all accounts, apology

James Cameron quozl at
Mon Mar 3 23:18:55 EST 2014

On Mon, Mar 03, 2014 at 07:19:25PM +1100, James Cameron wrote:
> I wasn't able to find valid backups for trac.  The only backups we
> have were made with the PostgreSQL database server running; the
> documentation says this is not a usable backup.  So I'll look into
> another method.

With advice from Chris Ball and #postgresql, it proved possible to use
the filesystem backup, start up another instance of the database, and
dump the permission, session, and session_attribute tables.

However, I have not loaded these dumps into the production
database, because I don't see a need, and most of the data is spam;
roughly 5500 accounts, with no easy way to validate.

Thanks to the people who have re-registered.  For those that had
specific permissions, I've added back the permissions you had.

James Cameron

More information about the Devel mailing list