thread-index: AcjPo7tlHNzKQhf+QpOBG25uOKYwCA== MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_000_0001_01C8CFEF.2E43AE60" Content-Location: http://www.postgresql.org/ Content-Class: urn:content-classes:message Importance: normal Priority: normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.607 This is a multi-part message in MIME format. ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: multipart/alternative; boundary="----=_NextPart_001_0002_01C8CFEF.2E43AE60" ------=_NextPart_001_0002_01C8CFEF.2E43AE60 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Skip site navigation (1) Skip section navigation (2)=20 Search =20 Peripheral Links * Text Size: Normal / Large=20 * Donate=20 * Contact=20 Header And Logo PostgreSQL=20 | The world's most advanced open source database.=20 Site Navigation =20 =20 * Home=20 * About=20 * Downloads=20 * Documentation=20 * Community=20 * Developers=20 * Support=20 PostgreSQL 8.3.3 and 8.2.9 released=20 The PostgreSQL Global Development Group has released minor versions 8.3.3 and 8.2.9. All users should upgrade to receive the latest fixes.=20 Download the latest updates =20 Featured User "The PostgreSQL group has a well deserved reputation for quality which has been evident to us since the very first public 8.0 beta we reviewed."=20 Javier Soltero, Hyperic LLC =20 Case Studies|More Quotes|Featured Users=20 Latest Releases 8.3.3: Source =C2=B7 Binary =C2=B7 Notes=20 8.2.9: Source =C2=B7 Binary =C2=B7 Notes=20 8.1.13: Source =C2=B7 Binary =C2=B7 Notes=20 8.0.17: Source =C2=B7 Binary =C2=B7 Notes=20 7.4.21: Source =C2=B7 Binary =C2=B7 Notes=20 Versions RSS Feed | Why should I upgrade? Shortcuts * Security=20 * International Sites=20 * Mailing Lists=20 * pgFoundry =20 * Wiki =20 * Report a Bug=20 * FAQs=20 Support Us PostgreSQL is free. Please support our work by making a donation.=20 Latest News=20 2008-06-11 PostgreSQL 8.3.3, 8.2.9 etc. Update Release=20 2008-06-05 pgAdmin III v1.8.4 released=20 2008-06-03 pgEdit 1.4 released=20 2008-05-29 Database .NET 2.1.3071 Released!=20 2008-05-28 Navicat PostgreSQL GUI for Mac OS X ver. 7.1.1 is now available!=20 2008-05-26 pgDesigner 1.2.7 Released=20 =20 * More=20 * Submit News =20 * News RSS Feed=20 Planet PostgreSQL =20 2008-06-16 David Fetter: PostgreSQL Weekly News - June 15 2008 =20 2008-06-13 Greg Sabino Mullane: Upgrading to 8.3 - MediaWiki lessons learned =20 2008-06-11 Hubert Lubaczewski: Waiting for 8.4 - waiting on/off =20 2008-06-11 Josh Berkus: pgDay San Francisco 2008 Call for Presentations =20 2008-06-11 Jignesh K. Shah: PostgreSQL Monitor - A demo =20 =20 * More =20 * PlanetPostgreSQL RSS Feed =20 Upcoming Events=20 2008-07-20=20 PDXPUG Day (OSCON) (Portland, OR, United States)=20 2008-08-03 =E2=80=93 2008-08-08=20 LinuxWorldExpo PostgreSQL Day and More! (San Francisco, CA, United States)=20 2008-09-26 =E2=80=93 2008-09-27=20 PGCon Brazil 2008 (Campinas, S=C3=A3o Paulo, Brazil)=20 Upcoming training=20 There are 18 training events in 2 countries scheduled over the next six months from 2ndQuadrant, Open Technology Group, Inc. and others.=20 Take a look at our schedule to find the training that you want.=20 =20 * More=20 * Submit Event * Events RSS Feed=20 Privacy Policy | Project hosted by our server sponsors . | Designed by tinysofa =20 Copyright =C2=A9 1996 =E2=80=93 2008 PostgreSQL Global Development Group = ------=_NextPart_001_0002_01C8CFEF.2E43AE60 Content-Type: text/html; charset="utf-8" Content-Transfer-Encoding: 8bit PostgreSQL: The world's most advanced open source database
Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

PostgreSQL 8.3.3 and 8.2.9 released

The PostgreSQL Global Development Group has released minor versions 8.3.3 and 8.2.9. All users should upgrade to receive the latest fixes.

Featured User

"The PostgreSQL group has a well deserved reputation for quality which has been evident to us since the very first public 8.0 beta we reviewed."
Javier Soltero, Hyperic LLC

Latest Releases

8.3.3: Source · Binary · Notes
8.2.9: Source · Binary · Notes
8.1.13: Source · Binary · Notes
8.0.17: Source · Binary · Notes
7.4.21: Source · Binary · Notes

Support Us

PostgreSQL is free. Please support our work by making a donation.
Privacy Policy | Project hosted by our server sponsors. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group
------=_NextPart_001_0002_01C8CFEF.2E43AE60-- ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: text/xml; charset="ks_c_5601-1987" Content-Transfer-Encoding: quoted-printable Content-ID: <000501c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline =0A= =0A= =0A= =0A= ::Planet PostgreSQL::=0A= http://www.planetpostgresql.org/=0A= en=0A= ::Planet PostgreSQL:: - = http://www.planetpostgresql.org/=0A= =0A= =0A= David Fetter: PostgreSQL Weekly News - June 15 2008=0A= = http://people.planetpostgresql.org/dfetter/index.php?/archives/177-= guid.html=0A= = http://people.planetpostgresql.org/dfetter/index.php?/archives/177-= PostgreSQL-Weekly-News-June-15-2008.html=0A= <strong>PostgreSQL Weekly News - June 15 = 2008</strong>=0A= <br />=0A= =0A= PostgreSQL 8.3.3, 8.2.9, etc. have been released. Upgrade as soon as=0A= <br />=0A= practical.=0A= <br /><a = href=3D"http://people.planetpostgresql.org/dfetter/index.php?/archiv= es/177-PostgreSQL-Weekly-News-June-15-2008.html#extended">Continu= e reading "PostgreSQL Weekly News - June 15 = 2008"</a>=0A= Mon, 16 Jun 2008 04:51:47 +0000=0A= =0A= =0A= Greg Sabino Mullane: Upgrading to 8.3 - MediaWiki lessons = learned=0A= = http://people.planetpostgresql.org/greg/index.php?/archives/136-gui= d.html=0A= = http://people.planetpostgresql.org/greg/index.php?/archives/136-Upg= rading-to-8.3-MediaWiki-lessons-learned.html=0A= <!--=0A= div.gsmcode {=0A= font-family:Courier,monospace;font-weight:bold; font-size:110%;=0A= border:1px solid #888888;line-height:130%;=0A= padding-left:1em; padding-right: 1em; margin-right :5em; margin-left:1em;=0A= color:black; background:#eeeeee;=0A= }=0A= div.gsmout {=0A= font-family:Courier,monospace;font-weight:bold; font-size:110%;=0A= border:1px solid #888888;line-height:130%;=0A= padding-left:1em; padding-right: 1em; margin-right:5em; margin-left:1em;=0A= color:black; background:#ddeeee;=0A= }=0A= =0A= span.gsminput { color: green; }=0A= span.gsmarg { color: #bb0000; font-weight: bolder; white-space: nowrap;}=0A= // -->=0A= =0A= <p>I just upgraded a large MediaWiki site from Postgres 8.1 to = 8.3, and thought I should share some of the lessons learned along the = way. Version 8.3 of PostgreSQL, more so than any other version in many = years, had some major changes that affect applications using Postgres. = The two most important ones are implicit cast removal, and moving = tsearch2 from a contrib module to core.</p>=0A= =0A= <p>In version 8.3, nearly all implicit casts were removed, which = means that one data type is not automatically converted to=0A= another, particularly inside of WHERE clauses. In other words, queries = will fail like this:</p><br /><a = href=3D"http://people.planetpostgresql.org/greg/index.php?/archives/= 136-Upgrading-to-8.3-MediaWiki-lessons-learned.html#extended">Con= tinue reading "Upgrading to 8.3 - MediaWiki lessons = learned"</a>=0A= Fri, 13 Jun 2008 13:15:15 +0000=0A= =0A= =0A= Hubert Lubaczewski: Waiting for 8.4 - waiting on/off=0A= http://www.depesz.com/?p=3D1215=0A= = http://www.depesz.com/index.php/2008/06/11/waiting-for-84-waiting-o= noff/=0A= Yes, finally! David Fetter wrote, and Heikki Linnakangas = committed patch which adds on/off arguments to \timing:=0A= =0A= Before you could simply do:=0A= \timing=0A= to switch timing information:=0A= # select 1;=0A= ?column?=0A= ----------=0A= 1=0A= (1 row)=0A= # \timing=0A= Timing is on.=0A= # select 1;=0A= ?column?=0A= ----------=0A= 1=0A= (1 row)=0A= Time: 0.364 ms=0A= # \timing=0A= Timing is off.=0A= # [...]=0A= Wed, 11 Jun 2008 20:33:39 +0000=0A= =0A= =0A= Josh Berkus: pgDay San Francisco 2008 Call for = Presentations=0A= = http://rss.ittoolbox.com/rss/25306@http://blogs.ittoolbox.com/datab= ase/soup=0A= = http://networking.ittoolbox.com/r/rss.asp?url=3Dhttp://blogs.ittool= box.com/database/soup/archives/pgday-san-francisco-2008-call-for-presenta= tions-25306=0A= The Call for Presentations for the pgDay at LinuxWorldExpo = 2008 is up.=0A= Wed, 11 Jun 2008 17:43:41 +0000=0A= =0A= =0A= Jignesh K. Shah: PostgreSQL Monitor - A demo=0A= = http://people.planetpostgresql.org/jkshah/index.php?/archives/4-gui= d.html=0A= = http://people.planetpostgresql.org/jkshah/index.php?/archives/4-Pos= tgreSQL-Monitor-A-demo.html=0A= <br />=0A= <a = href=3D"http://www.netbeans.org/community/releases/61/">Netb= eans 6.1</a><br />=0A= was released recently which includes PostgreSQL JDBC driver. It = had<br />=0A= been a while since I had done programming as a developer, so I = decided<br />=0A= to take it for a test drive to refresh my programming skills with it. = <a = href=3D"http://blogs.sun.com/jkshah/entry/postgresql_monitor_a_demo&= quot;>[Read More]</a><br />=0A= Wed, 11 Jun 2008 09:01:00 +0000=0A= =0A= =0A= Robert Treat: implementing no transaction mode in = postgresql=0A= = http://people.planetpostgresql.org/xzilla/index.php?/archives/346-g= uid.html=0A= = http://people.planetpostgresql.org/xzilla/index.php?/archives/346-i= mplementing-no-transaction-mode-in-postgresql.html=0A= The other day we were discussing the alter table add = foreign key implementation, and Tom Lane made this observation...<br = />=0A= <br />=0A= <blockquote>We'll never be able to match the performance of not = having transactions, either, but the community has never for a moment = considered having a "no transactions" mode.<br />=0A= </blockquote><br />=0A= My first thought was wondering just what removing transactions would = mean inside Postgres. The answers actually seemed to be things people = <strong>do want</strong> in a number of cases, and some of = them are items we have actually given people options for. Thinking about = it, I'd say the simplest summary of what you get using transactions is = our old friend <a = href=3D"http://people.planetpostgresql.org/xzilla/exit.php?url_id=3D= 2958&amp;entry_id=3D346" = title=3D"http://en.wikipedia.org/wiki/ACID">ACID</a>it= y. While everyone (well, everyone on a "real rdbms" anyway) = will tell you, there is no <a = href=3D"http://people.planetpostgresql.org/xzilla/exit.php?url_id=3D= 2959&amp;entry_id=3D346" = title=3D"http://en.wikipedia.org/wiki/Monty_Python_and_the_Holy_Grai= l">holier grail</a> than that of preserving the ideals of = ACIDity within your database, but as I think about it, I think a lot of = people are willing to trade portions of this contract to get around = implementation effects that cause trouble for end users.<br />=0A= <br /><a = href=3D"http://people.planetpostgresql.org/xzilla/index.php?/archive= s/346-implementing-no-transaction-mode-in-postgresql.html#extended"&= gt;Continue reading "implementing no transaction mode in = postgresql"</a>=0A= Wed, 11 Jun 2008 01:11:00 +0000=0A= =0A= =0A= Greg Sabino Mullane: check_postgres.pl version 1.8.1=0A= = http://people.planetpostgresql.org/greg/index.php?/archives/135-gui= d.html=0A= = http://people.planetpostgresql.org/greg/index.php?/archives/135-che= ck_postgres.pl-version-1.8.1.html=0A= <p>I just released version 1.8.1 of =0A= <a = href=3D"http://people.planetpostgresql.org/greg/exit.php?url_id=3D70= 2&amp;entry_id=3D135" = title=3D"http://bucardo.org/check_postgres/">check_postgres.= pl</a>, the Postgres Nagios monitoring script. Support for 8.0 = databases has been fixed up a bit. While some actions till cannot be run = on this old version, I did manage get the "check_bloat" action = working by rewriting the code to allow different SQL to be used for the = same action, depending on the target database's version. There is even a = local emulation of the pg_size_pretty function, so the check_bloat = output should look the same no matter which database you point it at. = The latest version of =0A= <a = href=3D"http://people.planetpostgresql.org/greg/exit.php?url_id=3D70= 3&amp;entry_id=3D135" = title=3D"http://bucardo.org/check_postgres/check_postgres.pl"&g= t;this Perl script</a> and =0A= <a = href=3D"http://people.planetpostgresql.org/greg/exit.php?url_id=3D70= 4&amp;entry_id=3D135" = title=3D"http://bucardo.org/check_postgres/check_postgres.pl.html&qu= ot;>its documentation</a> are available in the same place as = always. I'll be adding a couple mailing lists for it soon, to track = changes, and for general announcements and discussion. Until then, the = best way to monitor progress is to git-clone and git-pull your own copy, = or use the =0A= <a = href=3D"http://people.planetpostgresql.org/greg/exit.php?url_id=3D70= 5&amp;entry_id=3D135" = title=3D"http://git.postgresql.org/">git.postgresql.org = service</a>, which lets you view =0A= <a = href=3D"http://people.planetpostgresql.org/greg/exit.php?url=3DaHR0c= DovL2dpdC5wb3N0Z3Jlc3FsLm9yZy8/cD1jaGVja19wb3N0Z3Jlcy5naXQ7YT1jb21taXRkaW= ZmO2g9MDgyODQ4YmMyODJlZWFmMWIyZTRhZWM4NzdjYmFjYzhhMGFjNDY3MQ=3D=3D&am= p;entry_id=3D135" = title=3D"http://git.postgresql.org/?p=3Dcheck_postgres.git;a=3Dcommi= tdiff;h=3D082848bc282eeaf1b2e4aec877cbacc8a0ac4671">=0A= pretty commitdiffs</a> among other things.</p>=0A= Tue, 10 Jun 2008 03:08:55 +0000=0A= =0A= =0A= Francisco Figueiredo Jr: Two complains: Screen Responsiveness = and SuspendToRam/Disk=0A= tag:blogger.com,1999:blog-15237920.post-3647211835331522348=0A= = http://fxjr.blogspot.com/2008/06/two-complains-screen-responsivenes= s-and.html=0A= Hi all!<br /><br />Firstly, I'd like to say = that I love Gnu/Linux and please don't take me wrong. What I'm saying = here is based on what I see after using Gnu/Linux for the last 4 = years.<br /><br />About the suspend to ram/disk I understand = because it may be very difficult to have it working on all type of = hardware. But as it was already <a = href=3D"http://brainstorm.ubuntu.com/idea/94/">pointed out = on Ubuntu Brainstorm</a> and I think they are already working on = it.<br /><br />But now, at least to me, the biggest complain = I have is the performance of screen responsiveness of gnu/linux desktop. = I don't know if this is the correct term, but what I mean is the speed = the text is draw in the screen, the speed the windows are rendered and = so on. In summary, the perception I have of how fast the screen is = drawing its contents.<br /><br />My experience is based on = my old notebook. A Pentium4m with an intel 855gm with shared video = memory.<br />I'm using Ubuntu 8.04 with Gnome.<br /><br = />When I open firefox on my gmail page, for example, the scroll is = not so good. The scroll is too slow. On the same hardware, when I boot = on windows with firefox the scroll is not perfect but it is much better. = I can't even talk about processor usage of firefox. I don't know why = this happens. But after so much time using Gnome when I boot up again on = windows so a friend of mine who only used windows could work on it, I = saw that windowing and screen performance was very very different. I = just don't know why it is this way. Another point: Just to change from = one tab to another on firefox on my system could make me wait for = something like 0.5 seconds. Again, I'd like to say that on windows on = the same machine, firefox didn't take so much time like this.<br = /><br />So, I don't know if the problem is in firefox itself. = Or somewhere else. I noticed that if I use XFCE I get a better = performance on screen rendering but not so much. So, maybe it is Gnome = the problem? I noticed that Konqueror on KDE seemed to give me a better = screen responsiveness compared to gnome and xfce. Maybe it is a GTK = problem? I also thought it could be a problem of X11 but I don't know = very well about it to say if it has so much to contribute to this = problem or not.<br /><br />This is what I got with firefox = only. If I talk about MPlayer and video performance for example, we have = a similar history. On windows, the performance of mplayer is much = better. Even when Ubuntu is using XV output driver.<br /><br = />So, please, if someone can explain me this difference and maybe = some why's about it. I don't know if I'm saying non sense things and = please, correct me if I am. But I really really whish those screen = related performance problems were excluded from my gnu/linux = experience.<br /><br />Just another comparison... Before I = bought my macbook, I used Ubuntu 8.04 on a sony vaio with a nvidia card = 8400GT with 256MB of dedicated video memory and while the screen = responsiveness was much much better, of course, I still could see some = lags while scrolling the gmail page and while chaging from one tab to = other. I had vista installed on it and firefox didn't showed this = problem while I was using ff with vista. I don't know if this is a good = comparison as I didn't take any numbers of it, but it gives me some = practical results about what I feel when using windows, os x and = gnu/linux. And as a big fan and advocate of gnu/linux, I repeat, I = really really wish those problems to be solved.<br /><br = />Thank you in advance for you time. Please, send your = comments.=0A= Mon, 09 Jun 2008 21:09:50 +0000=0A= =0A= =0A= Francisco Figueiredo Jr: One week of MacBook later....=0A= tag:blogger.com,1999:blog-15237920.post-9154731577809856197=0A= = http://fxjr.blogspot.com/2008/06/one-week-of-macbook-later.html=0A= <div><br /></div><div>Well, = Macbook continues to be awesome, but I already have some complains with = the software... :(</div><div><br = /></div><div>No ABNT2 keyboard support! Just after one = week of research and I still had to make a modification in the keyboard = layout, I finally could find one which worked on my ABNT2 keyboard. = Thanks to <a = href=3D"http://forums.appleinsider.com/showthread.php?t=3D72676"= ;>this post</a>=C2=A0I could get a 99% working keyboard layout. = I just had to swap back the \ | and ' " mappings. I have to admit = I'm really upset with Apple for not providing a keyboard mapping which = works on Brazilian Portuguese ABNT2 = keyboards.</div><div><br = /></div><div>Another difficult I faced was to use the = external monitor only. On gnu/linux I just used the xrandr command = xrandr --output LCD off and it was done. Thanks to <a = href=3D"http://forums.macrumors.com/showthread.php?t=3D407969"&= gt;this post</a>=C2=A0I could get it working by connect my = external LCD monitor, close the lid, wait for macbook to sleep and so = wake it up with my external keyboard. At least it is working ok = now.</div><div><br /></div><div>Another = thing which is making me nuts is that the spaces feature always wants to = bring to front the finder window and not the window which had focus = before I changed the virtual desktop. I already installed the MacOS = 10.5.3 combo update which says something about fixing this but for me it = didn't work :(</div><div><br = /></div><div>I will stay with OSX for while, now that my = keyboard and monitor problems are solved. But I have to say that I was = much more comfortable with the gnome gnu/linux environment. Maybe I = still need time to get used to all this. In another post I will talk = about what make me nuts with gnu/linux and desktop. Tip: Power = management (suspend to ram/disk) and X11 performance (screen = updates).=C2=A0</div><div><br = /></div><div>See you.</div>=0A= Mon, 09 Jun 2008 13:19:50 +0000=0A= =0A= =0A= David Fetter: PostgreSQL Weekly News - June 08 2008=0A= = http://people.planetpostgresql.org/dfetter/index.php?/archives/176-= guid.html=0A= = http://people.planetpostgresql.org/dfetter/index.php?/archives/176-= PostgreSQL-Weekly-News-June-08-2008.html=0A= <strong>PostgreSQL Weekly News - June 08 = 2008</strong>=0A= <br />=0A= =0A= PostgreSQL 8.3.3, et al. will be out soon. Get ready to upgrade!=0A= <br />=0A= =0A= <br /><a = href=3D"http://people.planetpostgresql.org/dfetter/index.php?/archiv= es/176-PostgreSQL-Weekly-News-June-08-2008.html#extended">Continu= e reading "PostgreSQL Weekly News - June 08 = 2008"</a>=0A= Mon, 09 Jun 2008 03:22:54 +0000=0A= =0A= =0A= Leo Hsu and Regina Obe: PostgreSQL 8.4 goodies in store=0A= = http://www.postgresonline.com/journal/index.php?/archives/56-guid.h= tml=0A= = http://www.postgresonline.com/journal/index.php?/archives/56-Postgr= eSQL-8.4-goodies-in-store.html=0A= <p>The PostgreSQL 8.4 planned release is March 1, = 2009 and is outlined in the <a = href=3D"http://wiki.postgresql.org/wiki/PostgreSQL_8.4_Development_P= lan" target=3D"_blank">PostgreSQL 8.4 Development = plan</a>.=0A= It has just passed its May 2008 commit fest milestone and is currently = in its July 2008 Commit Fest. Lots of PostgreSQL Planet bloggers have = started showcasing some of the new features in store.=0A= We will briefly list our favorite planned and already committed = patches.</p> <br /><a = href=3D"http://www.postgresonline.com/journal/index.php?/archives/56= -PostgreSQL-8.4-goodies-in-store.html#extended">Continue reading = "PostgreSQL 8.4 goodies in store"</a>=0A= Sun, 08 Jun 2008 23:57:20 +0000=0A= =0A= =0A= Bruce Momjian: Postgres Is Hot=0A= http://momjian.us/main/blogs/pgblog.html#June_7_2008=0A= http://momjian.us/main/blogs/pgblog.html#June_7_2008=0A= <p>I have attended or expect to attend seven = dedicated Postgres conferences this year, in Japan, San Francisco, = Oregon,=0A= Ottawa, Maryland, Brazil, and Italy; we have never had so much = conference activity.=0A= </p>=0A= <p><a = href=3D"http://momjian.us/main/blogs/pgblog.html#June_7_2008"&g= t;(Read more)</a></p>=0A= Sat, 07 Jun 2008 16:00:00 +0000=0A= =0A= =0A= David Wheeler: Introducing pgTAP=0A= = tag:justatheory.com,2008:/computers/databases/postgresql/introducin= g_pgtap=0A= = http://justatheory.com/computers/databases/postgresql/introducing_p= gtap.html=0A= <div><p>So I started working on a new = PostgreSQL data type this week. More on that=0A= soon; in the meantime, I wanted to create a test suite for it, and = wasn't sure=0A= where to go. The only PostgreSQL tests I've seen are those distributed = with=0A= Elein=0A= Mustain's <a = href=3D"http://www.varlena.com/varlena/GeneralBits/Tidbits/email_tes= t.sql" title=3D"Testing the email data = type">tests</a> for the email data type she=0A= created in a <a = href=3D"http://www.varlena.com/GeneralBits/128.php" = title=3D"Base Type using Domains">PostgreSQL General = Bits</a> posting from a couple of years=0A= ago. I used the same approach myself for=0A= my <a href=3D"http://pgfoundry.org/projects/gtin/" = title=3D"GTIN data type project info">GTIN data = type</a>, but it was rather hard to use: I had to pay very=0A= close attention to what was output in order to tell the description = output=0A= from the test output. It was quite a PITA, = actually.</p><p><a = href=3D"http://justatheory.com/computers/databases/postgresql/introd= ucing_pgtap.html">Read More = =C2=BB</a></p></div>=0A= Sat, 07 Jun 2008 05:24:00 +0000=0A= =0A= =0A= Leo Hsu and Regina Obe: PostgreSQL 8.3 TSearch Cheat Sheet = Overview=0A= = http://www.postgresonline.com/journal/index.php?/archives/55-guid.h= tml=0A= = http://www.postgresonline.com/journal/index.php?/archives/55-Postgr= eSQL-8.3-TSearch-Cheat-Sheet-Overview.html=0A= <p>Below is a Thumbnail view of a PostgreSQL 8.3 = TSearch Cheat Sheet =0A= that covers PostgreSQL 8.3 Full Text search engine constructs. =0A= </p>=0A= <a = href=3D"http://www.postgresonline.com/images/journal/postgresql83tse= arch_cheatsheet_1.png"><img = src=3D"http://www.postgresonline.com/images/journal/postgresql83tsea= rch_cheatsheet_small_1.jpg" border=3D"1" = /></a><br /><br />=0A= <a = href=3D"http://www.postgresonline.com/images/journal/postgresql83tse= arch_cheatsheet_2.png"><img = src=3D"http://www.postgresonline.com/images/journal/postgresql83tsea= rch_cheatsheet_small_2.jpg" border=3D"1" /></a>=0A= <p>=0A= This one we broke into two pages so its a bit more readable=0A= than our PostgreSQL 8.3 cheat sheet.=0A= </p>=0A= <p>PDF landscape version 8.5 x 11" of this cheatsheet is = available at <a = href=3D"http://www.postgresonline.com/special_feature.php?sf_name=3D= postgresql83tsearch_cheatsheet&amp;outputformat=3Dpdf" = target=3D"_blank">PostgreSQL 8.3 TSearch Full-Text Search = in PDF 8/12 by 11</a> and also available in=0A= <a = href=3D"http://www.postgresonline.com/special_feature.php?sf_name=3D= postgresql83tsearch_cheatsheet&amp;outputformat=3Da4pdf" = target=3D"_blank">PDF A4 format</a> and <a = href=3D"http://www.postgresonline.com/special_feature.php?sf_name=3D= postgresql83tsearch_cheatsheet&amp;outputformat=3Dhtml" = target=3D"_blank">HTML</a>.=0A= </p>=0A= Thu, 05 Jun 2008 21:11:00 +0000=0A= =0A= =0A= Francisco Figueiredo Jr: Thank you for so many OSX tips!!=0A= tag:blogger.com,1999:blog-15237920.post-2996180754796862475=0A= = http://fxjr.blogspot.com/2008/06/thank-you-for-so-many-osx-tips.htm= l=0A= Wow! I was very surprised by the big number of feedback I = got when asking tips for my new MacBook! I'd like to say you a big THANK = YOU! You are great.<br /><br />I already installed iStat = Pro. I liked it very much.<br /><br />I also installed = Adium, NoeOffice, Transmission, Songbird and I'm still downloading and = installing other suggestions.<br /><br />One drawback I saw = was that after installing some applications, my solid rock brand new = MacBook started to hang when shutting down! :O<br /><br />I = uninstalled iStat Pro as I think it is the only low level thing which = could give me this type of problem. Until now, I already shut down my = laptop two times and the problem seems to be solved. I installed the = 4.6 version on my OSX 10.5.3.<br />I will try another version or a = previous one later.<br /><br />I don't now but I didn't like = the SongBird. I don't know why yet. I liked very much the Rhythmbox and = I'm sad I can't get it on my Mac :(. For while I think I will keep using = iTunes. But I'd rather use some other open source audio player.<br = /><br />I followed the suggestion of creating a new folder = inside the Applications special place. (This makes me ask: Is there a = way to add other folders to the Places together with my home folder and = the applications folder itself?)<br />I also put this folder near = the trashcan in the dock so I can access it easily. I just couldn't use = the long click where I could see the hierarchical list of applications = through menus. Maybe I need more explanation?? :) Anyway,thank you for = your excellent explanations of many other aspects related about OSX. I = didn't know I would need to be so cautious about software updates.<br = /><br />Another problem I had was that OSX seemed to not = recognize my wireless keyboard correctly. It is an ABNT2 Brazilian = Portuguese keyboard. When I connected it it showed me some keyboard = options but I couldn't get my =C3=A7 key to work on it. :( Maybe I'm = doing something wrong. I will try again later.<br /><br = />Another problem I faced was when using my external LCD television. = It has a resolution of 1360x768 and I couldn't use mirror with native = screen resolution. I only could use it with extended desktop. I'd like = to be able to turn off laptop lcd and just use the external monitor. Is = this possible? A friend of mine said I could close the laptop lid but I = think this could make my macbook heat up.<br /><br />Other = than that, everything seems to be working very well. I will post here = more things I find about OSX.<br /><br />Again, I'd like to = thank everybody who spent some time to read my post and comment it. = Thank you very much! I'm a much happier Mac user now. :)<br = /><br />That's it. See you!<br /><br />P.S.: Thanks = for the Pratchett quote indication. :) I hope my sanity is not so in = danger because of so many exclamation marks. Just to be sure, I used = fewer ones this time :)=0A= Thu, 05 Jun 2008 20:35:14 +0000=0A= =0A= =0A= Francisco Figueiredo Jr: I finally got my MacBook!! = Tips???=0A= tag:blogger.com,1999:blog-15237920.post-7555360917711239356=0A= = http://fxjr.blogspot.com/2008/06/i-finally-got-my-macbook-tips.html= =0A= Hi all!!<br /><br />I finally got a MacBook = 13.3"!! This baby is awesome!! I'm enjoying it very much. :) I = still didn't install Ubuntu on it because I'd like to play a little bit = with MacOS.<br /><br />My first impressions of MacOS is that = it is a very nice OS. I'd like the Aqua UI was opensource so I could = have a complete OpenSource OS stack. At least Darwin is = OpenSource.<br /><br />Now I need to familiarize with MacOS = and its utilities. So, if you have tips, links, suggestions for nice = opensource applications I can install on my MacOS, please let me = know.<br /><br />I already have Mono installed. Thanks mono = guys who provide the MacOS install package. It was pretty easy to = install. I'd like to know if I can use Banshee on my Mac. I know iTunes = is very good, but I'd like to use an OpenSource player. Do you know of = anyone for MacOS? I couldn't find anyone.<br /><br />I also = installed MPlayer which worked perfectly! The MacOS sound is = awesome!!<br /><br />I also would like to know of a good IRC = client, a good torrent client, and more important: I'd like to know some = monitoring tools, like network speed, battery information, fan = information, cpu etc. Which could be added to mac menu and give me = information directly.<br /><br /><br />Thanks = everybody in advance.=0A= Wed, 04 Jun 2008 18:24:26 +0000=0A= =0A= =0A= Francisco Figueiredo Jr: Back to Brazil!!!=0A= tag:blogger.com,1999:blog-15237920.post-2851274484902935351=0A= http://fxjr.blogspot.com/2008/06/back-to-brazil.html=0A= Hi, all!<br /><br />I'm back to Brazil! And I = have to say that I loved Canada!! I'm seriously thinking about applying = for an immigration process. Let's see what I can get...<br = /><br />I could see a lot of things and I liked very much = Canadian people. They are very nice! For me it was a great pleasure to = be in such a place! I hope to go back there some day.<br /><br = />I visited Niagara Falls, went for the first time to a casino. In = Brazil they are not allowed. I met a lot of people from many places in = the world: Korea, Japan, Belgium, England, Australia, USA and so on. I = enjoyed very much to stay in a hostel. I never stayed in one before and = I liked very much the experience.<br /><br />That's it! I = will post some pictures later and more impressions too.=0A= Wed, 04 Jun 2008 17:37:11 +0000=0A= =0A= =0A= Selena Deckelmann: Call for proposals for PDXPUG PgDay, due June = 20, 2008=0A= = http://www.chesnok.com/daily/2008/06/02/call-for-proposals-for-pdxp= ug-pgday-due-june-20-2007/=0A= = http://www.chesnok.com/daily/2008/06/02/call-for-proposals-for-pdxp= ug-pgday-due-june-20-2007/=0A= <p><img = src=3D"http://www.chesnok.com/daily/wp-content/uploads/2008/06/dsc_0= 015.JPG" alt=3D"pgday 2007" width=3D"450px" = height=3D"299px" /><br />=0A= (Photo from PgDay 2007)</p>=0A= <p>Please submit a talk! The call will be open for 2 weeks and = proposals are due June 20th. Follow the link for details on = submitting.</p>=0A= <p><a href=3D"http://pugs.postgresql.org/node/400 = ">http://pugs.postgresql.org/node/400<br />=0A= </a></p>=0A= <blockquote><p>=0A= PDXPUG PgDay will be on July 20, 2008. This is a one-day conference = happening the day before OSCON at the Oregon Convention Center.</p>=0A= <p>We are inviting anyone who has something interesting to share = about PostgreSQL to send us a proposal!</p>=0A= <p>We&#8217;d like to have at least one 1.5 hour tutorial and = up to five 45-minute talks.</p>=0A= <p>We welcome talks in any of the following areas:</p>=0A= <p>* Case studies involving interesting and innovative uses of = PostgreSQL from an application developer, PostgreSQL developer or = administrative user perspective<br />=0A= * Converting from other databases to PostgreSQL<br />=0A= * Howtos for database administration tasks (partitioning, backups, = replication, writing stored procedures)<br />=0A= * Practical advice on configuration, monitoring and database management=0A= </p></blockquote>=0A= Wed, 04 Jun 2008 04:32:54 +0000=0A= =0A= =0A= Robert Treat: ossdb-snapshot, lvm database snapshot tool=0A= = http://people.planetpostgresql.org/xzilla/index.php?/archives/344-g= uid.html=0A= = http://people.planetpostgresql.org/xzilla/index.php?/archives/344-o= ssdb-snapshot,-lvm-database-snapshot-tool.html=0A= Just tossing this out there on the chance it might be = useful for others. This script, dubbed <a = href=3D"http://people.planetpostgresql.org/xzilla/uploads/ossdb-snap= shot-0.2.0.tar.gz">ossdb-snapshot</a>, is based on the = <a = href=3D"http://people.planetpostgresql.org/xzilla/exit.php?url_id=3D= 2956&amp;entry_id=3D344" = title=3D"http://jcole.us/software/mysql-snapshot/">mysql-sna= pshot</a> tool from <a = href=3D"http://people.planetpostgresql.org/xzilla/exit.php?url_id=3D= 2957&amp;entry_id=3D344" = title=3D"http://jcole.us/blog/">Jeremy Cole</a>. The = idea is to simplify management of lvm snapshots for purposes of creating = postgresql snapshot style backups (I've left the mysql pieces in place = in case anyone wants to make it a truely cross-db app), either for = backup or pitr setup. Quick example after the jump.<br />=0A= <br />=0A= <br />=0A= <br /><a = href=3D"http://people.planetpostgresql.org/xzilla/index.php?/archive= s/344-ossdb-snapshot,-lvm-database-snapshot-tool.html#extended">C= ontinue reading "ossdb-snapshot, lvm database snapshot = tool"</a>=0A= Tue, 03 Jun 2008 15:28:00 +0000=0A= =0A= =0A= Pavel Stehule: EXECUTE USING feature in PostgreSQL 8.4=0A= = tag:blogger.com,1999:blog-8839574367290288724.post-1565319940352821= 930=0A= = http://okbob.blogspot.com/2008/06/execute-using-feature-in-postgres= ql-84.html=0A= Hello,<br /><br />My motivation for = implementation USING feature in EXECUTE was simplifycation and = securisation of dynamic SQL. I didn't thing about execution plans. I am = speaking on plpgsql's lectures about risks related to dynamic SQL = (mainly security risks). Prepared statements are safe, but has some = gotcha <a = href=3D"http://www.depesz.com/index.php/2008/05/10/prepared-statemen= ts-gotcha/">http://www.depesz.com/index.php/2008/05/10/prepared-s= tatements-gotcha/</a> , so there are some situations, where = prepared statements are suboptimal. In plpgsql we have to use dynamic = SQL<br /><pre><br />DECLARE<br /> a = integer;<br /> r integer;<br />BEGIN</pre><br = /> -- prepared statement<br /> SELECT INTO r * FROM test = WHERE c =3D a;<br /> -- classic dynamic SQL witg risk of SQL = injection<br /> EXECUTE 'SELECT * FROM test WHERE c =3D ' || a = INTO r;<br /> -- dynamic SQL with USING (secure and with well = execution plan)<br /> EXECUTE 'SELECT * FROM test WHERE c =3D $1' = INTO r USING a;<br /><br />When we use USING clause, then = dynamic SQL are secure (and readable too) . Every evalaution generate = new execution plan with knowleage actual params. It's disadvantage (it's = need some time - so don't use it in cycles), and advantage (generated = plan will be propably better - not allways (sometimes we must play = statistic alchemy game)).<br /><br />I unlike SELECT = composition. It's bad style:<br /><pre><br />CREATE OR = REPLACE FUNCTION get_names(age integer, class integer)<br = />RETURNS SETOF persons AS $$<br />DECLARE sql varchar =3D = 'SELECT * FROM persons ';<br />BEGIN<br /> IF age IS NOT = NULL THEN<br /> sql :=3D sql || 'WHERE age =3D ' || age;<br = /> END IF;<br /> IF class IS NOT NULL THEN<br /> IF = strpos(sql, 'WHERE') <br /> 0 THEN<br /> sql :=3D sql || = ' AND ';<br /> ELSE<br /> sql :=3D sql || 'WHERE = ';<br /> END IF;<br /> sql :=3D sql || ' class =3D ' || = class;<br /> END IF;<br /> RETURN QUERY EXECUTE sql;<br = />END $$ LANGUAGE plpgsql;<br /></pre><br />WITH = USING clause I should to write:<br /><pre><br = />..<br />BEGIN<br /> RETURN QUERY EXECUTE<br /> = 'SELECT * FROM persons<br /> WHERE ($1 IS NULL or age =3D = $1)<br /> AND ($2 IS NULL or class =3D $2)<br = /> USING age, class;<br />END; $$ LANGUAGE plpgsql;<br = /></pre><br />Optimaliser do predicat's reduction = self.<br /><br />Tom Lane demonstarated other example of = EXECUTE USING:<br /><pre><br />create or replace = function foo() returns trigger as $$<br />declare<br /> t = text;<br />begin<br /> for i in 1 .. tg_argv[0] loop<br = /> execute 'select cast ( $1 . ' || tg_argv[i] || ' as text)'<br = /> into t using new;<br /> raise notice '% =3D %', = tg_argv[i], t;<br /> end loop;<br /> return new;<br = />end $$ language plpgsql;<br /></pre><br />This = code shows values of all field of NEW record in trigger's body. It = wasn't possible before EXECUTE USING in plpgsql.=0A= Tue, 03 Jun 2008 02:58:21 +0000=0A= =0A= =0A= David Fetter: PostgreSQL Weekly News - June 01 2008=0A= = http://people.planetpostgresql.org/dfetter/index.php?/archives/175-= guid.html=0A= = http://people.planetpostgresql.org/dfetter/index.php?/archives/175-= PostgreSQL-Weekly-News-June-01-2008.html=0A= <strong>PostgreSQL Weekly News - June 01 = 2008</strong>=0A= <br />=0A= =0A= Core has announced the goal of including easy-to-use WAL-based=0A= <br />=0A= replication in PostgreSQL.=0A= <br /><a = href=3D"http://people.planetpostgresql.org/dfetter/index.php?/archiv= es/175-PostgreSQL-Weekly-News-June-01-2008.html#extended">Continu= e reading "PostgreSQL Weekly News - June 01 = 2008"</a>=0A= Sun, 01 Jun 2008 23:40:48 +0000=0A= =0A= =0A= Bruce Momjian: Traveling Every Month=0A= http://momjian.us/main/blogs/pgblog.html#June_1_2008=0A= http://momjian.us/main/blogs/pgblog.html#June_1_2008=0A= <p>I am back to traveling once a month. I have = taken a trip once every month since November, 2007, and have events=0A= scheduled every month through October, 2008. I last had this heavy = travel schedule in 2003/2004. The two reasons for=0A= the increase are the greater number of Postgres-only conferences, and = the desire by=0A= <a = href=3D"http://www.enterprisedb.com/">EnterpriseDB</a>= to be more involved and supportive of the Postgres community.=0A= </p>=0A= Sun, 01 Jun 2008 16:00:00 +0000=0A= =0A= =0A= Bruce Momjian: Master/Slave Replication=0A= http://momjian.us/main/blogs/pgblog.html#May_30_2008=0A= http://momjian.us/main/blogs/pgblog.html#May_30_2008=0A= <p>The Postgres core team has <a = href=3D"http://archives.postgresql.org/pgsql-hackers/2008-05/msg0091= 3.php">announced</a> that there=0A= is now a goal of integrating log-shipping master/slave replication into = the core Postgres database. (Previously all=0A= replication was done as an add-on.) The first goal is to allow = transaction log shipping as part of each transaction=0A= commit; later, slaves should be able to execute read-only queries.=0A= </p>=0A= Fri, 30 May 2008 16:00:00 +0000=0A= =0A= =0A= Benjamin Reed: KDE 4.1 Beta 1 for Mac OS X=0A= = http://www.raccoonfink.com/2008/05/kde-41-beta-1-for-mac-os-x.html<= /guid>=0A= = http://www.raccoonfink.com/2008/05/kde-41-beta-1-for-mac-os-x.html?= utm_source=3Drss&utm_medium=3Drss&campaign=3Dkde_41_beta_1_for_ma= c_os_x=0A= <p>=0A= With the help of a number of folks, I'm happy to announce the latest = KDE/Mac snapshot, based on <a = href=3D"http://www.kde.org/announcements/announce-4.1-beta1.php"= ;>KDE 4.1 Beta 1</a>. Also, while it's been available for a = while, I'd like to point out that KDE/Mac now has an official website, = at <a = href=3D"http://mac.kde.org/">mac.kde.org</a>, using = Benjamin Dietrich's pretty design.=0A= </p>=0A= <p>=0A= Torrents are all seeded, and <a = href=3D"http://mac.kde.org/?id=3Ddownload">downloadable</= a>.=0A= </p>=0A= <p>=0A= As always, questions are welcome in the comments, on the kde-mac list, = or in a bug report. =3D)=0A= </p>=0A= <p>=0A= <a = href=3D"http://www.raccoonfink.com/2008/05/kde-41-beta-1-for-mac-os-= x.html#comments" title=3D"Comment on: KDE 4.1 Beta 1 for Mac = OS X">Comments</a></p>=0A= Thu, 29 May 2008 19:25:10 +0000=0A= =0A= =0A= Robert Treat: PGCon 2008 Wrap-up=0A= = http://people.planetpostgresql.org/xzilla/index.php?/archives/343-g= uid.html=0A= = http://people.planetpostgresql.org/xzilla/index.php?/archives/343-P= GCon-2008-Wrap-up.html=0A= Ok, in an effort to get people to stop harassing me about = a lack of posting during <a = href=3D"http://people.planetpostgresql.org/xzilla/exit.php?url_id=3D= 2950&amp;entry_id=3D343" = title=3D"http://www.PGCon.org/2008/">PGCon</a>, I now = present to you my official PGCon wrap up. I'm skipping the technical = breakdown on talks for the most part, you can get their slides from the = conference site (and yes, I have uploaded both the <a = href=3D"http://people.planetpostgresql.org/xzilla/exit.php?url_id=3D= 2951&amp;entry_id=3D343" = title=3D"http://www.PGCon.org/2008/schedule/events/97.en.html"&= gt;anti-pattern</a> slides and the <a = href=3D"http://people.planetpostgresql.org/xzilla/exit.php?url_id=3D= 2952&amp;entry_id=3D343" = title=3D"http://www.PGCon.org/2008/schedule/events/60.en.html"&= gt;lightning talk slides</a>), but I did jot down some notes = during last week on some items I thought were worth mentioning. The = biggest thing to come out of this past week to me was recognition of the = continued growth of the postgresql community. With a number of <a = href=3D"http://people.planetpostgresql.org/xzilla/exit.php?url_id=3D= 2937&amp;entry_id=3D343" = title=3D"http://www.postgresqlconference.org/">regional</= a> <a = href=3D"http://people.planetpostgresql.org/xzilla/exit.php?url_id=3D= 2938&amp;entry_id=3D343" = title=3D"http://www.pgday.org/it/">conferences</a> = springing up over the past year, I wondered if PGCon would be able to = match the experience from last time, and was happy to see that it far = exceeded it. That said, here are some other thoughts and ideas from the = week that was PGCon 2008.<br />=0A= <br />=0A= <br /><a = href=3D"http://people.planetpostgresql.org/xzilla/index.php?/archive= s/343-PGCon-2008-Wrap-up.html#extended">Continue reading = "PGCon 2008 Wrap-up"</a>=0A= Thu, 29 May 2008 19:19:14 +0000=0A= =0A= =0A= Josh Berkus: State of Lightning Talks 2008 Call for = Participation=0A= = http://rss.ittoolbox.com/rss/24991@http://blogs.ittoolbox.com/datab= ase/soup=0A= = http://networking.ittoolbox.com/r/rss.asp?url=3Dhttp://blogs.ittool= box.com/database/soup/archives/state-of-lightning-talks-2008-call-for-par= ticipation-24991=0A= I'm now taking submissions for the 2008 State of Lightning = Talks at OSCON 2008.=0A= Wed, 28 May 2008 21:43:15 +0000=0A= =0A= =0A= Selena Deckelmann: PgCon 2008 - big announcements, community = conversations=0A= = http://www.chesnok.com/daily/2008/05/28/pgcon-2008-big-announcement= s-community-conversations/=0A= = http://www.chesnok.com/daily/2008/05/28/pgcon-2008-big-announcement= s-community-conversations/=0A= <p>PgCon was a very exciting conference, with a lot = of people from Europe, Asia, Australia and South America traveling to be = part of it. I read that 175 people attended, and based on how crowded = both parties were, it&#8217;s not hard to believe!</p>=0A= <p>The biggest announcement for me was that the PostgreSQL Europe = is finally a non-profit organization! I made a slide for my lightning = talk with Magnus, Gabriele, Jean-Paul and Andreas on it: </p>=0A= <p><center><a = href=3D"http://www.chesnok.com/daily/2008/05/28/pgcon-2008-big-annou= ncements-community-conversations/pgeu-announced/" = rel=3D"attachment wp-att-358" title=3D"PgEU = announced"><img = src=3D"http://www.chesnok.com/daily/wp-content/uploads/2008/05/user-= groups-1.jpg" alt=3D"PgEU announced" = width=3D"300px" /></a></center></p>=0A= <p>I got a ton of great feedback about the <a = href=3D"http://www.chesnok.com/daily/2008/05/22/pgcon-lightning-talk= -user-groupalooza/">User Groupalooza slides</a>. I also = enjoyed meeting Jean-Paul Argudo, a fellow Drupaler. </p>=0A= <p>There were a bunch of community-focused conversations, some = focused inward on developers, some looking out to the rest of the world = from inside Pg, and others from the outside looking in: </p>=0A= <ul>=0A= <li><a = href=3D"http://www.pgcon.org/2008/schedule/events/98.en.html"&g= t;Bruce Momjian&#8217;s Keynote</a> - Bruce looked at the = future of Pg development from the perspective of a 12-year veteran. This = was an inspirational talk, and many people referenced his thoughts = throughout the rest of the conference. </li>=0A= <li><a = href=3D"http://www.pgcon.org/2008/schedule/events/85.en.html"&g= t;Andrew Sullivan&#8217;s Pg Project management</a> - Andrew = started a conversation among Pg developers about how development is = *supposed* to happen, how it actually happens, and what the dev = community might do to change things or leave them as they are</li>=0A= <li><a = href=3D"http://www.pgcon.org/2008/schedule/events/111.en.html"&= gt;Susanne Ebrecht&#8217;s talk on what PostgreSQL could learn from = MySQL</a></li>=0A= <li><a = href=3D"http://www.pgcon.org/2008/schedule/events/60.en.html"&g= t;Lightning Talks</a> - I did the lightning talk on User = Groups</li>=0A= <li><a = href=3D"http://www.pgcon.org/2008/schedule/events/64.en.html"&g= t;Peter Eisenstraut&#8217;s talk on Release Management</a>. = This talk was a lot about the infrastructure and an overview of how the = project manages software releases. It included a list of active = developers, overview of what -core actually does, and descriptions of = various duties people are performing to maintain postgresql.org and the = associated services.</li>=0A= </ul>=0A= <p>All the talks were recorded, so I look forward to listening to = them again - without the distraction of Twitter! <img = src=3D"http://www.chesnok.com/daily/wp-includes/images/smilies/icon_= smile.gif" alt=3D":)" class=3D"wp-smiley" /> = </p>=0A= <p>A couple talks I thought were really great for web developers = were: </p>=0A= <ul>=0A= <li><a = href=3D"http://www.pgcon.org/2008/schedule/events/75.en.html"&g= t;Magnus Hagander&#8217;s search.postgresql.org</a> talk gave = some great examples and code showing how to use PostgreSQL&#8217;s = tsearch capabilities with a PHP-based website. </li>=0A= <li><a = href=3D"http://www.pgcon.org/2008/schedule/events/95.en.html"&g= t;Clark Evan&#8217;s talk on HTSQL</a>, a REST-ful web = inteface application. It looks pretty cool and I&#8217;m interested = in trying it out. They are using it for medical records report = generation and have even given the ability to generate queries to the = end users. </li>=0A= </ul>=0A= <p>Thanks so much to Dan who got me to the conference this year! = I learned a lot, and really enjoyed meeting so many people that = I&#8217;ve only communicated with over email for the past three = years.</p>=0A= Wed, 28 May 2008 17:52:47 +0000=0A= =0A= =0A= Greg Sabino Mullane: Verifying master-slave replication with = check_postgres.pl=0A= = http://people.planetpostgresql.org/greg/index.php?/archives/134-gui= d.html=0A= = http://people.planetpostgresql.org/greg/index.php?/archives/134-Ver= ifying-master-slave-replication-with-check_postgres.pl.html=0A= <!--=0A= div.gsmcode {=0A= font-family:Courier,monospace;font-weight:bold; font-size:110%;=0A= border:1px solid #888888;line-height:130%;=0A= padding-left:1em; padding-right: 1em; margin-right :5em; margin-left:1em;=0A= color:black; background:#eeeeee;=0A= }=0A= // -->=0A= =0A= <p>I just wrapped up a new action named = <b>replicate_row</b> that I've been kicking around for a = while. This is part of the <a = href=3D"http://people.planetpostgresql.org/greg/exit.php?url_id=3D69= 6&amp;entry_id=3D134" = title=3D"http://bucardo.org/check_postgres/">check_postgres.= pl</a> script, which monitors many =0A= <a = href=3D"http://people.planetpostgresql.org/greg/exit.php?url_id=3D69= 7&amp;entry_id=3D134" = title=3D"http://www.postgres.org/">Postgres</a> = things for =0A= <a = href=3D"http://people.planetpostgresql.org/greg/exit.php?url_id=3D69= 8&amp;entry_id=3D134" = title=3D"http://nagios.org">Nagios</a> or other = systems. This new action (part of the just-released version 1.7.0 of = check_postgres) runs a simple update on the master and checks how long = it takes to propagate to one or more slaves. It does require making = actual updates on your production system, so use an old row in a = replicated table that can safely have a column toggled from one value to = another.</p>=0A= <p>Rather than explain all the new arguments, I'll just show a = couple examples from the docs:</p>=0A= =0A= <br /><a = href=3D"http://people.planetpostgresql.org/greg/index.php?/archives/= 134-Verifying-master-slave-replication-with-check_postgres.pl.html#extend= ed">Continue reading "Verifying master-slave replication = with check_postgres.pl"</a>=0A= Wed, 28 May 2008 17:29:00 +0000=0A= =0A= =0A= Devrim G=C3=BCnd=C3=BCz: What Planet PostgreSQL is, and what it = is not.=0A= = http://people.planetpostgresql.org/devrim/index.php?/archives/114-g= uid.html=0A= = http://people.planetpostgresql.org/devrim/index.php?/archives/114-W= hat-Planet-PostgreSQL-is,-and-what-it-is-not..html=0A= <br />=0A= It has been almost 4 years since I <a target=3D"_blank" = href=3D"http://archives.postgresql.org/pgsql-www/2004-11/msg00033.ph= p">started</a> Planet PostgreSQL project. It actually = started at August 2004, but for some reasons, it went live sometime = around December.<p>Since then, Planet PostgreSQL is/was more or = less my project. Magnus and Robert helped me a lot in many ways -- these = three people still decide on Planet PostgreSQL management. = </p><p>About 2 years ago, www.postgresql.org began pulling = headlines from Planet, and as of last year, Planet PostgreSQL was placed = in front page. This was one of the great successes of = Planet.</p><p>Planet PostgreSQL is actually an aggregator. = OTOH, it encouraged PostgreSQL people in the community blog more and = more. IIRC, noone among developers were blogging when I first started = Planet PostgreSQL -- but now, we have people even from Core Team! We = have very valuable blog posts.</p><p>Now, why I wrote all of = this:</p><p>Even though I'm working for Command Prompt, CMD = and /or Joshua does <b>not</b> directly control Planet . If = you have problems with Planet and its administrators (mostly me) , = calling/e-mailing Joshua will not help you. Actually, <b>it will = end up with a negative effect on me</b>. Joshua is my boss, friend = -- but does not control my management over Planet (of course, I also = take ideas from him from time to time, and I find them very valuable). = ...and yes, Planet PostgreSQL is running on a server that CMD hosts. But = still, this project is not related to my work at Command = Prompt.</p><p>So, please stop pestering Joshua/Andrew/others = for Planet -- feel free to pester me, Magnus and = Robert.</p><p></p><p></p><p></p>= ;=0A= Wed, 28 May 2008 09:54:21 +0000=0A= =0A= =0A= Neil Conway: 27 May 2008=0A= = http://www.advogato.org/person/nconway/diary.html?start=3D58=0A= = http://www.advogato.org/person/nconway/diary.html?start=3D58=0A= <b>Grad School</b>=0A= =0A= <p> I've decided to go back to school &mdash; I'm excited to=0A= report that I'll be starting=0A= at the PhD program in computer science at UC Berkeley in the=0A= fall, working with <a = href=3D"http://www.cs.berkeley.edu/~franklin/">Mike=0A= Franklin</a> and <a = href=3D"http://db.cs.berkeley.edu/jmh/">Joe = Hellerstein</a> in=0A= the <a href=3D"http://db.cs.berkeley.edu/">Berkeley = Database=0A= Group</a>. I'm not sure yet if this means I'll have more or less=0A= time to work on community Postgres stuff.=0A= =0A= <p> <b>AsterDB and Postgres?</b>=0A= =0A= <p> <a href=3D"http://www.asterdata.com/">Aster = Data Systems</a>=0A= are a database startup that have received a bunch of <a = href=3D"http://anand.typepad.com/datawocky/2008/05/why-the-world-nee= ds-a-new-database-system.html">press</a>=0A= recently. I've now heard from two different people that=0A= Aster are built upon Postgres, but their website is still=0A= pretty content-free, so it's hard to be sure. I wouldn't be=0A= surprised, though: it's hard to make the case for building a=0A= database system from scratch in 2008, especially in a=0A= startup environment.</p></p></p>=0A= Tue, 27 May 2008 22:43:31 +0000=0A= =0A= =0A= Dave Page: pgAdmin used to manage the world's largest SQL = database!=0A= = http://people.planetpostgresql.org/dpage/index.php?/archives/55-gui= d.html=0A= = http://people.planetpostgresql.org/dpage/index.php?/archives/55-pgA= dmin-used-to-manage-the-worlds-largest-SQL-database!.html=0A= <br />=0A= As you may have read in the press, at pgCon 2008 Yahoo described the = architecture of their <a = href=3D"http://news.yahoo.com/s/cmp/20080522/tc_cmp/207801579"&= gt;2 PetaByte Everest database</a>, built on PostgreSQL. What's = <b>really</b> cool for me is that they manage it using <a = href=3D"http://www.pgadmin.org/">pgAdmin</a> (in = addition to some of their own tools) - as evidenced in the top right = hand block in this <a = href=3D"http://www.flickr.com/photos/gavinmroy/2520304654/">= architectural diagram</a>, photographed by Gavin during the Yahoo = lightning talk.<p></p><p>Nice one <img = src=3D"http://people.planetpostgresql.org/dpage/templates/default/im= g/emoticons/smile.png" alt=3D":-)" = class=3D"emoticon" /></p><br /><br = />=0A= Tue, 27 May 2008 16:10:43 +0000=0A= =0A= =0A= Francisco Figueiredo Jr: Life after PGCon2008...=0A= tag:blogger.com,1999:blog-15237920.post-490047047939402688=0A= http://fxjr.blogspot.com/2008/05/life-after-pgcon2008.html=0A= PGCon 2008 was awesome!!! I could meet a lot of people = from postgresql community and take a lot of pictures!! I even got a = picture with Tom Lane! Thank you very much, Selena! :)<br /><br = />I finally could meet Dave Page in person. Dave has helped Npgsql = project in the beginning, 2002 and we never have met before!<br = /><br />I also could meet Magnus Hagander in person. He is a = very nice person. I saw some of his talks and was very good!<br = /><br /><div>I also could meet Hiroshi Saito and Josh = Cooley. Hiroshi Saito is a big evangelist of Npgsql in Japan and has = done a great work to talk to others about Npgsql there. Josh Cooley has = been working on Npgsql adding nice features, like System.Transactions = and entity framework support, and fixing bugs. I enjoyed very much to = meet them and doing the presentation. Our presentation was very nice = considering this was my first time doing a presentation in english. Josh = said my english was good, so I was ok. Thank you Josh!<br /><br = />Another person I enjoyed very much to talk to was Selena. She is = very nice. She makes me remember of Brazilian girls because she is very = active and has very strong energy. She even <a = href=3D"http://www.chesnok.com/daily/2008/05/22/pgcon-in-ottawa-foll= owing-people-on-twitter/">talked about my twitter</a> and = so this explains why suddenly I started to be followed by some other = people!! Selena, it was a great pleasure to meet you.<br /><br = /></div><div>I'd like to thank Dan Langille for his = support which allowed me to be here in Canada to attend this = conference.<br /></div><br /><br = /><div>The unexpected thing which occur in this PGCon2008 was = that Fernando Ike who was doing a presentation just before mine asked me = to make a real time translation of his speech! So, just before I do my = first talk in english I had to make my first real time translation! I = must confess that I was very nervous but in the end everything was = fine!<br /><br />Well, that's it! I will add more = later.<br /><br />See you.....<br = /></div>=0A= Tue, 27 May 2008 02:05:40 +0000=0A= =0A= =0A= Josh Berkus: pgCon 2008 Pictures up=0A= = http://rss.ittoolbox.com/rss/24932@http://blogs.ittoolbox.com/datab= ase/soup=0A= = http://networking.ittoolbox.com/r/rss.asp?url=3Dhttp://blogs.ittool= box.com/database/soup/archives/pgcon-2008-pictures-up-24932=0A= My photos from pgCon are now up.=0A= Mon, 26 May 2008 20:51:39 +0000=0A= =0A= =0A= David Fetter: PostgreSQL Weekly News - May 25 2008=0A= = http://people.planetpostgresql.org/dfetter/index.php?/archives/174-= guid.html=0A= = http://people.planetpostgresql.org/dfetter/index.php?/archives/174-= PostgreSQL-Weekly-News-May-25-2008.html=0A= <strong>PostgreSQL Weekly News - May 25 = 2008</strong>=0A= <br />=0A= =0A= The May commitfest is finished. The remaining patches on the queue=0A= <br />=0A= are Heikki's map-forks patch, which was WIP not intended to be=0A= <br />=0A= committed now; and Merlin and Andrew's libpq hooks patch, which is=0A= <br />=0A= still in flux and not ready to commit now.=0A= <br />=0A= =0A= PgCon 2008 was a smashing success, eh. People hashed things out at=0A= <br />=0A= the developer meeting, complete with a Secret Cabal Meeting.=0A= <br />=0A= Participants came in from as far as Pune, India.=0A= <br /><a = href=3D"http://people.planetpostgresql.org/dfetter/index.php?/archiv= es/174-PostgreSQL-Weekly-News-May-25-2008.html#extended">Continue= reading "PostgreSQL Weekly News - May 25 = 2008"</a>=0A= Mon, 26 May 2008 05:22:13 +0000=0A= =0A= =0A= Peter Eisentraut: Mission Accomplished=0A= = http://people.planetpostgresql.org/peter/index.php?/archives/28-gui= d.html=0A= = http://people.planetpostgresql.org/peter/index.php?/archives/28-Mis= sion-Accomplished.html=0A= To conclude my expedition to PGCon in Ottawa, today I = completed the <a = href=3D"http://www.runottawa.ca/">Ottawa = Marathon</a>. A very well organized race to go along with a very = well organized conference. Until next year.=0A= Mon, 26 May 2008 05:10:04 +0000=0A= =0A= =0A= Liam O'Duibhir: Pentaho Support and Consultancy - FAST and = BizCubed partner=0A= http://postgresql.fastware.com/57 at = http://postgresql.fastware.com=0A= http://postgresql.fastware.com/node/57=0A= <div class=3D"event-nodeapi"><div = class=3D"event-start"><label>Start: = </label>2008-05-26 12:47</div></div>=0A= <div class=3D"event-nodeapi"><div = class=3D"event-tz"><label>Timezone: = </label>Etc/GMT+10</div></div>=0A= <p><font size=3D"2">Pentaho is the leader in the = Open Source Business Intelligence market. PostgreSQL is the best = database technology available in the open source marketplace. Linking = the established Postgres support, high availability, and consulting = services from FAST to the industry leading pentaho services provided by = BizCubed means that clients get the feature rich interactive environment = of a complete BI system with the reliability and dependability of an = enterprise grade database platform all from the open source marketplace. = </font></p>=0A= <p>&quot;The integration of the service offerings of our two = innovating and dynamic organisations means that more Australian = companies will be able to benefit from the high value and low risk = proposition of Pentaho on Postgres&quot; Said Zachary Zeus Principal = at BizCubed.</p>=0A= <div><font size=3D"2">&quot;Making Open Source = software work in business and for business is a key focus of ours at = FAST. In cooperation with BizCubed, we aim to deliver substantial = business benefits to our customers using Postgres and Pentaho.&quot; = Said Liam </font><font size=3D"2">O'Duibhir = Program Manager - Open Source Software at = FAST.</font></div>=0A= Mon, 26 May 2008 02:51:42 +0000=0A= =0A= =0A= Liam O'Duibhir: Training Courses (DBA and Advanced) in Canberra = on the 8th, 9th and 10th of July 2008=0A= http://postgresql.fastware.com/56 at = http://postgresql.fastware.com=0A= http://postgresql.fastware.com/node/56=0A= <div class=3D"event-nodeapi"><div = class=3D"event-start"><label>Start: = </label>2008-07-08 09:00</div></div>=0A= <div class=3D"event-nodeapi"><div = class=3D"event-end"><label>End: = </label>2008-07-10 17:00</div></div>=0A= <div class=3D"event-nodeapi"><div = class=3D"event-tz"><label>Timezone: = </label>Etc/GMT+10</div></div>=0A= <p><strong>DBA course</strong> </p>=0A= <p>As part of the Fujitsu Support PostgreSQL (FSP) Training = Program, a two-day PostgreSQL Database Administration training course = will be held in Canberra on the 8th and 9th of August 2006.</p>=0A= <ul>=0A= <li><a = href=3D"http://www.fastware.com.au/docs/FujitsuPostgreSQLDatabaseAdm= inistrationCourseOutline.pdf"><u><font = color=3D"#0000ff">PostgreSQL Database Administration = Training Course = Outline</font></u></a>=C2=A0(56kb)</li>=0A= </ul>=0A= <p><strong>Advanced training course</strong></p>=0A= <p>Following the two day course, there will be an advanced = training day for attendees of the first DBA course and experienced users = of PostgreSQL and other commercial databases. This course will cover = issues critical to PostgreSQL administration in a mission critical = environment, extensive analysis of system performance topics, disaster = prevention and recovery mechanisms and will preview the next version of = PostgreSQL.</p>=0A= <ul>=0A= <li><a = href=3D"http://www.fastware.com.au/docs/PostgreSQL_advanced_day_aug.= pdf"><u><font color=3D"#0000ff">PostgreSQL = Developer Workshop Course = Outline</font></u></a>=C2=A0(32kb)</li>=0A= </ul>=0A= <p>If you wish to participate in either event, please contact us = to make a booking:</p>=0A= <p>Email: <a = href=3D"mailto:info@fspostgresql.com"><u><font = color=3D"#0000ff">info@fspostgresql.com</font></u&g= t;</a><br />Phone: +61 2 9452 9068 </p>=0A= Mon, 26 May 2008 02:42:19 +0000=0A= =0A= =0A= Jignesh K. Shah: Problems with PostgreSQL on Multi-core Systems = with Multi-Terabyte Data=0A= = http://people.planetpostgresql.org/jkshah/index.php?/archives/3-gui= d.html=0A= = http://people.planetpostgresql.org/jkshah/index.php?/archives/3-Pro= blems-with-PostgreSQL-on-Multi-core-Systems-with-Multi-Terabyte-Data.html= =0A= <p>Title:=C2=A0 Problems with PostgreSQL on = Multi-core Systems with Multi-Terabyte Data</p><p><a = href=3D"http://blogs.sun.com/jkshah/resource/pgcon_problems.pdf"= ;><img hspace=3D"0" = src=3D"http://blogs.sun.com/jkshah/resource/pgcon_problems.jpg"= align=3D"bottom" border=3D"0" = /></a>=C2=A0</p>=0A= Mon, 26 May 2008 02:27:20 +0000=0A= =0A= =0A= Josh Berkus: pcCon Day 2 Highlights=0A= = http://rss.ittoolbox.com/rss/24899@http://blogs.ittoolbox.com/datab= ase/soup=0A= = http://networking.ittoolbox.com/r/rss.asp?url=3Dhttp://blogs.ittool= box.com/database/soup/archives/pccon-day-2-highlights-24899=0A= So, that's pgCon. It was exciting and fun. All of you PG = geeks who missed it should be kicking yourselves about now, and putting = in budget requests for next year.=0A= Sun, 25 May 2008 15:17:42 +0000=0A= =0A= =0A= Gavin M. Roy: Unofficial pgCon 2008 Group Photo=0A= tag:www.gavinroy.com,2008-05-25:476=0A= = http://www.gavinroy.com/2008/5/25/unofficial-pgcon-2008-group-photo= =0A= <p><a = href=3D"http://gordo.ehpg.net/~gmr/pgCon2008-01.jpg"><img= src=3D"http://gordo.ehpg.net/~gmr/pgCon2008-01sm.jpg" = alt=3D"Click for big sized" /></a><br />=0A= Click for Larger Version</p>=0A= <p><a = href=3D"http://www.flickr.com/photos/gavinmroy/sets/7215760523474498= 2/detail/">Here are some misc pictures I took @ = pgCon.</a></p>=0A= Sun, 25 May 2008 04:11:49 +0000=0A= =0A= =0A= Greg Sabino Mullane: DBD::Pg now supports NOTIFY payloads=0A= = http://people.planetpostgresql.org/greg/index.php?/archives/133-gui= d.html=0A= = http://people.planetpostgresql.org/greg/index.php?/archives/133-DBD= Pg-now-supports-NOTIFY-payloads.html=0A= <!--=0A= div.gsmcode {=0A= font-family:Courier,monospace;font-weight:bold; font-size:110%;=0A= border:1px solid #888888;line-height:130%;=0A= padding-left:1em; padding-right: 1em; margin-right :5em; margin-left:1em;=0A= color:black; background:#eeeeee;=0A= }=0A= div.gsmout {=0A= font-family:Courier,monospace;font-weight:bold; font-size:110%;=0A= border:1px solid #888888;line-height:130%;=0A= padding-left:1em; padding-right: 1em; margin-right:5em; margin-left:1em;=0A= color:black; background:#ddeeee;=0A= }=0A= // -->=0A= =0A= =0A= <p>At <a = href=3D"http://people.planetpostgresql.org/greg/exit.php?url_id=3D68= 7&amp;entry_id=3D133" = title=3D"http://www.pgcon.org">PGcon 2008</a> last = week, =0A= <a = href=3D"http://people.planetpostgresql.org/greg/exit.php?url_id=3D68= 8&amp;entry_id=3D133" = title=3D"http://people.planetpostgresql.org/andrew/">Andrew = Dunstan</a> (during =0A= <a = href=3D"http://people.planetpostgresql.org/greg/exit.php?url=3DaHR0c= DovL3d3dy5wZ2Nvbi5vcmcvMjAwOC9zY2hlZHVsZS9ldmVudHMvMTA3LmVuLmh0bWw=3D&= ;amp;entry_id=3D133" = title=3D"http://www.pgcon.org/2008/schedule/events/107.en.html"= >=0A= his talk</a>=0A= about the new LISTEN/NOTIFY system) asked if =0A= <a = href=3D"http://people.planetpostgresql.org/greg/exit.php?url=3DaHR0c= DovL3NlYXJjaC5jcGFuLm9yZy9kaXN0L0RCRC1QZy8=3D&amp;entry_id=3D133"= ; title=3D"http://search.cpan.org/dist/DBD-Pg/">=0A= DBD::Pg</a> supports message payloads via pg_notifies(). It does = now. <img = src=3D"http://people.planetpostgresql.org/greg/templates/default/img= /emoticons/smile.png" alt=3D":-)" = class=3D"emoticon" /> Although you cannot currently add = extra information when you issue a =0A= <a = href=3D"http://people.planetpostgresql.org/greg/exit.php?url=3DaHR0c= DovL3d3dy5wb3N0Z3Jlc3FsLm9yZy9kb2NzL2N1cnJlbnQvaW50ZXJhY3RpdmUvc3FsLW5vdG= lmeS5odG1s&amp;entry_id=3D133" = title=3D"http://www.postgresql.org/docs/current/interactive/sql-noti= fy.html">=0A= NOTIFY command</a> in Postgres, support for it was already in the = protocol, and inside of libpq, so getting DBD::Pg ready for version 8.4 = of Postgres was fairly easy. Andrew's change will not only allows = payload strings to be attached to notification events, but does away = with the pg_listener table entirely, and puts everything into shared = memory. This is great news for applications like =0A= <a = href=3D"http://people.planetpostgresql.org/greg/exit.php?url_id=3D68= 9&amp;entry_id=3D133" = title=3D"http://bucardo.org/">Bucardo</a> and =0A= <a = href=3D"http://people.planetpostgresql.org/greg/exit.php?url_id=3D69= 0&amp;entry_id=3D133" = title=3D"http://slony.info">Slony</a> =0A= which are heavy users of LISTEN/NOTIFY. This should help increase = performance, simplify coding, and eliminate the need to vacuum the = pg_listener table.</p>=0A= =0A= =0A= <br /><a = href=3D"http://people.planetpostgresql.org/greg/index.php?/archives/= 133-DBDPg-now-supports-NOTIFY-payloads.html#extended">Continue = reading "DBD::Pg now supports NOTIFY = payloads"</a>=0A= Sun, 25 May 2008 04:07:00 +0000=0A= =0A= =0A= Peter Eisentraut: PGCon Day Four=0A= = http://people.planetpostgresql.org/peter/index.php?/archives/27-gui= d.html=0A= = http://people.planetpostgresql.org/peter/index.php?/archives/27-PGC= on-Day-Four.html=0A= PGCon 2008 is over, and I couldn't help feeling somewhat = sad.<br />=0A= <br />=0A= The second day of talks also featured many good presentations. My own = also went quite well. We concluded the day with a meeting of the core = team members who were present in Ottawa, and there will probably be a = few actions coming out of that. Don't expect anything too dramatic, = though.<br />=0A= <br />=0A= Thanks to everyone for this great conference, and I'll see all of you = next year if not sooner.=0A= Sat, 24 May 2008 21:56:53 +0000=0A= =0A= =0A= Bruce Momjian: Coverity Security Scan=0A= http://momjian.us/main/blogs/pgblog.html#May_24_2008=0A= http://momjian.us/main/blogs/pgblog.html#May_24_2008=0A= <p>During <a = href=3D"http://www.pgcon.org/2008/">PGCon</a>, I = attended a <a = href=3D"http://www.coverity.com/">Covertity</a> talk = about the=0A= security scanning software they use to scan the Postgres source code and = other open source projects; seems they are=0A= scanning the Postgres CVS HEAD every day. I am going to work with the = tool to see if I can reduce the number of false=0A= warnings so we can check the tool as part of our release process.=0A= </p>=0A= Sat, 24 May 2008 16:00:00 +0000=0A= =0A= =0A= Peter Eisentraut: PGCon Day Three=0A= = http://people.planetpostgresql.org/peter/index.php?/archives/26-gui= d.html=0A= = http://people.planetpostgresql.org/peter/index.php?/archives/26-PGC= on-Day-Three.html=0A= I welcome back my faithful readership to their regularly = scheduled program. Thursday was the first day of talks at PGCon, as = evidenced by the rise of blog posts on planetpostgresql under a = "day 1" label. Welcome newbies! <img = src=3D"http://people.planetpostgresql.org/peter/templates/default/im= g/emoticons/smile.png" alt=3D":-)" = class=3D"emoticon" /><br />=0A= <br />=0A= The talks were really good. I won't go into the details here; the slides = should be available on the conference web site. For those not here I = will summarize the sentiments of the day as <em>Everyone is = hiring</em>. If to you, "vacuum" means cleaning the = disk rather than cleaning the house, there appear to be literally dozens = of jobs just waiting to be grabbed.<br />=0A= <br />=0A= In the evening we had the EnterpriseDB dinner. I think I caught a cold = in the draft. Must save my voice for my presentation.=0A= Fri, 23 May 2008 20:28:42 +0000=0A= =0A= =0A= Magnus Hagander: pgCon day 3=0A= = http://people.planetpostgresql.org/mha/index.php?/archives/173-guid= .html=0A= = http://people.planetpostgresql.org/mha/index.php?/archives/173-pgCo= n-day-3.html=0A= <img = src=3D"http://mha.smugmug.com/photos/300152351_xndxn-S.jpg" = align=3D"right" vspace=3D"10" = hspace=3D"10" />I'm not going to go into any talk = specifics, but just say that day 3 was the first day of regular talks, = and it had a lot of very good talks. After that, we had the EnterpriseDB = dinner party, which was also very good. They clearly won the = dinner-party race over Yahoo! - no contest!<br />=0A= <br />=0A= I've uploaded pictures from this day as well as the dinner party. = They're all in the <a = href=3D"http://people.planetpostgresql.org/mha/exit.php?url_id=3D296= &amp;entry_id=3D173" = title=3D"http://mha.smugmug.com/gallery/4996271_oHxtB">galle= ry</a>. Most of the pictures are tagged with names - but I'd love = to have some help going through the ones that aren't and fill in the = proper names, since I don't know everybody. Feel free to help out by = just sending me an email with names that are in pictures which aren't = categorized.<br />=0A= <br />=0A= The picture attached to this post is one I received from Bruce's boss = based on one of my photos. No further comments needed I think.<br = />=0A= <br />=0A= Right now in Peters talk about our project management and release = processes. I actually agree with most of them, which is a good sign - we = think at least almost the same on how things are.<br = />=0A= Fri, 23 May 2008 18:03:13 +0000=0A= =0A= =0A= Bruce Momjian: PGCon Impressions=0A= http://momjian.us/main/blogs/pgblog.html#May_23_2008_3=0A= http://momjian.us/main/blogs/pgblog.html#May_23_2008_3=0A= <p><a = href=3D"http://www.pgcon.org/2008/">PGCon</a> was = great this year. There were a lot of new serious users, and lots of = people=0A= I knew but haven't seen in months. I wish I had more time to talk to = everyone longer.=0A= </p>=0A= <p><a = href=3D"http://momjian.us/main/blogs/pgblog.html#May_23_2008_3"= >(Read more)</a></p>=0A= Fri, 23 May 2008 16:00:00 +0000=0A= =0A= =0A= Bruce Momjian: The Photo Reply=0A= http://momjian.us/main/blogs/pgblog.html#May_23_2008_2=0A= http://momjian.us/main/blogs/pgblog.html#May_23_2008_2=0A= <p><a = href=3D"http://www.linkedin.com/in/derekrodner">Derek = Rodner</a> and <a = href=3D"http://www.hagander.net/">Magnus Hagander</a> = created a=0A= <a = href=3D"http://mha.smugmug.com/gallery/4996271_oHxtB#300152351_xndxn= -A-LB">poster</a> in response to my=0A= <a = href=3D"http://momjian.us/main/blogs/pgblog.html#May_23_2008"&g= t;previous</a> blog entry.=0A= </p>=0A= Fri, 23 May 2008 16:00:00 +0000=0A= =0A= =0A= Selena Deckelmann: PgCon in Ottawa - following people on = twitter=0A= = http://www.chesnok.com/daily/2008/05/22/pgcon-in-ottawa-following-p= eople-on-twitter/=0A= = http://www.chesnok.com/daily/2008/05/22/pgcon-in-ottawa-following-p= eople-on-twitter/=0A= <p>I&#8217;m in Ottawa at PgCon and listening to = Bruce Momjian give the keynote.</p>=0A= <p>We have a few people who&#8217;ve joined Twitter in the = last couple months and are posting their thoughts through the = conference. Try following @<a = href=3D"http://www.twitter.com/crad">crad</a>, @<a = href=3D"http://www.twitter.com/fuzzychef">fuzzychef</a>= ;, @<a = href=3D"http://www.twitter.com/franciscojunior">franciscojun= ior</a> and @<a = href=3D"http://www.twitter.com/selenamarie">selenamarie</= a> (me) for our up-to-the-minute updates!</p>=0A= <p>I&#8217;ll be giving a lightning talk this afternoon around = 5:30pm about user groups and PostgreSQL.</p>=0A= Fri, 23 May 2008 14:29:11 +0000=0A= =0A= =0A= Josh Berkus: pgCon Day 1 Highlights=0A= = http://rss.ittoolbox.com/rss/24869@http://blogs.ittoolbox.com/datab= ase/soup=0A= = http://networking.ittoolbox.com/r/rss.asp?url=3Dhttp://blogs.ittool= box.com/database/soup/archives/pgcon-day-1-highlights-24869=0A= So we're on day two of pgCon now. Here's a round-up of = what I attended on day one.=0A= Fri, 23 May 2008 10:20:22 +0000=0A= =0A= =0A= Selena Deckelmann: PgCon Lightning talk: User Groupalooza=0A= = http://www.chesnok.com/daily/2008/05/22/pgcon-lightning-talk-user-g= roupalooza/=0A= = http://www.chesnok.com/daily/2008/05/22/pgcon-lightning-talk-user-g= roupalooza/=0A= <p>I gave a Lightning talk today about PostgreSQL = User Groups. I wasn&#8217;t able to get through ALL my slides - but = I only had to rush through the last three. (click on the cat below to = download - 5MB)</p>=0A= <p><center><a = href=3D"http://www.chesnok.com/daily/wp-content/uploads/2008/05/user= -groups.pdf" title=3D"User Groupalooza"><img = src=3D"http://www.chesnok.com/daily/wp-content/uploads/2008/05/user-= groups.jpg" alt=3D"splash for user group talk" = width=3D"250px" /></a></center></p>=0A= <p>Lightning talks are some of my favorite sessions. I got to = announce the<a = href=3D"http://people.planetpostgresql.org/mha/index.php?/archives/1= 72-Welcome-PostgreSQL-Europe.html"> incorporation of = PostgreSQL-EU</a>! We had a talk about DBIx::Cache (which you = should all check out!), a cool open source lab in Japan that Hiroshi = Saito works for (only for Japanese, but very cool), Gavin Roy talked = about Staplr and a new benchmarking tool called <a = href=3D"https://area51.myyearbook.com/trac.cgi/wiki/Playr">P= layr</a> that was just released on Thursday, and six more talks! = We hope to publish the rest of the slides = shortly.</p>=0A= Fri, 23 May 2008 07:25:20 +0000=0A= =0A= =0A= Greg Smith: pgbench suffering with Linux 2.6.23-2.6.26=0A= = tag:blogger.com,1999:blog-5872875865565724903.post-3589456253054610= 553=0A= = http://notemagnet.blogspot.com/2008/05/pgbench-suffering-with-linux= -2623-2626.html=0A= About a month ago I got Linux installed on some new = quad-core hardware at home, with the intention being that box would = primarily be used for my PostgreSQL work which includes a lot of = benchmarking. The hardware on the system is new enough that I needed a = very recent Linux kernel version for it to work well. It was possible = to install my standard distributions, CentOS 5 and Ubuntu 7.04, if = I=0A= Fri, 23 May 2008 02:59:46 +0000=0A= =0A= =0A= Magnus Hagander: Welcome PostgreSQL Europe=0A= = http://people.planetpostgresql.org/mha/index.php?/archives/172-guid= .html=0A= = http://people.planetpostgresql.org/mha/index.php?/archives/172-Welc= ome-PostgreSQL-Europe.html=0A= So, it's now official. Graciously folded into Selenas = lightning talk, we have now announced that the legal forming of = PostgreSQL Europe has finally come through. All the government = bureaucracy is now finally done, and we are a registered european = non-profit. <br />=0A= <br />=0A= What this means in reality is that we now have a lot of actual work to = do, and can no longer hide behind this fact. Until then, let's get = working on <a = href=3D"http://people.planetpostgresql.org/mha/exit.php?url_id=3D295= &amp;entry_id=3D172" = title=3D"http://wiki.postgresql.eu">the wiki</a> or = just fill our mailinglist with good ideas!=0A= Thu, 22 May 2008 21:56:06 +0000=0A= =0A= =0A= Peter Eisentraut: PGCon Day Two=0A= = http://people.planetpostgresql.org/peter/index.php?/archives/25-gui= d.html=0A= = http://people.planetpostgresql.org/peter/index.php?/archives/25-PGC= on-Day-Two.html=0A= Wednesday morning, I went geocaching again, attempting to = complete the <a = href=3D"http://www.geocaching.com/seek/cache_details.aspx?guid=3D88b= e8823-4870-494a-8a8a-6db8523c716b">second UO cache</a>, = but ended up at a pile of rubble again. Hmm. Maybe this game works = differently here in Canada. I hope I get to drop my travel bug before I = leave though.<br />=0A= <br />=0A= The main event of the day, at least for the major developers, was the = <a = href=3D"http://wiki.postgresql.org/wiki/PgCon_2008_Developer_Meeting= ">developer meeting</a>, which I incidentally managed to = locate with my GPS device. I was skeptical about this meeting = beforehand, but I have to say, it was extremely useful and enjoyable. = The wiki page linked to above contains the meeting minutes. So I guess = I'm on the hook now to kill off some PostgreSQL mailing lists, and = perhaps we'll have a prototype cmake-based build system for PostgreSQL = sometime.<br />=0A= <br />=0A= In the evening, everyone met at the <a = href=3D"http://www.pgcon.org/2008/schedule/events/116.en.html"&= gt;Yahoo! drinks+food</a> event. Since I arrived an hour late = because I was training for the run on Sunday, I didn't get to see any = Yahoo things except a few Yahoo-branded napkins. But hey, I got a free = beer and I was able to see the rerun of the Champions League final. = Someone came up to me later to thank me for my previous blog entry = reminding him to watch the game as well. So FYI: As far as I know, there = is nothing important on TV today. <img = src=3D"http://people.planetpostgresql.org/peter/templates/default/im= g/emoticons/smile.png" alt=3D":-)" = class=3D"emoticon" />=0A= Thu, 22 May 2008 20:23:48 +0000=0A= =0A= =0A= Robert Treat: DB Anti-Patterns slides on slideshare=0A= = http://people.planetpostgresql.org/xzilla/index.php?/archives/342-g= uid.html=0A= = http://people.planetpostgresql.org/xzilla/index.php?/archives/342-D= B-Anti-Patterns-slides-on-slideshare.html=0A= Just a quick note from <a = href=3D"http://people.planetpostgresql.org/xzilla/exit.php?url_id=3D= 2932&amp;entry_id=3D342" = title=3D"http://pgcon.org/2008/">pgcon</a>, I've = uploaded my slides to <a = href=3D"http://people.planetpostgresql.org/xzilla/exit.php?url_id=3D= 2933&amp;entry_id=3D342" = title=3D"http://www.slideshare.net/xzilla/database-anti-patterns&quo= t;>slideshare</a> for those that want to take a look. I'll see = about getting them to Dan for the pgcon site, but they are available to = view now for those who can't wait <img = src=3D"http://people.planetpostgresql.org/xzilla/templates/default/i= mg/emoticons/smile.png" alt=3D":-)" = class=3D"emoticon" />=0A= Thu, 22 May 2008 16:43:29 +0000=0A= =0A= =0A= Magnus Hagander: PGcon first photos!=0A= = http://people.planetpostgresql.org/mha/index.php?/archives/171-guid= .html=0A= = http://people.planetpostgresql.org/mha/index.php?/archives/171-PGco= n-first-photos!.html=0A= <img = src=3D"http://mha.smugmug.com/photos/299596988_nsQhD-S.jpg" = align=3D"right" /><br />=0A= <br />=0A= As usual, I forgot my USB cable. As is becoming usual, <a = href=3D"http://people.planetpostgresql.org/mha/exit.php?url_id=3D293= &amp;entry_id=3D171" = title=3D"http://www.chesnok.com/daily/2008/05/22/at-pgcon-in-ottawa/= ">Selena</a> came to my rescue and lent me hers so I got = the pictures up. The first set is up on my <a = href=3D"http://people.planetpostgresql.org/mha/exit.php?url_id=3D294= &amp;entry_id=3D171" = title=3D"http://mha.smugmug.com/gallery/4996271_oHxtB">galle= ry</a> with some tagging and stuff.<br />=0A= <br />=0A= More photos to come as the conference proceeds. But for now, I obviously = have to post the one of Steven falling asleep at the table long before = midnight... Kinda ruins his attempt to build a reputation, I think... = But it's hard work being at a PostgreSQL conference - imagine how it was = for those of us working at the developer meeting, Steven!=0A= Thu, 22 May 2008 16:06:48 +0000=0A= =0A= =0A= Selena Deckelmann: At PgCon in Ottawa, Day 1=0A= http://www.chesnok.com/daily/2008/05/22/at-pgcon-in-ottawa/=0A= http://www.chesnok.com/daily/2008/05/22/at-pgcon-in-ottawa/=0A= <p>Oops, this got published early. I&#8217;ll = be updating this shortly.. probably over lunch.</p>=0A= <p>Magnus posted <a = href=3D"http://mha.smugmug.com/gallery/4996271_oHxtB#299590893_zbP9d= ">some photos</a> already!</p>=0A= <p>Summary of last night: </p>=0A= <p>We had a great time last night at the pub for registration, and = then over to the Yahoo! party. We had fun talking databases, beer, and = the difficulty in trying to understand Australian accents. I learned = from Tom (not Tom Lane) that Adelaide, Australia has a fantastic = wine-growing region. Alvarro once again recommended that Jeff commit his = time interval data type. I think Jeff was convinced to do this for 8.4. = Now I have to update the documentation!</p>=0A= Thu, 22 May 2008 16:00:23 +0000=0A= =0A= =0A= Bruce Momjian: Commit Fest Done=0A= http://momjian.us/main/blogs/pgblog.html#May_22_2008=0A= http://momjian.us/main/blogs/pgblog.html#May_22_2008=0A= <p>The second commit fest for 8.4 is <a = href=3D"http://archives.postgresql.org/pgsql-hackers/2008-05/msg0068= 3.php">done</a>. It=0A= went much smoother than the first commit fest, partly because it was = smaller and better organized. Hopefully=0A= commit fests will allow us to be much more orderly about applying = patches in the future; this is now necessary because=0A= the volume of patches has risen dramatically during the past few years.=0A= </p>=0A= Thu, 22 May 2008 16:00:00 +0000=0A= =0A= =0A= Hubert Lubaczewski: Counting number of distinct elements=0A= http://www.depesz.com/?p=3D1210=0A= = http://www.depesz.com/index.php/2008/05/22/counting-number-of-disti= nct-elements/=0A= When I was working for one of customers we found some = strange thing. We needed to found number of distinct sessions per day. = Table layout was very simple:=0A= =0A= Table "public.some_test_table"=0A= Column &#124; Type [...]=0A= Thu, 22 May 2008 15:41:43 +0000=0A= =0A= =0A= Josh Berkus: 2 Petabyte PostgreSQL=0A= = http://rss.ittoolbox.com/rss/24848@http://blogs.ittoolbox.com/datab= ase/soup=0A= = http://networking.ittoolbox.com/r/rss.asp?url=3Dhttp://blogs.ittool= box.com/database/soup/archives/2-petabyte-postgresql-24848=0A= A rather unexpected company helped us get pgCon started = off with a bang: Yahoo! Last night, they threw a night-before party for = the conference, gave away a Wii, and <a = href=3D"http://news.yahoo.com/s/cmp/20080522/tc_cmp/207801579"&= gt;announced a 2-petabyte database</a> built with a modified = version of PostgreSQL.=0A= Thu, 22 May 2008 15:05:33 +0000=0A= =0A= =0A= Gavin M. Roy: Playr, PgSQL Scripts Released=0A= tag:www.gavinroy.com,2008-05-22:473=0A= = http://www.gavinroy.com/2008/5/22/playr-pgsql-scripts-released=0A= <p>I've just created the 0.1 release tarballs for = both <a = href=3D"https://area51.myyearbook.com/trac.cgi/wiki/Playr">P= layr</a> and our <a = href=3D"https://area51.myyearbook.com/trac.cgi/wiki/PostgreSQLScript= s">PgSQL Script bundle</a>.</p>=0A= <p>Playr is our log replay, PostgreSQL stress testing application = and attempts to answer the question <i>"How much headroom = will our new server give us?"</i> Our PgSQL Script bundle is = just a hodgepodge collection of scripts which currently has two scripts = we've developed for in-house use; concurrentReindex and parallelVacuum. = Both "projects" are fairly new, use at your own = risk.</p>=0A= Thu, 22 May 2008 13:45:00 +0000=0A= =0A= =0A= =0A= =0A= ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: application/rss+xml Content-Transfer-Encoding: quoted-printable Content-ID: <000301c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline =0A= =0A= PostgreSQL Events=0A= http://www.postgresql.org/=0A= PostgreSQL Events=0A= webmaster@postgresql.org (PostgreSQL = webmasters)=0A= Fri, 13 Jun 2008 20:58:07 GMT=0A= =0A= PDXPUG Day (OSCON)=0A= http://www.postgresql.org/about/event.653=0A= http://www.postgresql.org/about/event.653=0A= The O'Reilly Open Source Conference 2008 = registration just opened, and some of you will be making your travel = arrangements to visit Portland. But, wait! Before you buy your plane = tickets, you'd better know about the PostgreSQL Day hosted by = PDXPUG!=0A= selena@postgresql.org=0A= Wed, 02 Apr 2008 00:00:00 GMT=0A= =0A= =0A= LinuxWorldExpo PostgreSQL Day and More!=0A= http://www.postgresql.org/about/event.669=0A= http://www.postgresql.org/about/event.669=0A= Postgresql.org and SFPUG will have a full day = of sessions at LinuxWorldExpo, a booth, and more.=0A= josh@postgresql.org=0A= Mon, 12 May 2008 00:00:00 GMT=0A= =0A= =0A= PGCon Brazil 2008=0A= http://www.postgresql.org/about/event.668=0A= http://www.postgresql.org/about/event.668=0A= PGCon Brazil 2008 is the second release of = PostgreSQL Conference in Brazil.=0A= pgcon@postgresql.org.br=0A= Mon, 12 May 2008 00:00:00 GMT=0A= =0A= =0A= ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: image/x-icon Content-Transfer-Encoding: base64 Content-ID: <000101c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline AAABAAIAEBAAAAAAAABoBQAAJgAAABAQAAAAAAAAaAQAAI4FAAAoAAAAEAAAACAAAAABAAgAAAAA AAABAAAAAAAAAAAAAAABAAAAAQAAAAAAAH9pRQCIYS4AjmIvAItnLwCOZi8Ai2guAJFlLwCDYTIA hWE1AINkNACGZzYAiGIyAI1iMgCKZDIAjmQxAIliNQCMYzUAjmQ2AIFhOACEYjkAhWQ5AIpjOQCK ZTkAh2k/AIloOACPaDoAiWg9AJBiMgCRZTEAlGUwAJFjNACQaD8AiWVBAIltRgCKa0gAinBLAI1x SACZckoAiHZXAJh2VgCWfFkAmH1YAJ59XQCcgF0Ao4FeAJKFYACcg2EAooRhAKaIYQChjmsAoI5u AKqWbgChkHUApZR3AKuXdQCtlnUAsp19ALShfACjlYQArqGKAK2liwCso48AuqmGAL2phQC2pIsA uKaNALSqjwC9qYwAtKWTALerkQC4qpEAu6yRAL6vlQC9rZoAv7CSALiwlQC8spUAwKyMAMGvkADE sZEAxLWTAMC0lQDFt5QAyLSXAMK1mADEuJsAxbegAMe/pwDHuqgAx76pAMi/rwDJwLQAycW2AMvF ugDPybwA08m7ANTMuwDKxsEA08/CANXPwADc1MMA2dHHAN/c1ADh2c4A4d7XAOXf1QDm4dcA4+HZ AO7r5gDu7uwA8e3nAPHu6QDz8OoA9PLuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAYyMpawAAAAAAAAAAAAAAADYRHy8AAAAAAAAAAAAA AAAwEQMmAAAAAAAAAAAAAAAALR8DIAAAAAAAAABlAGo9XSsfBhZvAAAAAABBEV8AbD0oHwMRWjti AABnFREiX0FNEREfEUNuAAAAQh8RRCIKURERHyBaXgAAACwfEVEKETkWHx80J0ZqAHIRER9OFhE4 IR8VUSQ6MgBjER8RUQE4TRERFk0uQBEAShEfH05RVjkRHxFEWlYRZUYfERE4KwMRFhEfETYwH1Zq FR8RAVEKERERESRGERVfAEYWCgpFQxUKFTJRChVKAAAAcnIAAABybQAAXVtyAAD/DwAA/w8AAP8P AAD/DwAA6AcAAMQBAACAAwAAgAMAAIABAAAAAQAAAAEAAAAAAAAAAAAAAAAAAIABAADOYwAAKAAA ABAAAAAgAAAAAQAgAAAAAABABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAA0Mm44oprSP+WfFn/29PFrQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAA/v7+BqOSdPiOYzL/kGYx/5yDYf/29fRCAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAPj49i+ihGH/jWUw/4tnL/+Zckr/8/LtWAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAA9vb1Mu/u7Gfn5+Ruo4Fe/5NmL/+LZy//kGg///Tv6n4AAAAA AAAAAAAAAAAAAAAAAAAAAPPu6lvKvrCz7+7tTtrWzsyqoYz4yMS0+J59Xf+UZjH/i2gu/4pjOf/q 5dyq/PfwUf39+yIAAAAAAAAAAPX08kiynoTviGIy/8W4pcDy8e4/39zT2a2li/+Ydlb/j2Yz/45n L/+IYjP/x7qo/5+QfvK7trDG7uzpS////wzY1MrMhmQ5/5BmMP+Kbkf/0ci27Kmbg++4sJX/kGM1 /45kNv+TZDL/j2Uy/7Wqj//j4+CXAAAAAAAAAADw7+9YuKaN/5BlMP+OZTH/vamM/4ltRv+GYjf/ wrWY/45iL/+LZDP/lWUw/49oOv/Hvqn/ysS5+Pj29DIAAAAA9fPvYZyAXf+RZS//j2Uw/8Swk/+E Yjb/i2M0/7Gdfv+LZDr/k2Qx/5FjNP+qlm7/iHZX/7iqkf/Zz8GqAAAAAOvm3ZqJYzb/kWUv/49l MP/ArIz/imY5/45jMv+slXf/iWVB/5BlMf+CYzn/xLWT/41xSP+0oXz/nYpp9f7+/RzKxLXPjGIz /5JlMv+OZS//xLKQ/39pRf+rl3X/vbOU/4xjNP+TYzT/iWg9/7yyl/+ShWD/vamF/4hiNf/s6eB+ va2a/5BmMf+SZTL/j2Yw/8GvkP+/sJL/xLib/7Oeff+OZDD/j2Qy/4tkMv+6qYb/x7+n/8i0l/+Q YjH/0cWvvb6vlf+TZDL/jGUz/4plMv+ul3T/mH1Y/4hhLv+NYzb/j2Uz/4tlM/+UZDH/jWQx/6GQ df+miGH/jWQz/76ulOLZ0MLJgGA4/5BjM/+QYzP/h2k//8C0lf+FYDX/jWQz/4xkM/+QZTL/j2Uz /4pwS/+7rJH/hmI1/4lhNf/Fva3P9PLxWLWpjviJaDj/g2Iz/4RiOf+zpJL7rqSH7IZnNv+DYTH/ hWQ4/6GOa//Ft5T/g2Q0/4VmOv+4ppHp+/v4MgAAAAD6+voW7urhkObh2Y3u6+Vx+/n2Nfj39hzr 5tyU4tzSjfHv5HT08ellwLan2cO5qOnq5t6B/v7+EwAAAAD/DwAA/gcAAP4HAAD4BwAAwAEAAIAA AAAAAwAAAAEAAAABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAACAAQAA ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: text/css; charset="ks_c_5601-1987" Content-Transfer-Encoding: quoted-printable Content-ID: <000601c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline /* PostgreSQL Global Style - Large Text Version */=0A= =0A= @import url("fixed.css");=0A= =0A= body {=0A= font-size: 93%;=0A= }=0A= =0A= /*Win IE fix \*/=0A= * html #pgTopNavList { height: 1%; margin-bottom: -4px; }=0A= * html #pgTopNavList li { margin: 0 0.2em 0 -0.8em; }=0A= =0A= /*End Win IE fix*/=0A= ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: image/png Content-Transfer-Encoding: base64 Content-ID: <000b01c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline iVBORw0KGgoAAAANSUhEUgAAAAYAAAAFCAYAAABmWJ3mAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz AAALEgAACxIB0t1+/AAAABZ0RVh0Q3JlYXRpb24gVGltZQAxMC8zMC8wNJK6WTcAAAAldEVYdFNv ZnR3YXJlAE1hY3JvbWVkaWEgRmlyZXdvcmtzIE1YIDIwMDSHdqzPAAAAHklEQVR4nGNgaN3wHwZQ 2BgCUDYDVtWtG/DowGUHALlJZbkRURVbAAAAAElFTkSuQmCC ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: image/png Content-Transfer-Encoding: base64 Content-ID: <000c01c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline iVBORw0KGgoAAAANSUhEUgAAAGgAAAAKCAIAAADXQoynAAAABGdBTUEAANbY1E9YMgAAABl0RVh0 U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAANYSURBVHja7JbPS1RRFMffmxwbnaCZQEg3 jZqQQZOiQbaJQBe6iQKDFi2ahULLNoZ/QOSmpZCLaREY6CLc1EIh2uiiBnMWGVRmi1QIdITUySGn z5sjhzv3OWPj2sPM5f449/z4nh/3ufl83jmmyqmKf85xqpPpP4m4s+cEA3uuEziQtXl0Zimzpcvp u9cG3yyYO0NdLU9uXJR5z8vZme+/oqHgh8T1pkhYlqY09juT7zj69qCbZWotI8uJ251MlI0dZPa3 Nlja0cWmcsLWFK3tv9Aw0B4ztahYSwtL5o/efkqtZqKh6o760xO3rsiped3vY3djHfZ0nI14wIEa 48lkOgt2JVCD5D43gYNJtCZo7TRFapVTYNrI5iYXV3ASTfAwV365ojbpUiYQuCxtbOPMnVfv1xv7 /LosTjTyS61tPuu9rDaX0oJhPeOzjAgUO/VUBO7zF/uYWt1ExeDOAlH3gNtKxMMF7ELJ9N/7cdct l6KYRcTK74zN/xD1IMVcM9FdnFJ+M4wHEinAeObpa7zayO76dakE4RybXyY7GIe6zlv2+An/EQsW fuNVoN9HblE6grIHXMDJ/U7ETxWwO/E8nffyriRhnERGq1J3JLOYSGbBwESyTwJbEZFo5BFWIlZ9 M3VpgghRpJQe/Nw6FDjJIJjpAMyHrraYFqLaQlD0knGM4rgAF6wpoAZly6LmtYnVjECO6dbOQFtM gglYXtOJhLGG5djH5SMAJ0nBRILh12UBVxFJ8x2Z+zq5+FNqXJqgkATeK+HenKWXi1LIVdLd5Hg7 0Vp9mEpp9mV2gEnqyH08ZdVFqdbJdYIpPV731x/2yZNCm9OmY+qyip0i3Qe6PvI/WhgpQNKneXSa ixzxRAhzfvim32t6zsjcl6JXNXsvHnqR3k1cCjj0tx3Hqakoelo+pAb1Yr4AihqBtd47zcee8Tke REJaKLdzRdXXFoMBgf62gC5FU4oafKU/mBEqpQUceUAFYgkqbNpJtVSlhvQdBzivFRRiUMi4oGP0 tZKoSUeXqJo75ncGAAlqPOTqKrkw+XkF4CwJdBBMARckCBAYJ/5LUgj6XBFbLV1a/kgQgPBT0TQ7 vV8LNoCa4ChfGKLIKtXuWJ3arDHgN9Aedo8/gI9G/wQYAJHaWIe/1TJpAAAAAElFTkSuQmCC ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: image/png Content-Transfer-Encoding: base64 Content-ID: <001101c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline iVBORw0KGgoAAAANSUhEUgAAAFoAAAAKCAIAAAC7RN6iAAAABGdBTUEAANbY1E9YMgAAABl0RVh0 U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAMqSURBVHja7Jaxa1NRFMbfi6ZNW8FEKBgX a4pDBWNLFNRFhHaoizgoODiYoQVHl4p/gNilY6Ed4iAo2EG62KEFcamCltYMVijWOtgIgknBpLHB xt97X3L7eC+N+QN6uLmcd++5557z3e+c1q5Wq9aB1OUwv4pltWWyf9JJa9cKh3ZtK+QzWvpROJ95 k4h2fbk36Nsaer648PVnLBL+kL6CgT69Bqxz1rsyf/vy4KlufD54/WkpV4hF2lLxo1PD/ccmXnnN sMFSer5c0a5Z7J1cWC8Uf92/hnMUc2rs0mkCwLluYRddkSuL1PEoIeFw/O3azOomZ9l9fPXMzb4T NTjAgrk9ky2DSAALhGyZvbdKWFHyeMc1oXAZxugKHV1nEd3neOsIYz/0bJEZGx3HDAMUOUQnymAk 7OKcXROMFN2Fkoh2JmKdZM5IxaPMsmEAvWMQ62QenVvBD1c4rvKlfHlnjx3FdLLLRSSSyf69m7Tt Vqk1vfxNoeMaHTiAmRV7dZZ5avgc95m4X9y4YA5iLwhkYwww5tl9xj7hVQ2yRrx+9DbrhVItfzeG pdwWK3zyYAqAeWTgJDF7/YTcX+W3wwtHDj3Jtl5pcioIDFP2k1sv32uYxyRukg/WVxNRlQXtR+c+ yjm7YhxY6CWEnYOIyxTBoUWqlRrkLJF44QgfydRQKNdx+a8QkwqPoQimVzaaY6chXlDAIwM9KPgB kWAlNpSxi85jjr9b83e3XKHmfLuignXz3zKZgwVFIUDFPgiFTjDTyxt6pFqxtNexKKX72lqmhpLn VvvRrAFIqTa0rz687v0ERAKCWb2T85yCzA2bRZAdjCA71MjNJ10DG5kJHbdYiqKGCorHYIAF7DAO HTjKd5KRp9md9NmQRd/YtqyOJoSv12q/t18aLGZWv3NH87Mj/T30M6fJx6Omj+rRWiRIw2JRGCSs ji7yKn+hY6ihYOCR03RzW94277IjbFX3aqQBFqa0BIGpQO/fQgIC6ZnPm8Ch7qVTwbODPd3E57R9 t9XhBI4oGRnvRxOt+wiiu3wAcQUdV0AoWsMUE7+Ki+PAZxqqffBvmFf+CTAAxcgR12FdgtMAAAAA SUVORK5CYII= ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: image/png Content-Transfer-Encoding: base64 Content-ID: <000d01c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline iVBORw0KGgoAAAANSUhEUgAAAHgAAAAKCAIAAADw7A1PAAAABGdBTUEAANbY1E9YMgAAABl0RVh0 U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAMESURBVHja7Jexa1NRFMbfi02NrWAiFKyL acWhgqklOugiQjvYzUHBwcEM6e6if4Ho4iiYIQ6Cghmkix1aEJc6aGjNYASh1kErCE0E28YGG395 R6+Xd++7JC069fB6ue/2nHO/873vntv6rVbL27V/bz38ND2vt1j5kct4W148tuV7Mavr0XtzS/W1 17lz2UNJfX3i8fzch6+pRJxfDSf75VV3WL0+ear4gli1cuPMsdvnj5e/1G8+f1teqacSvdnBA08u nrbGkpkJziRR62xEhksjhwVVKLMJ1epmxc9KrdG88/J9qfqZEPdGZgkuomGZcW+x0oDrCJYx2UbK 1heFGsCBjO2pDR/mLI4PDTDnkVh5DWjqw3/i0TwjixLOaI2VjdSEmpdq61R4+emr1aFJM7MVqtXN ip/51MwicyiWvWqNTWsGawkuotdymf6A60Sx8vNaxve7OBGFhY9SPMiYK6X41WnG+xdGRSNi+iv+ IAO0vuiIVSaqOXj3GeFCgcM5ZKabiV+wMebHjshrVAZrCVEWC36a39tabtueB5WuWo9gEoKUOqJs auYNMuRBjyINgHIkzY7hMMLpIQTCgipPz9whAAd+eGekJ/A5CdGluu0ShOj4/uJvfht/GO/ESC1d jEeOT2Fx2eFPL6OwthA2mtIT82NpJuQBqN4B3ZsKTfpVoWfuEIADP4cGkbICiYWFZWjdeQk90p3l ZT030tuNnAUW2f1b04oFOU1Wf3XbqAuNeoK7a5ao8sq3To4/16PIB7pFembmKAu5ReEP+kaaB5aR sC7VbZfQJrpxNZN4WNnMnYh59OcNz9vnPn3CIydXv7UUylL1ExDdsYgRjugA2cGkXCOsi6Y6sfzJ NHuxu/rLQc+sGqsO1XQDZBT+0ru2YIdTfRCnOskOSwgUHfdafztGJMt8K70Lj6cHBOXslbMKBBIA JTWIs+puoViRDBA5iZIEytQ5CMWKyavoRajBRw6+eTeEFvkwphuERuGHROkPRPGR5Dt1VYJp/u4/ LP/HfgkwADuarbNpWVvhAAAAAElFTkSuQmCC ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: image/png Content-Transfer-Encoding: base64 Content-ID: <001201c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline iVBORw0KGgoAAAANSUhEUgAAAIwAAAAKCAIAAADpSyGsAAAABGdBTUEAANbY1E9YMgAAABl0RVh0 U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAARkSURBVHja7JfPS1RRFMffWOOvgjQIzBZZ ImiQFhpUmwh0YZsoMGjRolkouGxT9AdEbloGuZgWQYEuwk0uFKJNLUrSWWRQmS36AUJjkOPUUNPn ve94vL1587RNtOjyfNw579xzv/d8z49rolgsev/Hvz228lfwvOp05luq0/vpJat+Jryqcr2ZT8s9 6Uea9+7bdf3kge6mhtab0wvLK89SJ5i7ygj5xGSgo3nszBEJpby/Ydub4V77+fnSKd5mWYMl5+4/ dSXsOHX+eDkSrLHF5WNtjbVJ5CNPXs18/JLNf+/e3TDQ3jx4uAWdbL6AfHz+g3YH+ejs4vTbJdc+ MLCAkE9YkGb37h0gEU4XCRaYhDADj09guPLwxczH5cbaai3nE1sHZktClmNcpzBvbEwSDPGuSWfy 8BTFEIMzGEoOcy77DOtCb59sjD5/p4nvmpP+gcWc3qPPF3GfndyW4+6S6xvrmeNcuZK5LJTrowAB aA4e3iuvES4sR86zsJzDI0OTs8AQnQvZnE9hUwNGEOo4zHlANTQ5J/sIfajZnMGWGvxhdmh1buxs TwhzY10SGH13H/PWcia8gQdtspBdLbApFghrncKlfwOSVlKd2wKeatOZHxc7E4m4BYTMzhsPsB6z AVBALy9AmELPxsiT14rx0LCc09zS0ZWH9Dlw373H4/PvBcYSl63JRRxEkgkGLDJ3lyfmJ3jf6u+C PxwqV6JjaOVlDalpO1fuYmMjPuF9KVsSS010ggo19gr5JH5UBX+Fr34O+WPL7Uz8AjZ2UZaPIIRX Btr3qAbKR2654GtIqMEB9GwevZBQRigmPknteyzAFarI5R38QmyRK5HgUZNcRAoGKWiByMJAModZ 178uZmUbdogtuMQPMovQEk4Iycg/6kkiKbk9XeImv8ZWpdF6c0qA3BL0W62bXSxF36kuZbTbAC4f bVMRiMw/PfFBsJ4K1ybkHbIkRo0oJrT9apMvUNNigkB1DzVD4rKoruaWuBBm1lLHKBJqb/BE44nc aJNV7jeSatYYyqU6qjdaoM5pbbw8tHU2wtBaq9Hm9wxaekdzJPri1dN6yptc5MAOHoEDwh+z7kbG NPKgY7UAGKqU6OWmUBM9sMgEDCEFvB+qlpGYCVx2eTPc5x7BfGIIQ/esTfWk/IXO2juZ76mDVR79 aNXz6uIDMyRREVCtUNmx3qvmz+Mmx+ChlkrlzhS0PH64SIibnreP2IjIoIeLCd36/C6yWuA2oSLj 5oGbQ8EVY46HJoqFch2s6ZLi5oGLmS3YXeGixAruRzmlb++sf3FQdLoYzEKl1lsiqSbpFderXF1M 9Q+VOH661cz3/ssPcpldf8EtHSkrF3VFDPVnY663BYZ2Re5YCQmxyW0zuP76F2jsA0a+4JMqEktw tCWE8NjuAEaiKziuZI7T6XamxkSwecRECDNCHoWp6s3aJaJ+enHJ2h54/GheqyVmIdtfqFRCEv// mf1rg3iFG2iLvNzGjF8CDAA6zyxhIDjExQAAAABJRU5ErkJggg== ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: image/png Content-Transfer-Encoding: base64 Content-ID: <000f01c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline iVBORw0KGgoAAAANSUhEUgAAAFUAAAAKCAIAAABKT4UvAAAABGdBTUEAANbY1E9YMgAAABl0RVh0 U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAMHSURBVHja5Ja/a1NRFMfvS02aWsEXQWh0 sFYDVjC2JILtIkIz1M1BQcHBN6TQ0SX+BUUXR6Ed4iAo2EFc7NCCdKmDBmsGK0h/LFpBMBFsGxvs 8/PeSS7X5L3g4tTL6+Pek+89P7/nvFqu66p9vA7wV1cqViz/ctJqT0Uje5aKhKFLX6t3X30obVYT 8VgmefjZ1QunHi6sVbfeOpcyfTa/ZouLA3bv6uSYgO+//lTa/MEecGEkpTFaIeB7l8/OLG8srH8z DX2/cyURjyLkJzRUaruZpF24mJqYe6/NAdPWTZ2ssZNH8Q3rsytfAIiVa4PH2iPyQiV43t3Fshtp SAJXpVbPPVnCJ1wZSBzkiBDtvPFVv0UicWIeIQ8bjggFw8IbYgB8/fkb/NPO4Tp7uZJ7uiQaEK5V tgGb5kzrXAFjap6YWyZ+OQIgg6H133LSvX4K4sXy79tpywqOn8iJGV3T4+fxuDOvoInYpg5sCJJI EHJXACI/8uAlOgsjp1ForbxAIsoREgBH6gZxtFrqH2gObeQCOmjN1pSnLT98wrweXP+Iqv+E/P7q elQOg5JgP5F1zFAZk7HUFnsmCekRL/4zxxs18TcilEVGwPvBp9qzCVJy3dn7DksIRcZJMVkTtobF Hz1UbIRdayaifeENnZYf7pfOJAVCP7+9bY91Sfvf/UMD7eDd7bP/x2CDBVCJmhH5zLsN0h0af3cz +G1nMNZRKYVC6epkTjpQZpuQVuxppORi9uNnOcrGTBATTjpWstCyQArXpIdNB7Rdnf2waUWp5m+M ilct8/Wv/q/dSscfl3edcxFF7+8o1RMIxR6MlRiEnHrktC/6Nrvuzb9sZVEHidDE5If6cQtMi1y4 hhDeQmAAjFvmH83Mg4TRwHcBiXRl4DCi4JWdOhclWYHDv1n/qHKddFRZXZ6kJ5z/fPNsOpMHq/M3 R/FSbEt3yVsksJpmwSpCHjby0TIxMlD0VDdV+aPLq55oIAXiAOOAvICUenKUaddiXRzQF4FNjw8F BmXt8/9//ggwAK6HxL+2zlyPAAAAAElFTkSuQmCC ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: image/png Content-Transfer-Encoding: base64 Content-ID: <001001c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline iVBORw0KGgoAAAANSUhEUgAAAFEAAAAKCAIAAABDpCVVAAAABGdBTUEAANbY1E9YMgAAABl0RVh0 U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAMBSURBVHja5Ja/a1NRFMffS30xsYKJINg6 qFWhFYyW1KFdRGiGjg4VFBzM0EL/gfoXiC4dhTrEQahgBnGxQwvSJQ4abDNYQfpjqRUckoBtY4ON n/e+7eWSH5rOvbSX+84753u/55zvvS9urVZzjtg4xn/VccKZwu90wtlzvNCe64Qa/YqV6tMP37LL 31dLWz2xzie3r472dV96Ns/jp/St5NlY/kdpILPAq5WJYdmJ4nH44hmceeStoDASOzl4JR7xiAI2 v1kuVnaTXbHR3u6x/gv4GAT5gwDO6al3NiUsc/eGtLZ3N+GG2KP3X/KbpXgknOw69frOTT89EmY+ ninU/KdQ09qMzy5CjgV04QpF1qLFo5ll0Qwn5uef19lSbxVOLFA+j4AodeQtCc+v/RyfXcJuI/DH +u6bj4oVptbkY+jZu9vEaFVqJgcy+D3xEzzu93krnegM0o5kCn8eJly3Sc4wYx7rP09/2pTQ9Mj1 1eJ26lUuu7wxOXhZRsoMAxnFDPYYtQW5UQ6zBQi0jvbClUrhRgg9FE47HNiLWJIXlIzqbPUXwg5G x4tC02CYMdMEGNANFey/Q26IqqkRvfnIvefMFmqX7IG4lhAC/lTBMD7UQBfqNpWi0JTA5OydzOyn WjlIvm5QV0oFBPHIVWL794Cu3FCHMbqP3zYaWw2SR/8sbBkfapAwp5o7goX0hVJCOsny2E73hVt3 jEjuDDKXZnS7BMzKZra7wREihGLZx4FmGiMO/oFfXDfHRxKQnQFdxRqfdpRVp0EowXllInUgorJ/ nisPEpGXhd30tZDDWd5xnGgjFs0p7lS5BpSbpE6vUDvXW/brhqpgd88+QrZezJrbeGBtgUAUEY96 QtB9bnx45ITzSt+LVqnqA+F3ciZnVI1R3wsVUQcbe9Bnz6mlE57jdvjO0aagqIsY3WTwmB65oQW8 gcauL4raInJ2vbWuIw0mn5bgJq8iY9hQEUBsBLE0ymqKY6qJgtRnSUm3Bgn7ZyTAn7s/BKB7BH+T /BVgAFUo0zRyYB6iAAAAAElFTkSuQmCC ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: image/png Content-Transfer-Encoding: base64 Content-ID: <001301c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline iVBORw0KGgoAAAANSUhEUgAAAHsAAAAKCAIAAAAb27ZMAAAABGdBTUEAANbY1E9YMgAAABl0RVh0 U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAQFSURBVHja7JfNS1RRGMbvqOPnojEQ1Baa IWTQpGhQbSKwhatokdCiRbNQ6B8w+gMiNy0DZzEtWgQNFG1ykSBuKkjRZpGClNPCD3AxBqmTQ06/ c5/r6XbnzoAuXHm4Due89z3vx3Oe9z3XSLFYdE7GMY4a/gqOU5vK/E7EnX0nWrUfcapK9c49m/q+ tT2buN7fGvMvh1/PMkHSFWvqbzv15MYFJiynVjaTC9m59Z+5/F5/W2zsSvfg2Za5ja3xj8sIUUB5 7Go31hAOpGbk5dXty3d62pmg9nD6q8x+ezBo3bE8/fQdcqy9v3stly+wlI7fKcqKB4OlWdglAeCd XRNDl0b6OpEk57Ojk18wTiI2Kg3ckUiodwKT3A4UcE0W6cU1BYNBpWYQB25+61KZPKCHwc1QoM31 0cBSExzkdgtYJ1uSZzL85rOBtTVG2oJgbiOqHHRm6PAQq7VpEl7IKixe+R0FvAtcHiCwbwWW1IjH yHM7oVnwVqa6Yo1MsJNeWhPiU9lNo9DZYn0pHmO2oax3lFHjABBqCxCPTi6QBROWRALz/nF8OxFv ckGvT2X+3I9HIoeuFDgi9rnIbuEMIacKiazOzZcfFI14x5EQEERmr0WTiImb4DCCQT8fS8f4p2VL YXapJvCIXyusEK3mOHKmPb9C34+yys7O/Qb93qVGtNSQ3RJ5/Jbfkb4OPwiOGF3lFH4ZdptR/Txz tPaEPwU0t76l6AOekJtkzp/xuONOJFQyImZ6cTU5/yOQdulAGXTsdjkV4jpOHg4+9MwoBSkAt6lC t+awINxZ2vOwplSy5byHDsUPDyAiHu1p1biIRxtSHtD5A+gPNWgXsqiCOtqZcQam1SytqRtQ2vTB csojvZ3kDNH8Qo6Zh0hsU7J8D5y9osWIYjbd3O0npSdtTeWGCpW9BwZMT3ZmScfcLvNZzp7W73G8 7gDunURPbZn9wlGXXilx6GgESrXihrnSDuClrpdeWvUycScSWuKorrHPvKu5sTKDIKOagOzIKbkx KT66VWEvlwcKPKoqe3OUthSGNHn8t0jAe+ggGO4GUFbbtMqG4/l78foXmb3ExSqHHr7rOA0hnOrr oECoUy43j4OAckBnf2ckMphFHaFvro7mRvTZbm7/lRkkA7kZr4H+z0HdeOKU2Fd50EBssVunPDQl /y0X2lUEH6hhxHzVuJ9MgaRsV7G89vPD7z108JavCdIXTe1BuhyPOsVEPOpEqo2koVx6+vLTWbHU /aD4AneUzlbXtxBsrq8lK8glIQ8TfWtqr+youQt6vzzgxVN2iWaXfqcEidAtmtrSSjUfJ+6XklAW nw46W3vgkpSmPvIqeLdb7FKpKX3gmhjqlTxy8h/QMY+/AgwAA1TKE4ACV4IAAAAASUVORK5CYII= ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: image/png Content-Transfer-Encoding: base64 Content-ID: <001401c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline iVBORw0KGgoAAAANSUhEUgAAAIwAAAAKCAIAAADpSyGsAAAABGdBTUEAANbY1E9YMgAAABl0RVh0 U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAPmSURBVHja7JfPS1RRFMffG5vJMkgDIXWh KYEGTYW2yE0EtqhNFExQ0KJZJLRsU/QHRG5aCrmYloEuwk0uFKJNBiXaLDKwzBZqEDQGadMMOX3e +46X6zDvMc+VCy/j5d7zzj3ne37eq1sqlZy9sbvHPv6KjpPIZP+mk86mE49tuk6sKmvX8NTi2vr7 9Pneo40z39f6Mq87GxtGr/WxEAPbVE/r/XPHm+rjuXxxaHph6usPOOEXHZ6R2aWxTyszq2tN9Yne lsMQjTQJ+XJ3ADkc7xqeZIaCRmap46tgoGLyZj9n4Tny5KU+wYbGkbmlmdVf8EBExejVs8aEi8/f wGAbhXCjWiY8vnACtDY/umDjExRjeDgS4yu2EDk4cKx58kZ/JLRmePEgQsz7M9lSrEypOhDEDCYz C6K+YlguXyAwD159hI4lrFkAzkOz5LmGT4MTH0DW29LIwbH5Fdgw2whhQPTnZUVIuow6M/MVaRXY yADcigSQoLez6eBibsM2QemiNQysbfx8Rc71F++kmrUiylaobMPDkdi+0kCUyY8a0W6rpPV0ssGP U30m++920nV3UpKkACB8rfi3AA5sJsUEFEtUW+KUp3AHELHw6aVTMgkewkl5MZuDQRpRx3Elge0s jlMNhmgfEd2dH2dGKckrfwkVM2nuQy2gfWT2m4KHFtbqBLUgCRpDbxdModSCdlslxZzib3qdP+qe ZXfcOqWDPkb9Sr1JJRa0OC1MLqe627wG4tN1HDsxWClMtYVE6M6ZDpUmDhUFOeKXN8kAfoMTcyYM 4QNmyhoJHFdnU/XIg6aqakFSdcg0Y2wktApS/FCmHJv8VrSiDvfROGp80O3hcMMs6WjeMriY6m4N 4cR3qoOh6c82Xb1RDUq/GlXr+lRL1Fb3BD+VCJdHJCSVsTzdoWLaAdqYbiNtNtI9iWA15ZvTrxLN opieTk5RzqSGrKK52aVAZVT0d5ltdwkVmRhSPW3hblWO09mNfBkMhUXp4ZVI+fHz3mUhUaiEDdeT fKoh5qDKrkBSdejOM+UYCa0XpPwtr3oK6ZMJJ+46f4I7TDszJanCNBTT0+ny8rKSC2t5oXFL6QcU U9ps6S1CbPd6Za7S2b51g8y2Awy/nMXbBOGoiFrHSnb/Ji9nkh4Xel/4xOVakAQN29JIaP1Kijul dDLuuHUe5UCIDnkfA/RUhaLksktKW16fau5e38htiIEjxBJ71JGxjZeoHq9GiMKsWRQ9OszW1kVa KJYiUso8c/13ZhG96lTckVVbgmTakn3mONWjYOjRDGD/peOVNf881IjEVmGbpl4aCa13lez9M7v7 x38BBgBv1wu8c+DZXAAAAABJRU5ErkJggg== ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: image/png Content-Transfer-Encoding: base64 Content-ID: <000701c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline iVBORw0KGgoAAAANSUhEUgAAAOYAAABQCAMAAAA6J/nhAAAABGdBTUEAAK/INwWK6QAAABl0RVh0 U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAMAUExURaHW6O/4+6/d7Q+bycHj7/D4+5DQ 5Z/W6DipzpbR5eTz+H7F3T+u0z+s0CCbxNju9bDd7F+72RybxR+hzG/C3uf0+HDE36bZ6UGpy63b 6i6lzBKWwo/Q5hScyUqy1brh7WC62NTs9Pf7/BCbyez2+lC63WC82xSaxqHY6qna6gyWxYDK48bm 8XDA2qLW53LG4pfT5y+q0vn8/SChzECu0r/j71q21H/K47Xf7TCmzfj8/TCoz9/x+ODx9yahyen1 +d/y+HHC3tzw9tbt9DSoz1C01k6z1BCZxgmWxk+01jCnzuLy+B+gyur2+YzN40C02vT6/J3W6PL5 ++73+h+eyQmUwuHy98zo8lCx0fj7/A+Zxz+v1LLd63TB24/P5HnG4FC01G6+2Umv0uX0+M7p8snn 8CmkzS6jySqjykCv1BCYxDiq0CCeyHrE3WS711y41li52ReYw1C32Eqx0wiSvwCXyQCXyACQvwCW x////wCQwACTxACTwwCYyQCMuwCZzACbzQCPvwCVxwCWyACOvACRwACUxACSw7/k8L/k8c/r9ECt 0X/I4MDl8X/J4d/x94DJ4UCw1IDI4ECs0F+828/q88Dk8PD5/H/J4p/X6dDr9N7w9t7x9xCax0+2 2Ov2+v7+/n/I4T+t0c/q9Nzv9f3+/lC21y+oz+Py91Cz1LDg8BecyHfH4YbJ3z+w1hCSvRCi0gSV xXfF38zo8QyUwX7J4YDO54bM4+z2+XDB3HDC3dPs9K/b6jOlzHPD3b/l8cPl8bvj8Lzj70Wu0JXT 6Lfg7UOw1JjS5AaRvoDJ4kOu0lCvz1e001S21jChxk2y0yCn0yCo1cro8kGu0UOt0ASYyGW92w+c yxSfzBSayMHl8ESy1tTs85zV6Pv9/TWlysDm89Hq85LQ5Mzq8+r1+XC+2DWq0Nbu9dfu9gqSwG+9 11K216fY6N/w9oLL48Dl8ACazQCazACNvACNuwCVxgCUxQCSwgCRwQCOvQCPvgCczwCbzgCYygCM ugCZywCLuZAcnasAAAhmSURBVHja7Jx5VFNXHsffjQI1okJJoigFAi0uYVCISKkDZEBEIlUk1RlB cax2ERdkXH/KTBdFXl5CAsPWsBRFxVq777Yd2+lMO/veqc5SZsbZOjNOZyOBzkbvfS/v5b2ERHKK fySP7znm/tZ7f593IYRzOFLA6/Xpc2aOhqsojvGvf356NJzFYU4Pb0gOE80ZHQ1/TPT9UTlgfmdU Dpivj8oCc6YsMLNHZYH5e3lgzpEH5ugk5iRmqGH+TxaaxAwrzC/JQtS/ZCG5YP5TFpIL5vFxa3/+ r+qOf/O+zdOubcqY/u7xkBI1EkBb7zFtHBysUCdtrqu7lhcR8UqEKWtj3vNT307vLnhszbyR0FEg zHtSMj5388j+1t3xZzaebd9cNzIyb1lSd9+Tf8K5eZvPnPluOGDOVP+mjrd3vxIvxPf8buou1niy b2voYH7kT9eKBPO+vj3izPOmeey6tbz1oxCRX8yZ6rsFe3uSJPXC1O6bWWNTUshjLvNc5gsn67yS v4xnl08VhQzmQ3407bOCmVHknfyKchlZarsfChFRh/zo2u2Cqb3qk82YRV53aw+FiPxixscLpun8 oftrb1ov+DW102ZnfY00vxUymEf8iErirf1Z38i7tbtPe5fbz+9G2vSsWmxtv3okROQX09rOW/mD 2otrBstnLXT724sGT2rVd2PrsXd9+3a1Et24gVuTv0zUukscrGllg+c9QWn+CNXgRzOUvDXf1NBw U8rGeLXbv/XSpuz1ERcaGvYVSDtAJETtaph41VAIb52d3Y5PaP88H7xIXJSNU2C/WMPGssEqaaSG /Uk9l7ci2Nf5EW630Do8nEuchVMlDRhzBi9rO6Dc4YlWTTu0r6xhzblRAFGsZbGD3cqdlWu1A7IQ C2NKOv1jal+WYg733c+t8R3Dw/vysKF8zxtT5EWB/XpT53YkB4dpBXuN4KwEIETJICGqBkgOCvP9 bLexCHGr8gfcen5w/fBcjL7HvigAZg2+2+tMPcNrlutKOrwCFPguOSyPkll6H0yXP9Uq3caKAm5V f9sdsC9xudAq1/YMaUM/gNjtAKsrsPqvW+ElWtJgBRrPAs1eRc1g9650ufxjXlDnc8b38ji/Yr47 szLiLlfFvSvK88eDabE0WyyeqMVSbLEYfTBLSNwo6jZaipuFBj6hIGAS4css8QqVICgNAtP12hpu /Ql3rVatkCma7bpz7qyFrkCYJZ2Q6yojf8FB438xLKkxBr8X0jQC1EweOCsyuIXY+I3SXuwiewBd wiZxAjfQ9GlAkSXuExRGyZnVEOMzdwxU+2I2+tWpDdz6M/VKsiirhcy+1XvRvsFFXvV4CJFHAd1Y jNCpMmyXxJ6GV/GCUCybK1NAVGNu/0WI6u/PbWyMBBRbwpahSLIHISutbMxtfBVOl5L6klOAjMQo JT9POppjjfwpNDT7zN2MT6bhlCRG1fvVhYjlnEH14JedKb2eVIfptcJp3vXRAEvdKo40AFOpR8jI Jxkoro+FBN61g5402IhdDAy/dS/GqK8H3OuVMIKdM0oTuK8CxpFGchjTZ26MieM2SSwAZn16jJtX m7ezPj1dlDGm9PTUj4HpEa2qr4+CNCGpB0aMGWsrEzBpWCqUpXGY0Z5nIcyuEuyyaJuCwWdE9o4f 86h/Faes4oxNWRUbUt5OfNaTSjp5dcW9ic9dEpdjTGn/p6HX4zBwtBKBY8AobrCRRdzWSxx3AD8Z T8IICunmlbEI56Mg0mfsSFxKc1sLCoT5rHIBu1b3rLiw5aQ66zNC5vaC95V3mtTbVgfElPgdEH20 LIpcAnR0fGupGLPDqwdofj/J18dR/VKj13lGFRh8xu4ClS/miQBKNO3Er0vuSEx9bsPsEz9OERIV sfjlDz8/e0lcjY+Vtkv8v8E5dj0XbbPR+Ds3lTTYvMtSiQO0ez8mWqwTNjBI9kdgw9/MA15D7wCI O0FzWwuinIG0sMfpfNk00HOHeo0z1VQhxLMKZm0wlaenSooxprSbAb3H6ZQkHeAgDY9wZcuFeBrZ A2jOAYOnQb9DTw7QizcBUDkfgU7pFKldkOB00tzWggJjOtvRmW173zS9+M5flpSvLuSjt/S996Lm nUqvWh/MNsIizO/APNGeWlrAbIMuYUaDGNMBA0I/DW1OJwKFaHt8bedIokvMntoEjDNozFWJW25x OtcVqgvSVR8KmDuUY9X6YGIuDd/RieLwkxewVdxtOtw4XRxPmoERY/Ya0A53vYYdvhR/PBCYljMs dK8COnX8haamdYKidyzMoXHrw0Le0vxxrHwVgFdkihm6NC0tLZoYYDKxy4A5DbstAwuAmYJ9BJG6 NFzXhi+xq6kJUM4Q2QPM7v44M9eQhtcpJPAoLmR0Oo1Gp8MPJIGNsd1NOl2LThfTST5NaXDMDIYm sYLA1GzjLcdbY+UzzWaf2KMKPAMYFG2c2+Ywsz/bFW3shJkOszmBA6rKyanCT2IIEJ4xwdPvMLCf Bao8ATP3a7s5J05Uxb6Dg8GsilMBmPVDCWapgsC81Mdb9LqhCZS+Re+xwfxJt8tkDJk+QerhcWtv BW9ptzw8gcoEs2DngOqTbzjFN0QdHreqUnir4AuHJ1JvgIYzLuuAOXxDFATmT8/yvMorEzrDZQeg pgW6BU0IJVy+QZjHxq++J7hV8dtjE6zLT+UQPXXsRok6OH49gVoO4OWrg5kHQ03BYB5c1/cBY0j5 4MrB0MM8EIx+kfD1xVcOhKCoA7IQ9UVZiPqvLDSJGVaY/5eFJjHDCvMBWYha+w85iFosD8xf/10O ouCH8sB8/EEZiAK47T/hL4zZmSkLTOhcKwtMgJee+Xd4y/1frxgWPyMHTKzHX1r7o7DF/FiAAQAC zqXbXdvVgQAAAABJRU5ErkJggg== ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: image/png Content-Transfer-Encoding: base64 Content-ID: <000801c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline iVBORw0KGgoAAAANSUhEUgAAANIAAABQCAMAAABbP9ujAAAABGdBTUEAAK/INwWK6QAAABl0RVh0 U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAGnUExURQCWxwCTwwCUxQCQvwCTxACRwQCQ wACZzACMuwCPvwCOvACYyQCSwwCWyACbzQCVx////wCUxACRwMDk8NDr9ECt0eDy+ACj2YDI4MDl 8fD5/ECv1IDK4sDk7/D5++Dy97De7WC62NDr8zCmzTCp0UCw1ECs0KDW6CCizcDl8HDB3BCcyhCY xfD4+zCmzDCo0IDI36DX6SCeyBCayBCbyZDP5ECu0yCfyXDD3oDJ4bDd7IDK4yChy2C82hCXxFC0 1CCgyiChzGC82zCnz7Dd6zClzECsz1C22BCYxHDE3zCnzSCfyGC920Ct0BCZxlC213DC3YDJ4lC0 1ZDQ5pDQ5aDY6q/b6WC72WC61xCi0n/F3IDO5xCSvUCoy0Cv0+/4+7Dg8CCawhCbyJDQ5FCz1EC0 2lCvz1C63XDH5D+oyt/w9oDL4yCo1TCu17/i7SCex3C+2EC12yCjzuDz+UCu0m+91zChxiCn00Cw 1cDm85DP43DG4kCz2QCazQCNvACXyQCNuwCXyACazACVxgCSwgCczwCbzgCYygCPvgCOvQCZywCM ugCLuXbyL6MAAAUmSURBVHja7Jz5c9pGFMdVUal3s0iLJASSkMAIML4w+Lax4yM+Yidu0zRNmqvp fd93m7aiV8of3V3tLoJaNGRsZ4Ydf2cs7Xvv+97bjxnP+BdbaPOgu+9dvwqYhDYvev2r93lDQlDX uUNqt2/e5g6p/fVt7pDab/OH1L7KH9Jd/pDaH/OH9Cl/SDf5Q2qfIQ0F0j/c6QxpKJD0p3mToP/C m7hE+pk3cYn0LG8S9L950xnScCD9xZvOkIYD6RneJOiJo7o2ibWVAFuJQURt1mRi8pPEowv1naAt kYhF+t7ygGVde3SkhzdsTT4GJDlORYCfoFjbxO+V4kqMheQ2a8gmy7WibBnhqeNFFbnY7cVPw6LV lXAy7evNyWSrXKx1VvfYHqL/R/I9z5Nld8xyXBxvNGTZc9C9Gjg3hiLgeS4GaSCLY8hGreZYXjgB VcYqnjW2KVNvWLEAACGmb3lj6MakD89902M5sNHZylbT8YMiKXHaB/gJNpRtu7lnjyv7Do5dT9nz nHHFa+6BcWXbcbED2fbHUTgODHSuWHQCaCguaCq+r1AvqRi0vq0ofkOhfU00fcOlObYV7CsKXR2N H0SCLsUpBfATpCRJNSqOYRggj+IqmK0YDaNqS66KQsMPHehRwaFqoEfe9qsS7cVDDJV5ScVQyYLm guqoEuuz87N2lebo1rCLro7GD6JBkGAKKbzoggvzeej6/ZGk2QW7GotEKhQpZafwkfX5jYrPcj1I ZPWJI83iT4h8613oSJKjutKsnZeqTpMhYUse4J3IF36gXUjUSyoGDAdV0GsBlWhf3nZSLMe2oi6J ro7GD4bUilMK4CdItVrqfOtVW4ULYfoA3Gu17oGDVuslW7XniQM/LtuqpqG4NQ81YkVJPGReZV5S WbXhZVRd1SD0UYn1aVqUo1tRl8ZWd8YPoj5I/yXcjckddEerKXrY3W318ZLKATWmVnv7unI9IVnd YzsRpKGSoD/PmwT9Cd502kjqfFwWfHmqSE+eqtRDdpo5jLJg5hRX9kOamQ5fS+v4Od0Tdao0S7W+ hFNLkRv5Z0Kk6bDtUA1HrRMkOng9GjfdO+44SMkYLZtl80oyCcpQK7+BI20ZRTkIIa4uaWUYeW4l k+VsEkC4HBqZG+kKOmnZ5FQZmkvJMvqF9RY9J8FUOJhEnXG07bgSdPGo1sCEWNfOiyAnitrcmjkh ZjQRR3XzEirPpbs9GVFMZ0PrGj4ztyhOIMcEyIp1UZx6WRSzuIueyWAakXGdtmMrFuk8XpKdCq+b zc1p2WwWXY9eHt3VnKr3eDBShrYxNyVHpUu5tJamSPRMBtMoHBe1PRYkmEGqR0jiWs6s90Wi7g5S xsyEOPiLnclgFuFxUdsJIAVHVTILwah2IQA59LpYAoUgGA0CMBIE6cWAnAvMA3eCAlgMizgVMDc5 odIODIJcOggW0ZudyWAakXG0bWQ0OK5ikYILZtpEl0c/81p6NLhopmGuC2kRarmOB70gJEj4rDE3 0g4KtcUS+m30lTQGhjvsDNJ4MI3IuK4lp4JEv1tgpFQgUaGnWChEnmC0+xIjpW53aSRKUiM9B2Qw iQqxS46BdK6/wLfnhlCCLvTXB58Lwyhd4E76C7xJ0H/lTVwi3edNXCI9x5sE/U/edIY0HEgPeBOP SA/4Q3qKOwm/8aYf+UP6QfiJN33HHdI3QHiRM90Bwh986R3AG9JHJm9Ib5n4T4V/50ev3SB/0M0P 0LtfAI6QPvzsxp3OP0f4V4ABAMN9QpDhclnCAAAAAElFTkSuQmCC ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: image/png Content-Transfer-Encoding: base64 Content-ID: <000e01c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline iVBORw0KGgoAAAANSUhEUgAAABwAAAANCAYAAAC6hw6qAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz AAALEgAACxIB0t1+/AAAABZ0RVh0Q3JlYXRpb24gVGltZQAxMC8zMC8wNJK6WTcAAAAldEVYdFNv ZnR3YXJlAE1hY3JvbWVkaWEgRmlyZXdvcmtzIE1YIDIwMDSHdqzPAAABqElEQVR4nL2TvU/bQBiH n0swiRNhjPgoGyCxEITE3gGHrXSBjSmkjEz+A1BFJzpUIq1YUVA7dMmQiYEBmbnqhlQkhmYAIcWt 6gocSEx8HVIQHz4+MvAsp3uke3+6994Tv+aRPBO9XyWxdg5qGQstYz3aX+K6Lh23pfHWQRubutoH P3Y5+TCLrHkkpvKkcwVEqhuA062P1L/YSh/FncBLKstZzOk85vQCzZd52C6QzhVo+n84Wp1F/n8I GcCwwhva3brKlvp7Duw7ADROPc6bLS9SJsmRSVJehcSBQzJ+v3904HhZYi4VOftWxtvZRAjwP7fa 9GJxjYH1n6StPJ0xtX9SYGU5S6NaQctY6IaJHof67ibHb3o4fD/Hhe+Ryq1x1lT7JwX6ew610js6 0iZdr21CCclXNsaEhRF4UPMIfY+TQO2jUA4NQPi9DBTpzi5wXFqhd8Ym1jcEgKz9xd2wEYCu8FGI qI//uw5BCIM6hBKq5xAX0J8Ef9QilK0OxAR0aaDH1f7GBT5VowMfohG21tuDofLXA+9tqQpVQZW/ jpBSStd128lti39ESMqxWib6mwAAAABJRU5ErkJggg== ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: image/png Content-Transfer-Encoding: base64 Content-ID: <000901c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline iVBORw0KGgoAAAANSUhEUgAAAAcAAAAXCAMAAADwWqV6AAAABGdBTUEAAK/INwWK6QAAABl0RVh0 U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAAeUExURbe3t////8nJye3t7dLS0ry8vPr6 +sXFxcDAwPv7+z8V/wkAAAA8SURBVHjarI4xEgAgCMNaQZT/f1hOYHE2S46FBgxEN0gbCGgL1/cC JAUtT/xlPv97r/fp1UPPvuw9AgwAKy8Ae8mbGEYAAAAASUVORK5CYII= ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: image/png Content-Transfer-Encoding: base64 Content-ID: <000a01c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline iVBORw0KGgoAAAANSUhEUgAAAAcAAAAXCAMAAADwWqV6AAAABGdBTUEAAK/INwWK6QAAABl0RVh0 U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAAeUExURbe3t////8nJye3t7dLS0ry8vPr6 +sXFxcDAwPv7+z8V/wkAAAA4SURBVHjarI65EQAgDMNMXrL/wuQubqBGjTpb2KarQSMxRsYYQkNp ox1/8Wdfr/+s6avuY+8RYAAqYQB796xAcQAAAABJRU5ErkJggg== ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: application/rss+xml Content-Transfer-Encoding: quoted-printable Content-ID: <000201c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline =0A= =0A= PostgreSQL News=0A= http://www.postgresql.org/=0A= PostgreSQL News=0A= webmaster@postgresql.org (PostgreSQL = webmasters)=0A= Thu, 12 Jun 2008 14:52:09 GMT=0A= =0A= PostgreSQL 8.3.3, 8.2.9 etc. Update Release=0A= http://www.postgresql.org/about/news.967=0A= http://www.postgresql.org/about/news.967=0A= Updates for all maintained versions of = PostgreSQL are available today: 8.3.3, 8.2.9, 8.1.13, 8.0.17 and 7.4.21. = These releases fix more than two dozen minor issues reported and = patched over the last few months.=0A= josh@postgresql.org=0A= Wed, 11 Jun 2008 00:00:00 GMT=0A= =0A= =0A= pgAdmin III v1.8.4 released=0A= http://www.postgresql.org/about/news.965=0A= http://www.postgresql.org/about/news.965=0A= The pgAdmin Development Team are pleased to = announce the release of <a = href=3D"http://www.pgadmin.org/">pgAdmin 1.8.4</a>, = the Open Source graphical PostgreSQL administration tool for Windows, = Linux, FreeBSD, Mac OS X and Solaris.=0A= dpage@pgadmin.org=0A= Thu, 05 Jun 2008 00:00:00 GMT=0A= =0A= =0A= pgEdit 1.4 released=0A= http://www.postgresql.org/about/news.964=0A= http://www.postgresql.org/about/news.964=0A= pgEdit 1.4 is now available for Macintosh and = Windows=0A= desoi@pgedit.com=0A= Tue, 03 Jun 2008 00:00:00 GMT=0A= =0A= =0A= Database .NET 2.1.3071 Released!=0A= http://www.postgresql.org/about/news.963=0A= http://www.postgresql.org/about/news.963=0A= Database .NET is an intuitive database = management tool for multi-database.=0A= fishcodelib@gmail.com=0A= Thu, 29 May 2008 00:00:00 GMT=0A= =0A= =0A= Navicat PostgreSQL GUI for Mac OS X ver. 7.1.1 is now = available!=0A= http://www.postgresql.org/about/news.962=0A= http://www.postgresql.org/about/news.962=0A= Easily manage and build PostgreSQL with Navicat = PostgreSQL GUI Manager (Free Lite version available).=20 Download Navicat at: <A = href=3D"http://pgsql.navicat.com/download.html">http://pgsql= .navicat.com/download.html</A>=0A= roynavicat@gmail.com=0A= Wed, 28 May 2008 00:00:00 GMT=0A= =0A= =0A= pgDesigner 1.2.7 Released=0A= http://www.postgresql.org/about/news.961=0A= http://www.postgresql.org/about/news.961=0A= pgDesigner is an open source program for the = graphical design of database for PostgreSQL. The code is written with the Gambas language, therefor works only under = the operating system Linux.=0A= md9327@mclink.it=0A= Mon, 26 May 2008 00:00:00 GMT=0A= =0A= =0A= ------=_NextPart_000_0001_01C8CFEF.2E43AE60 Content-Type: application/rss+xml Content-Transfer-Encoding: quoted-printable Content-ID: <000401c8cfa3$bc0a6b7c$_CDOSYS2.0> Content-Disposition: inline =0A= =0A= PostgreSQL latest versions=0A= http://www.postgresql.org/=0A= PostgreSQL latest versions=0A= webmaster@postgresql.org (PostgreSQL = webmasters)=0A= =0A= 8.3.3=0A= = http://www.postgresql.org/docs/8.3/static/release-8-3-3.html=0A= = http://www.postgresql.org/docs/8.3/static/release-8-3-3.html=0A= 8.3.3 is the latest release in the 8.3 = series=0A= webmaster@postgresql.org (PostgreSQL = webmasters)=0A= Thu, 12 Jun 2008 00:00:00 +0000=0A= =0A= =0A= 8.2.9=0A= = http://www.postgresql.org/docs/8.2/static/release-8-2-9.html=0A= = http://www.postgresql.org/docs/8.2/static/release-8-2-9.html=0A= 8.2.9 is the latest release in the 8.2 = series=0A= webmaster@postgresql.org (PostgreSQL = webmasters)=0A= Thu, 12 Jun 2008 00:00:00 +0000=0A= =0A= =0A= 8.1.13=0A= = http://www.postgresql.org/docs/8.1/static/release.html#RELEASE-8-1-= 13=0A= = http://www.postgresql.org/docs/8.1/static/release.html#RELEASE-8-1-= 13=0A= 8.1.13 is the latest release in the 8.1 = series=0A= webmaster@postgresql.org (PostgreSQL = webmasters)=0A= Thu, 12 Jun 2008 00:00:00 +0000=0A= =0A= =0A= 8.0.17=0A= = http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0-= 17=0A= = http://www.postgresql.org/docs/8.0/static/release.html#RELEASE-8-0-= 17=0A= 8.0.17 is the latest release in the 8.0 = series=0A= webmaster@postgresql.org (PostgreSQL = webmasters)=0A= Thu, 12 Jun 2008 00:00:00 +0000=0A= =0A= =0A= 7.4.21=0A= = http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4-= 21=0A= = http://www.postgresql.org/docs/7.4/static/release.html#RELEASE-7-4-= 21=0A= 7.4.21 is the latest release in the 7.4 = series=0A= webmaster@postgresql.org (PostgreSQL = webmasters)=0A= Thu, 12 Jun 2008 00:00:00 +0000=0A= =0A= =0A= ------=_NextPart_000_0001_01C8CFEF.2E43AE60--