Choose From Top Health Insurance Carriers.

Get Started





============================================================================================================================================================================== pg51g is a data diff toolkit for PostgreSQL. It is meant to be pronounced 'pee-gee-sig' -- which is what you get if you unfocus enough while looking at the name :-) I know, it's a terrible name. It is also an accurate name, as it generates and maintains md5-based signature tables for your relations in a PostgreSQL database. These sig tables may be used in two ways: * for comparing data across databases * for comparing the current state of a database with a saved snapshot of itself (self-diff) This software has been based on Fabien Coelho's report on Remote Comparison of Database Tables, which may be found here: http://cri.ensmp.fr/classement/doc/A-375.pdf This software, however, represents a brand new implementation in C and PL/pgSQL, with modifications. http://pgdba.net/pg51g/ comments, suggestions, contributions welcome! regards, Michael Nacos ---------------------------(end of broadcast)--------------------------- -To unsubscribe from this list, send an email to: pgsq ... @postgresql.org -Fedora Weekly News Issue 150- Welcome to Fedora Weekly News Issue 150 for the week ending November 2nd, 2008. http://fedoraproject.org/wiki/FWN/Issue150 In this week's issue, featured content includes announcements on a new Fedora Sugar Spin, and development freeze for Fedora 10. The Translation beat this week features an interview with Fedora Translation project member Diego Zacarao (Rasther). In Developments, details on resume from suspend problems with Intel i945s, details on "[a] gigantic multi-thread flamewar consum[ing] many list participants" over moving X from VT7 to VT1 and POSIX file capabilities for Fedora 11. The Artwork beat features discussion of new wallpaper extras, and final fixes for the Fedora 10 Solar backgrounds. The Security Advisory beat rounds out this issue and updates us with fixes released in the last week for Fedora 8 and 9. If you are interested in contributing to Fedora Weekly News, please see our 'join' page[1]. FWN Editorial Team: Pascal Calarco, Oisin Feeley, Huzaifa Sidhpurwala [1] http://fedoraproject.org/wiki/NewsProject/Join --Announcements-- In this section, we cover announcements from the Fedora Project. http://www.redhat.com/archives/fedora-announce-list/ http://www.redhat.com/archives/fedora-devel-announce/ Contributing Writer: Max Spevack ---Blocker Bug Review Meeting--- John Poelstra announced[1] that a "meeting is being held to review the current blocker bugs[2] in anticipation of the Final Development Freeze this Tuesday, October 28th." [1] http://www.redhat.com/archives/fedora-devel-announce/2008-October/msg00016.html [2] https://bugzilla.redhat.com/showdependencytree.cgi?id=438943&hide_resolved=1 ---Translation packagers: Rebuild before devel freeze--- Dimitris Glezos wrote[3] to remind "maintainers of Fedora-translatable packages to issue a build before the Development Freeze of tomorrow, 28/10, in order to have all translations submitted until the translation deadline of 21/10 included in Fedora 10 (otherwise our translator's hard work will go to the gutter)." [3] http://www.redhat.com/archives/fedora-devel-announce/2008-October/msg00017.html ---Fedora Sugar Spin--- Sebastian Dziallas announced[4] the "availability of our Fedora Sugar Spin, which incorporates the Sugar Desktop Environment on a Fedora Live CD." To get the spin, and to contribute to its further development, read the full announcement below. [4] http://www.redhat.com/archives/fedora-announce-list/2008-October/msg00012.html ---Frozen for Fedora 10--- Jesse Keating reminded[5] everyone that we are now frozen for Fedora 10. "At this point, builds for F10 are not automatically brought into Rawhide, and won't be in the Fedora 10 release. To request a freeze override, please use the Final Freeze Policy[6]." [5] http://www.redhat.com/archives/fedora-devel-announce/2008-October/msg00018.html [6] https://fedoraproject.org/wiki/ReleaseEngineering/FinalFreezePolicy --Translation-- This section covers the news surrounding the Fedora Translation (L10n) Project. http://fedoraproject.org/wiki/L10N Contributing Writer: Runa Bhattacharjee ---FTP Meeting to be held on 4th November 2008--- FLSCo member Noriko Mizumoto announced the next meeting of the Fedora Translation Project to be held on the 4th of November 2008[1]. The time for the meeting is yet to be determined, with 1900 UTC and 2000 UTC being the two probable candidates. The meeting and agenda is open for all[2]. [1] https://www.redhat.com/archives/fedora-trans-list/2008-October/msg00215.html [2] http://fedoraproject.org/wiki/L10N/Meetings ---Package Rebuild requested by FTP--- Dimitris Glezos has requested the maintainers of the Fedora packages that were translated for Fedora 10 to rebuild them[3]. This would ensure that the translations submitted by the Fedora Translation Project members are included for all these packages. [3] https://www.redhat.com/archives/fedora-trans-list/2008-October/msg00209.html TQSG repository set to be moved Fabian Affolter has initiated discussions to move the the Translation Quick Start Guide (TQSG) to fedorahosted[4]. The move has been endorsed by Paul Frields on behalf of the Fedora Documentation team, subject to confirmation by FLSCo about the move and the ownership of the document[5]. The final decision, particularly about the VCS to be used, is pending at the moment. [4] https://www.redhat.com/archives/fedora-trans-list/2008-October/msg00203.html [5] https://www.redhat.com/archives/fedora-trans-list/2008-October/msg00222.html Dimitris Glezos nominated for the Fedora Board FLSCo Leader Dimitris Glezos has been nominated[6] by Max Spevack as one of the candidates for the upcoming Fedora Board elections to be held in December 2008. These elections would be held to elect two new members for the Fedora Board. [6] http://fedoraproject.org/wiki/Board/Elections/Nominations#Dimitris_Glezos_.28glezos.29 ---Diego Zacarao interviewed--- Fedora Translation project member Diego Zacarao (Rasther) was recently interviewed about his contributions to Transifex and Fedora Translation Project [7].(The Original version in Brazilian Portuguese[8].) [7] http://tinyurl.com/6kndvw [8] http://vladimirmelo.wordpress.com/2008/10/31/entrevista-com-diego-zacarao-sobre-o-transifex --Developments-- In this section the people, personalities and debates on the @fedora-devel mailing list are summarized. Contributing Writer: Oisin Feeley ---Resume from Suspend Problems with Intel i945--- Peter Robinson solicited[1] experiences with problems on netbooks in resuming from suspend from those using the latest Intel-2.5.0drivers. His problem suddenly manifested itself on a previously working EeePC 901: "It had worked previously and resumes OK but I get a black screen with a cursor and around that a square of garbled bits." Peter wondered what had changed recently in order to make suspend-resume stop working. [1] https://www.redhat.com/archives/fedora-devel-list/2008-October/msg02975.html Apparently similar failures were reported[2] by Jonathon Roberts for a Dell Mini[3] ,Tim Lauridsen on a ThinkPad T60[4] and Christoph Hoger[5] on a ThinkPad R61. Tim's problem seemed to be related to compiz. [2] https://www.redhat.com/archives/fedora-devel-list/2008-October/msg02977.html [3] https://www.redhat.com/archives/fedora-devel-list/2008-October/msg02977.html [4] https://www.redhat.com/archives/fedora-devel-list/2008-October/msg03005.html [5] https://www.redhat.com/archives/fedora-devel-list/2008-October/msg03033.html Jeremy Katz suggested[6] using the suspend quirks[7] , especially vbepost. Matthew Garret believed[8] this to be unnecessary as "i945 is perfectly capable of handling resume on its own in-kernel. The problem is more likely to be an excess of quirks interfering with that (or, alternatively, someone's broken the kernel)." [6] https://www.redhat.com/archives/fedora-devel-list/2008-October/msg02981.html [7] http://people.freedesktop.org/~hughsient/quirk/quirk-suspend-index.html [8] https://www.redhat.com/archives/fedora-devel-list/2008-October/msg02992.html Jesse Barnes (of the Intel Open Source Technology Center[9]) asked whether suspend worked from the console using: echo mem > /sys/power/state as this would indicate that there had been a regression in 2.5.0 as opposed to a kernel bug. Matthew Garrett thought that Jesse's suggestion would not test the same suspend pathway and that it would be better to do a: dbus-send --system --print-reply --dest=org.freedesktop.Hal \ /org/freedesktop/Hal/devices/computer \ org.freedesktop.Hal.Device.SystemPowerManagement.Suspend int32:0 Matthew begged[10] "Please (please, please) don't attempt to add resume quirks for anything with Intel video hardware now. It's only hiding kernel bugs." [9] http://software.intel.com/sites/oss/ [10] https://www.redhat.com/archives/fedora-devel-list/2008-November/msg00082.html ---Moving X from VT7 to VT1--- A gigantic multi-thread flamewar consumed many list participants after Will Woods made sure[1] that everyone knew that in Rawhide "X HAS MOVED FROM VT7 TO VT1. GDM specifically starts X on tty1, and upstart does not start a getty on tty1 in runlevel 5." The reason behind this change was that the boot process no longer uses the old RHGB but instead a flicker-free and faster replacement named Plymouth (see Fedora Magazine[2] for a full explanation). Fuel for the fire was provided by the surprise experienced by many posters who solely followed @fedora-devel for their information. A perception that changes made for the purposes of improving the desktop experience were occurring at the expense of the traditional server experience also seemed to irritate many. This was despite the fact that, as Dan Nicholson explained[3]: "Users who do not want a graphical boot set rc 3 as their default runlevel, and everything is the same as it always was with getty on tty1-6. If you then run startx, it will start on tty7. In rc 5, X is started on tty1 and getty is not. That's all there is to it." [1] https://www.redhat.com/archives/fedora-devel-list/2008-October/msg02422.html [2] http://fedoramagazine.wordpress.com/2008/10/21/interview-fedora-10s-better-startup/ [3] https://www.redhat.com/archives/fedora-devel-list/2008-October/msg02469.html In answer to a question from Till Maas it was confirmed[4] by Felix Miata that if one "[...] rebooted into runlevel 3, logged in on tty1, did telinit 5, got kdm on vt7, switched to tty1, [then there was] a normal shell prompt following typical X startup messages, and kdm still on vt7 [.]" [4] https://www.redhat.com/archives/fedora-devel-list/2008-October/msg02478.html Dan Nicholson also corrected[5] assumptions that the changes were made to improve boot speed with the information that it was to prevent the ugly flicker of VT switching during boot and asked "Why is it significant what tty any program runs on? Isn't the assumption that getty will be on tty1 just as faulty as the assumption X will be on tty7?" Shmuel Siegel gave[6] an answer which was repeated many times in the threads: "Because you are changing a user interface. What is going to happen when the user switches to tty1 and nothing happens? The basic logic of putting X on tty7 is to get it out of the way. Humans will use the lowest numbered ttys first. Besides breaking existing documentation, including advice on various forums, is not a good idea." Bill Nottingham added[7] to Dan's rationale: "1) Reducing the amount of flicker and useless mode switching on startup is definitely a good thing 2) From a logical standpoint, the first tty should be for the most important user interaction. If you're booting in text mode, that's a getty. If you're booting with a GUI login... that's the GUI." Callum Lerwick and Brian Wheeler exchanged[8] details of the "vast improvement[s]" including removal of up to twelve seconds which resulted from the lack of monitor resync delays.