CVS corruption/mistagging?
in [PgSql]
|
Prev: Bug: Buffer cache is not scan resistant
Next: CREATE DATABASE cannot be executed from a function or multi-command string
From: Magnus Hagander on 15 Aug 2007 02:00 Tom Lane wrote: > So I think that "cvs rtag -d REL7_4_STABLE pgsql" will fix it. > I'd like someone to double-check that though. Also maybe we should back > up the repository first? Just for your info: all VMs on tribble, which includes cvs, are backed up at 02:30 every day, CEST (that's 00:30 UTC right now, but it follows the local time on tribble so it'll be 23:30 UTC when austra switches later this year. Perhaps we should switch the machine to GMT, but that's a different discussion) For something like this it's good to run a special backup before that of course, but it's probably good to know when the backups run anyway... //Magnus ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
From: Magnus Hagander on 15 Aug 2007 02:02 Tom Lane wrote: > Andrew Dunstan <andrew(a)dunslane.net> writes: >> So I'd say your strategy looks good - backup and remove the phony tag. >> I'd also say we should probably be logging tag commands in taginfo. >> Presumably we mere mortal committers should not be doing any tagging >> whatsoever, and tags should only be applied in preparation for releases. > > +1 ... we should at least log such commands, and maybe disallow to anyone > except Marc's "pgsql" account. Particularly since they don't get > reported in pgsql-committers messages (or is that something we > can/should change?) > I think you can, by sticking a command in the taginfo command. It's the same script that Marc is using to try to restrict who can do it - once he has that working, it should be as simple as adding a mail command to the end of that script. And +1 on doing it. //Magnus ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
From: Tom Lane on 15 Aug 2007 02:39 Magnus Hagander <magnus(a)hagander.net> writes: > Tom Lane wrote: >> I'd like someone to double-check that though. Also maybe we should back >> up the repository first? > Just for your info: all VMs on tribble, which includes cvs, are backed > up at 02:30 every day, CEST Good, but the salient followup questions to that are (1) backed up to where exactly?, and (2) how many days' past backups could we get at, if we had to? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
From: Magnus Hagander on 15 Aug 2007 02:43 Tom Lane wrote: > Magnus Hagander <magnus(a)hagander.net> writes: >> Tom Lane wrote: >>> I'd like someone to double-check that though. Also maybe we should back >>> up the repository first? > >> Just for your info: all VMs on tribble, which includes cvs, are backed >> up at 02:30 every day, CEST > > Good, but the salient followup questions to that are (1) backed up to > where exactly?, and (2) how many days' past backups could we get at, > if we had to? 1) The entire VM, with "dump" 2) We have today, yesterday and one weekly (copies the daily on monday, if I read it right) They are dumped to a NFS share on this schedule. That NFS share is dumped to tape by systems at Conova - I'll let Stefan fill in the details about that. //Magnus ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
From: Tom Lane on 15 Aug 2007 03:13
Magnus Hagander <magnus(a)hagander.net> writes: > Tom Lane wrote: >> Good, but the salient followup questions to that are (1) backed up to >> where exactly?, and (2) how many days' past backups could we get at, >> if we had to? > They are dumped to a NFS share on this schedule. That NFS share is > dumped to tape by systems at Conova - I'll let Stefan fill in the > details about that. That's good as far as it goes, but seeing that PG is a worldwide organization now, I wonder whether our primary CVS shouldn't have backups on several continents. Pardon my paranoia ... but our collective arses have been saved by offsite backups at least once already ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org |