Project

General

Profile

« Previous | Next » 

Revision 11663

web/links/index.htm: updated to Firefox bookmarks. added instructions for upgrading PostgreSQL to 9.3, and some GBIF links.

View differences:

index.htm
33 33
        <DT><A HREF="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegCore" name="__https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegCore" ADD_DATE="1354727779" ICON_URI="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715"><img width="16" height="16" src="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715" style="margin-right: 0.5em;"/>VegCore</A><a name="__VegCore" href="#__VegCore" style="margin-left: 0.5em;">&para;</a>
34 34
        <DT><A HREF="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegBIEN_schema" name="__https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/VegBIEN_schema" ADD_DATE="1344469303" ICON_URI="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715"><img width="16" height="16" src="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715" style="margin-right: 0.5em;"/>VegBIEN</A><a name="__VegBIEN" href="#__VegBIEN" style="margin-left: 0.5em;">&para;</a>
35 35
        <DT><A HREF="http://bien.nceas.ucsb.edu/bien/bien-database-summary-statistics/" name="__http://bien.nceas.ucsb.edu/bien/bien-database-summary-statistics/" ADD_DATE="1355788711"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>BIEN</A><a name="__BIEN" href="#__BIEN" style="margin-left: 0.5em;">&para;</a>
36
        <DT><A HREF="http://localhost/~aaronmk/phppgadmin/redirect.php?subject=schema&server=%3A5432%3Aallow&database=vegbien&schema=public&" name="__http://localhost/~aaronmk/phppgadmin/redirect.php?subject=schema&server=%3A5432%3Aallow&database=vegbien&schema=public&" ADD_DATE="1362008964" ICON_URI="http://localhost/~aaronmk/phppgadmin/images/themes/default/Introduction.png"><img width="16" height="16" src="http://localhost/~aaronmk/phppgadmin/images/themes/default/Introduction.png" style="margin-right: 0.5em;"/>local</A><a name="__local" href="#__local" style="margin-left: 0.5em;">&para;</a>
36
        <DT><A HREF="http://localhost/~aaronmk/phppgadmin/redirect.php?subject=schema&server=%3A5432%3Aallow&database=vegbien&schema=public&" name="__http://localhost/~aaronmk/phppgadmin/redirect.php?subject=schema&server=%3A5432%3Aallow&database=vegbien&schema=public&" ADD_DATE="1362008964" ICON_URI="http://localhost/~aaronmk/phppgadmin/images/themes/default/Favicon.ico"><img width="16" height="16" src="http://localhost/~aaronmk/phppgadmin/images/themes/default/Favicon.ico" style="margin-right: 0.5em;"/>local</A><a name="__local" href="#__local" style="margin-left: 0.5em;">&para;</a>
37 37
        <DT><A HREF="http://vegbiendev.nceas.ucsb.edu/phppgadmin/redirect.php?subject=schema&server=localhost%3A5432%3Aallow&database=vegbien&schema=public" name="__http://vegbiendev.nceas.ucsb.edu/phppgadmin/redirect.php?subject=schema&server=localhost%3A5432%3Aallow&database=vegbien&schema=public" ADD_DATE="1362008923" ICON_URI="http://vegbiendev.nceas.ucsb.edu/phppgadmin/images/themes/default/Introduction.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://vegbiendev.nceas.ucsb.edu/phppgadmin/images/themes/default/Introduction.png" style="margin-right: 0.5em;"/>vegbiendev</A><a name="__vegbiendev" href="#__vegbiendev" style="margin-left: 0.5em;">&para;</a>
38 38
        <DT><A HREF="http://vegbiendev.nceas.ucsb.edu/phpmyadmin/" name="__http://vegbiendev.nceas.ucsb.edu/phpmyadmin/" ADD_DATE="1361027615" ICON_URI="http://vegbiendev.nceas.ucsb.edu/phpmyadmin/favicon.ico"><img width="16" height="16" src="http://vegbiendev.nceas.ucsb.edu/phpmyadmin/favicon.ico" style="margin-right: 0.5em;"/>vegbiendev</A><a name="__vegbiendev" href="#__vegbiendev" style="margin-left: 0.5em;">&para;</a>
39 39
        <DT><A HREF="http://nimoy.nceas.ucsb.edu/phpmyadmin/" name="__http://nimoy.nceas.ucsb.edu/phpmyadmin/" ADD_DATE="1318544417" ICON_URI="http://nimoy.nceas.ucsb.edu/phpmyadmin/favicon.ico"><img width="16" height="16" src="http://nimoy.nceas.ucsb.edu/phpmyadmin/favicon.ico" style="margin-right: 0.5em;"/>nimoy</A><a name="__nimoy" href="#__nimoy" style="margin-left: 0.5em;">&para;</a>
......
99 99
&quot;Species occurrence data were obtained from four online databases:
100 100
VegBank http://vegbank.org/vegbank/index.jsp&quot;
101 101
                </DL><p>
102
                <DT><A HREF="http://www.gbif.org/newsroom/uses" name="http://www.gbif.org/newsroom/uses" ADD_DATE="1384383363" ICON_URI="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" style="margin-right: 0.5em;"/>GBIF Newsroom ‐ News and events from around the GBIF community: Uses of data</A><a name="GBIF Newsroom ‐ News and events from around the GBIF community: Uses of data" href="#GBIF Newsroom ‐ News and events from around the GBIF community: Uses of data" style="margin-left: 0.5em;">&para;</a>
103
<DD>page's description: 
102 104
            </DL><p>
103 105
            <DT><A HREF="https://projects.nceas.ucsb.edu/nceas/projects/biengeo/repository/revisions/master/entry/load-geoscrub-input.sh" name="https://projects.nceas.ucsb.edu/nceas/projects/biengeo/repository/revisions/master/entry/load-geoscrub-input.sh" ADD_DATE="1367527203" ICON_URI="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1347421715" style="margin-right: 0.5em;"/>/load-geoscrub-input.sh - BIEN Geo - NCEAS Projects</A><a name="/load-geoscrub-input.sh - BIEN Geo - NCEAS Projects" href="#/load-geoscrub-input.sh - BIEN Geo - NCEAS Projects" style="margin-left: 0.5em;">&para;</a>
104 106
<DD>page's description: Redmine
......
162 164
            <DL><p>
163 165
                <DT><A HREF="http://www.digir.net/" name="http://www.digir.net/" ADD_DATE="1332897239" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>DiGIR - Table of Contents</A><a name="DiGIR - Table of Contents" href="#DiGIR - Table of Contents" style="margin-left: 0.5em;">&para;</a>
164 166
                <DT><A HREF="http://www.bsc-eoc.org/digir/www/DiGIR_clientJS.php?domain=http%3A%2F%2Fdigir.sourceforge.net%2Ffed%2Fbeta3%2Fdarwindomain.xml" name="http://www.bsc-eoc.org/digir/www/DiGIR_clientJS.php?domain=http%3A%2F%2Fdigir.sourceforge.net%2Ffed%2Fbeta3%2Fdarwindomain.xml" ADD_DATE="1332912782" ICON_URI="http://www.bsc-eoc.org/favicon.ico" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="http://www.bsc-eoc.org/favicon.ico" style="margin-right: 0.5em;"/>DiGIR web-browser client helper scripts.</A><a name="DiGIR web-browser client helper scripts." href="#DiGIR web-browser client helper scripts." style="margin-left: 0.5em;">&para;</a>
165
                <DT><A HREF="http://www.cria.org.br/protocols/newprotocol.pdf" name="http://www.cria.org.br/protocols/newprotocol.pdf" ADD_DATE="1332992555"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>GBIF Data Access and Database Interoperability</A><a name="GBIF Data Access and Database Interoperability" href="#GBIF Data Access and Database Interoperability" style="margin-left: 0.5em;">&para;</a>
167
                <DT><A HREF="http://www.cria.org.br/protocols/newprotocol.pdf" name="http://www.cria.org.br/protocols/newprotocol.pdf" ADD_DATE="1332992555" ICON_URI="http://www.cria.org.br/favicon.ico"><img width="16" height="16" src="http://www.cria.org.br/favicon.ico" style="margin-right: 0.5em;"/>GBIF Data Access and Database Interoperability</A><a name="GBIF Data Access and Database Interoperability" href="#GBIF Data Access and Database Interoperability" style="margin-left: 0.5em;">&para;</a>
166 168
                <DT><A HREF="http://splink.cria.org.br/digir/" name="http://splink.cria.org.br/digir/" ADD_DATE="1332911379" ICON_URI="http://splink.cria.org.br/favicon.ico" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="http://splink.cria.org.br/favicon.ico" style="margin-right: 0.5em;"/>http://splink.cria.org.br/digir/</A><a name="http://splink.cria.org.br/digir/" href="#http://splink.cria.org.br/digir/" style="margin-left: 0.5em;">&para;</a>
167 169
                <DT><A HREF="http://www.digir.net/prot/release/searchRequestDiGIR1.5.xml" name="http://www.digir.net/prot/release/searchRequestDiGIR1.5.xml" ADD_DATE="1332913185" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>http://www.digir.net/prot/release/searchRequestDiGIR1.5.xml</A><a name="http://www.digir.net/prot/release/searchRequestDiGIR1.5.xml" href="#http://www.digir.net/prot/release/searchRequestDiGIR1.5.xml" style="margin-left: 0.5em;">&para;</a>
168 170
                <DT><A HREF="http://code.google.com/p/gbif-occurrencestore/source/browse/trunk/occurrence-crawler/src/main/resources/template/digir/search.vm?spec=svn871&r=871" name="http://code.google.com/p/gbif-occurrencestore/source/browse/trunk/occurrence-crawler/src/main/resources/template/digir/search.vm?spec=svn871&r=871" ADD_DATE="1332913175" ICON_URI="http://www.gstatic.com/codesite/ph/images/phosting.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.gstatic.com/codesite/ph/images/phosting.ico" style="margin-right: 0.5em;"/>search.vm - gbif-occurrencestore - Research into a scalable and feature-rich occurrence store and index - Google Project Hosting</A><a name="search.vm - gbif-occurrencestore - Research into a scalable and feature-rich occurrence store and index - Google Project Hosting" href="#search.vm - gbif-occurrencestore - Research into a scalable and feature-rich occurrence store and index - Google Project Hosting" style="margin-left: 0.5em;">&para;</a>
......
175 177
            </DL><p>
176 178
            <DT><a name="GBIF" href="#GBIF"><H3 ADD_DATE="1384332216">GBIF</H3></a>
177 179
            <DL><p>
178
                <DT><A HREF="http://www.gbif.org/resources/2605#" name="http://www.gbif.org/resources/2605#" ADD_DATE="1384332087" ICON_URI="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" style="margin-right: 0.5em;"/>Resources ‐ Tools and information to support the GBIF community: GBIF Memorandum of Understanding 2012</A><a name="Resources ‐ Tools and information to support the GBIF community: GBIF Memorandum of Understanding 2012" href="#Resources ‐ Tools and information to support the GBIF community: GBIF Memorandum of Understanding 2012" style="margin-left: 0.5em;">&para;</a>
179
<DD>&quot;non-binding Memorandum of Understanding (MoU)&quot;
180
                <DT><A HREF="http://www.gbif.org/disclaimer/datasharing" name="http://www.gbif.org/disclaimer/datasharing" ADD_DATE="1384397131" ICON_URI="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" style="margin-right: 0.5em;"/>Disclaimers and agreements ‐ Terms relating to information and data accessed, used and shared through GBIF: Data sharing</A><a name="Disclaimers and agreements ‐ Terms relating to information and data accessed, used and shared through GBIF: Data sharing" href="#Disclaimers and agreements ‐ Terms relating to information and data accessed, used and shared through GBIF: Data sharing" style="margin-left: 0.5em;">&para;</a>
181
<DD>&quot;Responsibility regarding the restriction of access to sensitive data resides with the Data Publisher.&quot;
182

  
183
&quot;The Data Publisher warrants that it has made the necessary agreements with the original owners of the data that it can make the data available through the GBIF network.&quot;
180 184
                <DT><A HREF="http://www.gbif.org/disclaimer/datause" name="http://www.gbif.org/disclaimer/datause" ADD_DATE="1384332153" ICON_URI="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" style="margin-right: 0.5em;"/>Disclaimers and agreements ‐ Terms relating to information and data accessed, used and shared through GBIF: Data use agreement</A><a name="Disclaimers and agreements ‐ Terms relating to information and data accessed, used and shared through GBIF: Data use agreement" href="#Disclaimers and agreements ‐ Terms relating to information and data accessed, used and shared through GBIF: Data use agreement" style="margin-left: 0.5em;">&para;</a>
185
                <DT><A HREF="http://www.gbif.org/page/2990" name="http://www.gbif.org/page/2990" ADD_DATE="1384383128" ICON_URI="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" style="margin-right: 0.5em;"/>GBIF Newsroom ‐ News and events from around the GBIF community</A><a name="GBIF Newsroom ‐ News and events from around the GBIF community" href="#GBIF Newsroom ‐ News and events from around the GBIF community" style="margin-left: 0.5em;">&para;</a>
181 186
<DD>page's description: 
187
                <DT><A HREF="http://www.gbif.org/newsroom/uses" name="http://www.gbif.org/newsroom/uses" ADD_DATE="1384383363" ICON_URI="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" style="margin-right: 0.5em;"/>GBIF Newsroom ‐ News and events from around the GBIF community: Uses of data</A><a name="GBIF Newsroom ‐ News and events from around the GBIF community: Uses of data" href="#GBIF Newsroom ‐ News and events from around the GBIF community: Uses of data" style="margin-left: 0.5em;">&para;</a>
188
<DD>page's description: 
189
                <DT><A HREF="ftp://ftp.gbif.org/" name="ftp://ftp.gbif.org/" ADD_DATE="1360879586" ICON_URI="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8%2F9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAeBJREFUeNqcU81O20AQ%2FtZ2AgQSYQRqL1UPVG2hAUQkxLEStz4DrXpLpD5Drz31Cajax%2Bghhx6qHIJURBTxIwQRwopCBbZjHMcOTrzermPipsSt1Iw03p3ZmW%2B%2B2R0TxhgOD34wjCHZlQ0iDYz9yvEfhxMTCYhEQDIZhkxKd2sqzX2TOD2vBQCQhpPefng1ZP2dVPlLLdpL8SEMcxng%2Fbs0RIHhtgs4twxOh%2BHjZxvzDx%2F3GQQiDFISiRBLFMPKTRMollzcWECrDVhtxtdRVsL9youPxGj%2FbdfFlUZhtDyYbYqWRUdai1oQRZ5oHeHl2gNM%2B01Uqio8RlH%2BnsazJzNwXcq1B%2BiXPHprlEEymeBfXs1w8XxxihfyuXqoHqpoGjZM04bddgG%2F9%2B8WGj87qDdsrK9m%2BoA%2BpbhQTDh2l1%2Bi2weNbSHMZyjvNXmVbqh9Fj5Oz27uEoP%2BSTxANruJs9L%2FT6P0ewqPx5nmiAG5f6AoCtN1PbJzuRyJAyDBzzSQYvErf06yYxhGXlEa8H2KVGoasjwLx3Ewk858opQWXm%2B%2Fib9EQrBzclLLLy89xYvlpchvtixcX6uo1y%2FzsiwHrkIsgKbp%2BYWFOWicuqppoNTnStHzPFCPQhBEBOyGAX4JMADFetubi4BSYAAAAABJRU5ErkJggg%3D%3D" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8%2F9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAeBJREFUeNqcU81O20AQ%2FtZ2AgQSYQRqL1UPVG2hAUQkxLEStz4DrXpLpD5Drz31Cajax%2Bghhx6qHIJURBTxIwQRwopCBbZjHMcOTrzermPipsSt1Iw03p3ZmW%2B%2B2R0TxhgOD34wjCHZlQ0iDYz9yvEfhxMTCYhEQDIZhkxKd2sqzX2TOD2vBQCQhpPefng1ZP2dVPlLLdpL8SEMcxng%2Fbs0RIHhtgs4twxOh%2BHjZxvzDx%2F3GQQiDFISiRBLFMPKTRMollzcWECrDVhtxtdRVsL9youPxGj%2FbdfFlUZhtDyYbYqWRUdai1oQRZ5oHeHl2gNM%2B01Uqio8RlH%2BnsazJzNwXcq1B%2BiXPHprlEEymeBfXs1w8XxxihfyuXqoHqpoGjZM04bddgG%2F9%2B8WGj87qDdsrK9m%2BoA%2BpbhQTDh2l1%2Bi2weNbSHMZyjvNXmVbqh9Fj5Oz27uEoP%2BSTxANruJs9L%2FT6P0ewqPx5nmiAG5f6AoCtN1PbJzuRyJAyDBzzSQYvErf06yYxhGXlEa8H2KVGoasjwLx3Ewk858opQWXm%2B%2Fib9EQrBzclLLLy89xYvlpchvtixcX6uo1y%2FzsiwHrkIsgKbp%2BYWFOWicuqppoNTnStHzPFCPQhBEBOyGAX4JMADFetubi4BSYAAAAABJRU5ErkJggg%3D%3D" style="margin-right: 0.5em;"/>Index of ftp://ftp.gbif.org/</A><a name="Index of ftp://ftp.gbif.org/" href="#Index of ftp://ftp.gbif.org/" style="margin-left: 0.5em;">&para;</a>
190
                <DT><A HREF="http://imsgbif.gbif.org/CMS_ORC/?doc_id=2955&download=1" name="http://imsgbif.gbif.org/CMS_ORC/?doc_id=2955&download=1" ADD_DATE="1384334586"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Memorandum of Understanding for the Global Biodiversity Information Facility</A><a name="Memorandum of Understanding for the Global Biodiversity Information Facility" href="#Memorandum of Understanding for the Global Biodiversity Information Facility" style="margin-left: 0.5em;">&para;</a>
191
<DD>&quot;This document is not legally binding and has no effect as a legal or political precedent.&quot;
182 192
                <DT><A HREF="http://data.gbif.org/species/6" name="http://data.gbif.org/species/6" ADD_DATE="1369416680" ICON_URI="http://data.gbif.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://data.gbif.org/favicon.ico" style="margin-right: 0.5em;"/>Plantae (Plants) - GBIF Portal</A><a name="Plantae (Plants) - GBIF Portal" href="#Plantae (Plants) - GBIF Portal" style="margin-left: 0.5em;">&para;</a>
183 193
<DD>page's description: Observational and specimen data for Plantae
184 194

  
185 195
&quot;79,725,738 records with coordinates&quot;
186
                <DT><A HREF="ftp://ftp.gbif.org/" name="ftp://ftp.gbif.org/" ADD_DATE="1360879586" ICON_URI="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8%2F9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAeBJREFUeNqcU81O20AQ%2FtZ2AgQSYQRqL1UPVG2hAUQkxLEStz4DrXpLpD5Drz31Cajax%2Bghhx6qHIJURBTxIwQRwopCBbZjHMcOTrzermPipsSt1Iw03p3ZmW%2B%2B2R0TxhgOD34wjCHZlQ0iDYz9yvEfhxMTCYhEQDIZhkxKd2sqzX2TOD2vBQCQhpPefng1ZP2dVPlLLdpL8SEMcxng%2Fbs0RIHhtgs4twxOh%2BHjZxvzDx%2F3GQQiDFISiRBLFMPKTRMollzcWECrDVhtxtdRVsL9youPxGj%2FbdfFlUZhtDyYbYqWRUdai1oQRZ5oHeHl2gNM%2B01Uqio8RlH%2BnsazJzNwXcq1B%2BiXPHprlEEymeBfXs1w8XxxihfyuXqoHqpoGjZM04bddgG%2F9%2B8WGj87qDdsrK9m%2BoA%2BpbhQTDh2l1%2Bi2weNbSHMZyjvNXmVbqh9Fj5Oz27uEoP%2BSTxANruJs9L%2FT6P0ewqPx5nmiAG5f6AoCtN1PbJzuRyJAyDBzzSQYvErf06yYxhGXlEa8H2KVGoasjwLx3Ewk858opQWXm%2B%2Fib9EQrBzclLLLy89xYvlpchvtixcX6uo1y%2FzsiwHrkIsgKbp%2BYWFOWicuqppoNTnStHzPFCPQhBEBOyGAX4JMADFetubi4BSYAAAAABJRU5ErkJggg%3D%3D" LAST_CHARSET="ISO-8859-1"><img width="16" height="16" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8%2F9hAAAAGXRFWHRTb2Z0d2FyZQBBZG9iZSBJbWFnZVJlYWR5ccllPAAAAeBJREFUeNqcU81O20AQ%2FtZ2AgQSYQRqL1UPVG2hAUQkxLEStz4DrXpLpD5Drz31Cajax%2Bghhx6qHIJURBTxIwQRwopCBbZjHMcOTrzermPipsSt1Iw03p3ZmW%2B%2B2R0TxhgOD34wjCHZlQ0iDYz9yvEfhxMTCYhEQDIZhkxKd2sqzX2TOD2vBQCQhpPefng1ZP2dVPlLLdpL8SEMcxng%2Fbs0RIHhtgs4twxOh%2BHjZxvzDx%2F3GQQiDFISiRBLFMPKTRMollzcWECrDVhtxtdRVsL9youPxGj%2FbdfFlUZhtDyYbYqWRUdai1oQRZ5oHeHl2gNM%2B01Uqio8RlH%2BnsazJzNwXcq1B%2BiXPHprlEEymeBfXs1w8XxxihfyuXqoHqpoGjZM04bddgG%2F9%2B8WGj87qDdsrK9m%2BoA%2BpbhQTDh2l1%2Bi2weNbSHMZyjvNXmVbqh9Fj5Oz27uEoP%2BSTxANruJs9L%2FT6P0ewqPx5nmiAG5f6AoCtN1PbJzuRyJAyDBzzSQYvErf06yYxhGXlEa8H2KVGoasjwLx3Ewk858opQWXm%2B%2Fib9EQrBzclLLLy89xYvlpchvtixcX6uo1y%2FzsiwHrkIsgKbp%2BYWFOWicuqppoNTnStHzPFCPQhBEBOyGAX4JMADFetubi4BSYAAAAABJRU5ErkJggg%3D%3D" style="margin-right: 0.5em;"/>Index of ftp://ftp.gbif.org/</A><a name="Index of ftp://ftp.gbif.org/" href="#Index of ftp://ftp.gbif.org/" style="margin-left: 0.5em;">&para;</a>
196
                <DT><A HREF="http://www.gbif.org/resources/2605#" name="http://www.gbif.org/resources/2605#" ADD_DATE="1384332087" ICON_URI="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.gbif.org/img/favicon/favicon_32x32.ico" style="margin-right: 0.5em;"/>Resources ‐ Tools and information to support the GBIF community: GBIF Memorandum of Understanding 2012</A><a name="Resources ‐ Tools and information to support the GBIF community: GBIF Memorandum of Understanding 2012" href="#Resources ‐ Tools and information to support the GBIF community: GBIF Memorandum of Understanding 2012" style="margin-left: 0.5em;">&para;</a>
197
<DD>&quot;non-binding Memorandum of Understanding (MoU)&quot;
187 198
            </DL><p>
188 199
            <DT><a name="growth forms" href="#growth forms"><H3 ADD_DATE="1367820473">growth forms</H3></a>
189 200
            <DL><p>
......
522 533
includes set_config(), current_setting()
523 534
                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/functions-info.html" name="http://www.postgresql.org/docs/9.1/static/functions-info.html" ADD_DATE="1370976312" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: System Information Functions</A><a name="PostgreSQL: Documentation: 9.1: System Information Functions" href="#PostgreSQL: Documentation: 9.1: System Information Functions" style="margin-left: 0.5em;">&para;</a>
524 535
<DD>&quot;current_schemas(boolean) returns an array of the names of all schemas presently in the search path. The Boolean option determines whether or not implicitly included system schemas such as pg_catalog are included in the returned search path.&quot;
536
                                <DT><A HREF="http://www.postgresql.org/docs/9.1/static/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE" name="http://www.postgresql.org/docs/9.1/static/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE" ADD_DATE="1384405185" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.1: System Information Functions: has_table_privilege()</A><a name="PostgreSQL: Documentation: 9.1: System Information Functions: has_table_privilege()" href="#PostgreSQL: Documentation: 9.1: System Information Functions: has_table_privilege()" style="margin-left: 0.5em;">&para;</a>
537
<DD>&quot;`SELECT has_table_privilege(&#39;joe&#39;, &#39;mytable&#39;, &#39;INSERT, SELECT WITH GRANT OPTION&#39;);`&quot;
538
                                <DT><A HREF="http://www.postgresql.org/docs/9.2/static/plpgsql-control-structures.html#PLPGSQL-EXCEPTION-DIAGNOSTICS" name="http://www.postgresql.org/docs/9.2/static/plpgsql-control-structures.html#PLPGSQL-EXCEPTION-DIAGNOSTICS" ADD_DATE="1384428283" ICON_URI="http://www.postgresql.org/favicon.ico"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.2: Control Structures: 39.6.6.1. Obtaining information about an error</A><a name="PostgreSQL: Documentation: 9.2: Control Structures: 39.6.6.1. Obtaining information about an error" href="#PostgreSQL: Documentation: 9.2: Control Structures: 39.6.6.1. Obtaining information about an error" style="margin-left: 0.5em;">&para;</a>
539
<DD>&quot;PG_EXCEPTION_DETAIL 	text 	the text of the exception&#39;s detail message, if any&quot;
540

  
541
&quot;
542
  GET STACKED DIAGNOSTICS text_var1 = MESSAGE_TEXT,
543
                          text_var2 = PG_EXCEPTION_DETAIL,
544
                          text_var3 = PG_EXCEPTION_HINT;
545
&quot;
546
                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/pgupgrade.html" name="http://www.postgresql.org/docs/9.3/static/pgupgrade.html" ADD_DATE="1384429194" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.3: pg_upgrade</A><a name="PostgreSQL: Documentation: 9.3: pg_upgrade" href="#PostgreSQL: Documentation: 9.3: pg_upgrade" style="margin-left: 0.5em;">&para;</a>
547
<DD>page's description: 
525 548
                                <DT><A HREF="http://www.postgresql.org/docs/8.4/static/logfile-maintenance.html" name="http://www.postgresql.org/docs/8.4/static/logfile-maintenance.html" ADD_DATE="1333386461" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: Manuals: Log File Maintenance</A><a name="PostgreSQL: Documentation: Manuals: Log File Maintenance" href="#PostgreSQL: Documentation: Manuals: Log File Maintenance" style="margin-left: 0.5em;">&para;</a>
526 549
                                <DT><A HREF="http://www.postgresql.org/docs/9.1/interactive/index.html" name="http://www.postgresql.org/docs/9.1/interactive/index.html" ADD_DATE="1317673868" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: Manuals: PostgreSQL 9.1: PostgreSQL 9.1.1 Documentation</A><a name="PostgreSQL: Documentation: Manuals: PostgreSQL 9.1: PostgreSQL 9.1.1 Documentation" href="#PostgreSQL: Documentation: Manuals: PostgreSQL 9.1: PostgreSQL 9.1.1 Documentation" style="margin-left: 0.5em;">&para;</a>
527 550
                                <DT><A HREF="http://www.postgresql.org/docs/8.3/static/app-psql.html" name="http://www.postgresql.org/docs/8.3/static/app-psql.html" ADD_DATE="1325722373" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: Manuals: psql</A><a name="PostgreSQL: Documentation: Manuals: psql" href="#PostgreSQL: Documentation: Manuals: psql" style="margin-left: 0.5em;">&para;</a>
......
556 579
                                <DT><A HREF="http://grokbase.com/t/postgresql/pgsql-performance/0559m8364s/hash-index-vs-b-tree-index-postgresql-8-0" name="http://grokbase.com/t/postgresql/pgsql-performance/0559m8364s/hash-index-vs-b-tree-index-postgresql-8-0" ADD_DATE="1383136591" ICON_URI="http://grokbase.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://grokbase.com/favicon.ico" style="margin-right: 0.5em;"/>&quot;Hash index&quot; vs. &quot;b-tree index&quot; (PostgreSQL 8.0) - Grokbase</A><a name="&quot;Hash index&quot; vs. &quot;b-tree index&quot; (PostgreSQL 8.0) - Grokbase" href="#&quot;Hash index&quot; vs. &quot;b-tree index&quot; (PostgreSQL 8.0) - Grokbase" style="margin-left: 0.5em;">&para;</a>
557 580
<DD>page's description: (33 replies) Greetings, We are working on speeding up the queries by creating indexes. We have queries with searching criteria such as &quot;select ... where *col1=&#39;...&#39;*&quot;. This is a simple query with only &quot;=&quot; operation. As a result I setup hash index on column &quot;col1&quot;. While, in postgreSQL 8 doc, it is wirttern: *Note: * Testing has shown PostgreSQL&#39;s hash indexes to perform no better than B-tree indexes, and the index size and build time for hash indexes is much worse. For these reasons, hash index use is
558 581
                            </DL><p>
582
                            <DT><a name="installing 9.3" href="#installing 9.3"><H3 ADD_DATE="1384429280">installing 9.3</H3></a>
583
                            <DL><p>
584
                                <DT><A HREF="http://www.postgresql.org/message-id/20130508192711.GA9243@msgid.df7cb.de" name="http://www.postgresql.org/message-id/20130508192711.GA9243@msgid.df7cb.de" ADD_DATE="1384429717" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>Re: Problems with apt.postgresql.org and precise</A><a name="Re: Problems with apt.postgresql.org and precise" href="#Re: Problems with apt.postgresql.org and precise" style="margin-left: 0.5em;">&para;</a>
585
<DD>page's description: 
586
                                <DT><A HREF="https://wiki.postgresql.org/wiki/Apt" name="https://wiki.postgresql.org/wiki/Apt" ADD_DATE="1384429170" ICON_URI="https://wiki.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://wiki.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>Apt - PostgreSQL wiki</A><a name="Apt - PostgreSQL wiki" href="#Apt - PostgreSQL wiki" style="margin-left: 0.5em;">&para;</a>
587
<DD>page's description: 
588
                                <DT><a name="upgrading DB to 9.3" href="#upgrading DB to 9.3"><H3 ADD_DATE="1384438805">upgrading DB to 9.3</H3></a>
589
                                <DL><p>
590
                                    <DT><A HREF="http://www.postgresql.org/message-id/514F545C.7020302@gmail.com" name="http://www.postgresql.org/message-id/514F545C.7020302@gmail.com" ADD_DATE="1384438709" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>Re: Problem with data migration from 9.1 to 9.2</A><a name="Re: Problem with data migration from 9.1 to 9.2" href="#Re: Problem with data migration from 9.1 to 9.2" style="margin-left: 0.5em;">&para;</a>
591
<DD>-
592

  
593
on Mac:
594
$ sudo chmod go+w /Library/PostgreSQL/9.3/
595
$ sudo -u postgres initdb -U postgres -D /Library/PostgreSQL/9.3/data/ -E UTF8 --lc-collate=en_US.UTF-8
596
$ sudo chmod go-w /Library/PostgreSQL/9.3/
597
                                    <DT><A HREF="http://www.postgresql.org/docs/9.3/static/pgupgrade.html" name="http://www.postgresql.org/docs/9.3/static/pgupgrade.html" ADD_DATE="1384429194" ICON_URI="http://www.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://www.postgresql.org/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL: Documentation: 9.3: pg_upgrade</A><a name="PostgreSQL: Documentation: 9.3: pg_upgrade" href="#PostgreSQL: Documentation: 9.3: pg_upgrade" style="margin-left: 0.5em;">&para;</a>
598
<DD>-
599

  
600
on Mac:
601
$ sudo -u postgres -s
602
$ mkdir /tmp/postgres_install
603
$ cd /tmp/postgres_install
604
$ pg_upgrade --user=postgres -b /Library/PostgreSQL/9.1/bin/ -B /Library/PostgreSQL/9.3/bin/ -d /Library/PostgreSQL/9.1/data/ -D /Library/PostgreSQL/9.3/data/ # runtime: 15 min (&quot;06:28:35&quot; - &quot;06:14:41&quot;) for a 30 GB cluster
605
$ ./analyze_new_cluster.sh
606
# try connecting to the DB
607
$ ./delete_old_cluster.sh
608
                                </DL><p>
609
                            </DL><p>
559 610
                            <DT><a name="invalid byte sequence errors" href="#invalid byte sequence errors"><H3 ADD_DATE="1366909936">invalid byte sequence errors</H3></a>
560 611
                            <DL><p>
561 612
                                <DT><A HREF="http://dba.stackexchange.com/questions/4777/how-to-solve-utf8-invalid-byte-sequence-copy-errors-on-a-restore-when-the-sourc" name="http://dba.stackexchange.com/questions/4777/how-to-solve-utf8-invalid-byte-sequence-copy-errors-on-a-restore-when-the-sourc" ADD_DATE="1366909823" ICON_URI="http://cdn.sstatic.net/dba/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/dba/img/favicon.ico" style="margin-right: 0.5em;"/>postgresql - How to solve UTF8 invalid byte sequence copy errors on a restore, when the source database is encoded in UTF8? - Database Administrators Stack Exchange</A><a name="postgresql - How to solve UTF8 invalid byte sequence copy errors on a restore, when the source database is encoded in UTF8? - Database Administrators Stack Exchange" href="#postgresql - How to solve UTF8 invalid byte sequence copy errors on a restore, when the source database is encoded in UTF8? - Database Administrators Stack Exchange" style="margin-left: 0.5em;">&para;</a>
......
589 640
                                <DT><A HREF="http://gis.stackexchange.com/questions/24356/struggling-with-enabling-a-postgis-database-on-mac" name="http://gis.stackexchange.com/questions/24356/struggling-with-enabling-a-postgis-database-on-mac" ADD_DATE="1347912089" ICON_URI="http://cdn.sstatic.net/gis/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/gis/img/favicon.ico" style="margin-right: 0.5em;"/>postgresql - Struggling with enabling a PostGIS database on Mac - GIS</A><a name="postgresql - Struggling with enabling a PostGIS database on Mac - GIS" href="#postgresql - Struggling with enabling a PostGIS database on Mac - GIS" style="margin-left: 0.5em;">&para;</a>
590 641
                                <DT><A HREF="https://gist.github.com/1481128" name="https://gist.github.com/1481128" ADD_DATE="1347912337" ICON_URI="https://github.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://github.com/favicon.ico" style="margin-right: 0.5em;"/>Install Postgres 9.1, PostGIS and create PostGIS template on Ubuntu 11.10 Oneiric Ocelot — Gist</A><a name="Install Postgres 9.1, PostGIS and create PostGIS template on Ubuntu 11.10 Oneiric Ocelot — Gist" href="#Install Postgres 9.1, PostGIS and create PostGIS template on Ubuntu 11.10 Oneiric Ocelot — Gist" style="margin-left: 0.5em;">&para;</a>
591 642
                            </DL><p>
643
                            <DT><a name="SHOW GRANTS FOR" href="#SHOW GRANTS FOR"><H3 ADD_DATE="1384404369">SHOW GRANTS FOR</H3></a>
644
                            <DL><p>
645
                                <DT><A HREF="http://postgresql.1045698.n5.nabble.com/quot-SHOW-GRANTS-FOR-username-quot-or-why-z-is-not-enough-for-me-td5714952.html" name="http://postgresql.1045698.n5.nabble.com/quot-SHOW-GRANTS-FOR-username-quot-or-why-z-is-not-enough-for-me-td5714952.html" ADD_DATE="1384404388" ICON_URI="http://postgresql.1045698.n5.nabble.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://postgresql.1045698.n5.nabble.com/favicon.ico" style="margin-right: 0.5em;"/>PostgreSQL - novice - &quot;SHOW GRANTS FOR username&quot; or why \z is not enough for me</A><a name="PostgreSQL - novice - &quot;SHOW GRANTS FOR username&quot; or why \z is not enough for me" href="#PostgreSQL - novice - &quot;SHOW GRANTS FOR username&quot; or why \z is not enough for me" style="margin-left: 0.5em;">&para;</a>
646
<DD>page's description: :&quot;SHOW GRANTS FOR username&quot; or why \z is not enough for me. Hello As a newbie Postgres admin I like to double check that my users have all necessary rights and more important only those and...
647

  
648
&quot;
649
&gt;I somehow think that there must be a more elegant solution
650
&gt; like &quot;SHOW GRANTS FOR foo&quot; in MySQL. Any ideas?
651

  
652
has_table_privilege() and sibling functions might help you with that
653
&quot;
654
                            </DL><p>
592 655
                            <DT><a name="table modified time" href="#table modified time"><H3 ADD_DATE="1369925071">table modified time</H3></a>
593 656
                            <DL><p>
594 657
                                <DT><A HREF="http://stackoverflow.com/questions/3211769/how-to-get-last-access-modification-date-of-a-postgresql-database" name="http://stackoverflow.com/questions/3211769/how-to-get-last-access-modification-date-of-a-postgresql-database" ADD_DATE="1369925095" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>How to get last access/modification date of a PostgreSQL database? - Stack Overflow</A><a name="How to get last access/modification date of a PostgreSQL database? - Stack Overflow" href="#How to get last access/modification date of a PostgreSQL database? - Stack Overflow" style="margin-left: 0.5em;">&para;</a>
......
834 897
                            </DL><p>
835 898
                            <DT><a name="MySQL Workbench" href="#MySQL Workbench"><H3 ADD_DATE="1366740023">MySQL Workbench</H3></a>
836 899
                            <DL><p>
837
                                <DT><a name="exporting indexes separately" href="#exporting indexes separately"><H3 ADD_DATE="1367759236">exporting indexes separately</H3></a>
838
<DD>this happens in /mysql-workbench-gpl-5.2.47-src/modules/db.mysql/src/module_db_mysql.cpp . it does *not* use mysqldump, unfortunately.
839
</DD>
840
                                <DL><p>
841
                                </DL><p>
842 900
                                <DT><A HREF="http://dev.mysql.com/downloads/tools/workbench/5.2.html#downloads" name="http://dev.mysql.com/downloads/tools/workbench/5.2.html#downloads" ADD_DATE="1366739722" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>MySQL :: Download MySQL Workbench</A><a name="MySQL :: Download MySQL Workbench" href="#MySQL :: Download MySQL Workbench" style="margin-left: 0.5em;">&para;</a>
843 901
                                <DT><A HREF="http://bugs.mysql.com/bug.php?id=40167" name="http://bugs.mysql.com/bug.php?id=40167" ADD_DATE="1365122620" ICON_URI="http://bugs.mysql.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bugs.mysql.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL Bugs: #40167: no method to show hidden relationships again</A><a name="MySQL Bugs: #40167: no method to show hidden relationships again" href="#MySQL Bugs: #40167: no method to show hidden relationships again" style="margin-left: 0.5em;">&para;</a>
844 902
                                <DT><A HREF="http://bugs.mysql.com/bug.php?id=46626" name="http://bugs.mysql.com/bug.php?id=46626" ADD_DATE="1365497065" ICON_URI="http://bugs.mysql.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bugs.mysql.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL Bugs: #46626: Unable to copy-paste selected tables between two instances of Workbench</A><a name="MySQL Bugs: #46626: Unable to copy-paste selected tables between two instances of Workbench" href="#MySQL Bugs: #46626: Unable to copy-paste selected tables between two instances of Workbench" style="margin-left: 0.5em;">&para;</a>
845 903
                                <DT><A HREF="http://bugs.mysql.com/bug.php?id=67322" name="http://bugs.mysql.com/bug.php?id=67322" ADD_DATE="1366740010" ICON_URI="http://bugs.mysql.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bugs.mysql.com/favicon.ico" style="margin-right: 0.5em;"/>MySQL Bugs: #67322: MySQL Workbench not installing Ubuntu 12.10</A><a name="MySQL Bugs: #67322: MySQL Workbench not installing Ubuntu 12.10" href="#MySQL Bugs: #67322: MySQL Workbench not installing Ubuntu 12.10" style="margin-left: 0.5em;">&para;</a>
846 904
                                <DT><A HREF="http://dba.stackexchange.com/questions/4314/mysql-workbench-loses-saved-connections" name="http://dba.stackexchange.com/questions/4314/mysql-workbench-loses-saved-connections" ADD_DATE="1366743179" ICON_URI="http://cdn.sstatic.net/dba/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/dba/img/favicon.ico" style="margin-right: 0.5em;"/>MySQL Workbench Loses Saved Connections - Database Administrators Stack Exchange</A><a name="MySQL Workbench Loses Saved Connections - Database Administrators Stack Exchange" href="#MySQL Workbench Loses Saved Connections - Database Administrators Stack Exchange" style="margin-left: 0.5em;">&para;</a>
847 905
                                <DT><A HREF="http://stackoverflow.com/questions/12623651/error-error-1005-cant-create-table-errno-121" name="http://stackoverflow.com/questions/12623651/error-error-1005-cant-create-table-errno-121" ADD_DATE="1366747441" ICON_URI="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://cdn.sstatic.net/stackoverflow/img/favicon.ico" style="margin-right: 0.5em;"/>mysql - ERROR: Error 1005: Can&#39;t create table (errno: 121) - Stack Overflow</A><a name="mysql - ERROR: Error 1005: Can&#39;t create table (errno: 121) - Stack Overflow" href="#mysql - ERROR: Error 1005: Can&#39;t create table (errno: 121) - Stack Overflow" style="margin-left: 0.5em;">&para;</a>
906
                                <DT><a name="exporting indexes separately" href="#exporting indexes separately"><H3 ADD_DATE="1367759236">exporting indexes separately</H3></a>
907
<DD>this happens in /mysql-workbench-gpl-5.2.47-src/modules/db.mysql/src/module_db_mysql.cpp . it does *not* use mysqldump, unfortunately.
908
</DD>
909
                                <DL><p>
910
                                </DL><p>
848 911
                            </DL><p>
849 912
                            <DT><a name="resetting ibdata" href="#resetting ibdata"><H3 ADD_DATE="1369878988">resetting ibdata</H3></a>
850 913
<DD>you need to do this after manually renaming a database with InnoDB tables
......
1227 1290
                            <DL><p>
1228 1291
                            </DL><p>
1229 1292
                        </DL><p>
1230
                        <DT><a name="PostgreSQL	" href="#PostgreSQL	"><H3 ADD_DATE="1368571842">PostgreSQL	</H3></a>
1231
<DD>after upgrading to 10.8, you need to modify PostgreSQL:
1232
change the postgres user to _postgres:
1233
$ sudo chown -R _postgres /Library/PostgreSQL/9.1/data/
1234
$ sudo chown -R _postgres /Library/PostgreSQL/9.1/postgres.log
1235
$ sudo -u _postgres /Library/PostgreSQL/9.1/bin/pg_ctl -D /Library/PostgreSQL/9.1/data -l /Library/PostgreSQL/9.1/postgres.log restart
1236
</DD>
1237
                        <DL><p>
1238
                        </DL><p>
1239 1293
                        <DT><a name="Python" href="#Python"><H3 ADD_DATE="1368656550">Python</H3></a>
1240 1294
                        <DL><p>
1241 1295
                            <DT><a name="psycopg2" href="#psycopg2"><H3 ADD_DATE="1368673201">psycopg2</H3></a>
......
1258 1312
                                <DT><A HREF="http://docs.python.org/2/library/collections.html#ordereddict-objects" name="http://docs.python.org/2/library/collections.html#ordereddict-objects" ADD_DATE="1368656709" ICON_URI="http://docs.python.org/2/_static/py.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://docs.python.org/2/_static/py.png" style="margin-right: 0.5em;"/>8.3. collections — High-performance container datatypes — Python v2.7.5 documentation</A><a name="8.3. collections — High-performance container datatypes — Python v2.7.5 documentation" href="#8.3. collections — High-performance container datatypes — Python v2.7.5 documentation" style="margin-left: 0.5em;">&para;</a>
1259 1313
                            </DL><p>
1260 1314
                        </DL><p>
1315
                        <DT><a name="PostgreSQL	" href="#PostgreSQL	"><H3 ADD_DATE="1368571842">PostgreSQL	</H3></a>
1316
<DD>after upgrading to 10.8, you need to modify PostgreSQL:
1317
change the postgres user to _postgres:
1318
$ sudo chown -R _postgres /Library/PostgreSQL/9.1/data/
1319
$ sudo chown -R _postgres /Library/PostgreSQL/9.1/postgres.log
1320
$ sudo -u _postgres /Library/PostgreSQL/9.1/bin/pg_ctl -D /Library/PostgreSQL/9.1/data -l /Library/PostgreSQL/9.1/postgres.log restart
1321
</DD>
1322
                        <DL><p>
1323
                        </DL><p>
1261 1324
                    </DL><p>
1262 1325
                    <DT><a name="MacFusion" href="#MacFusion"><H3 ADD_DATE="1367739060">MacFusion</H3></a>
1263 1326
                    <DL><p>
......
1947 2010
<DD>page's description: Free HTML XHTML CSS JavaScript jQuery XML DOM XSL XSLT RSS AJAX ASP .NET PHP SQL tutorials, references, examples for web building.
1948 2011
        </DL><p>
1949 2012
        <DT><A HREF="https://www.google.com/search?q=%s" name="https://www.google.com/search?q=%s" ADD_DATE="1318464507" ICON_URI="https://www.google.com/favicon.ico" SHORTCUTURL="g"><img width="16" height="16" src="https://www.google.com/favicon.ico" style="margin-right: 0.5em;"/>Google</A><a name="Google" href="#Google" style="margin-left: 0.5em;">&para;</a>
1950
        <DT><A HREF="https://www.google.com/calendar/render" name="https://www.google.com/calendar/render" ADD_DATE="1318014776" ICON_URI="https://calendar.google.com/googlecalendar/images/favicon_v2013_24.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://calendar.google.com/googlecalendar/images/favicon_v2013_24.ico" style="margin-right: 0.5em;"/>Google Calendar</A><a name="Google Calendar" href="#Google Calendar" style="margin-left: 0.5em;">&para;</a>
2013
        <DT><A HREF="https://www.google.com/calendar/render" name="https://www.google.com/calendar/render" ADD_DATE="1318014776" ICON_URI="https://calendar.google.com/googlecalendar/images/favicon_v2013_14.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://calendar.google.com/googlecalendar/images/favicon_v2013_14.ico" style="margin-right: 0.5em;"/>Google Calendar</A><a name="Google Calendar" href="#Google Calendar" style="margin-left: 0.5em;">&para;</a>
1951 2014
        <DT><A HREF="javascript:(function(){var%20ca,cea,cs,df,dfe,i,j,x,y;function%20n(i,what){return%20i+%22%20%22+what+((i==1)?%22%22:%22s%22)}ca=cea=cs=0;df=document.forms;for(i=0;i<df.length;++i){x=df[i];dfe=x.elements;if(x.onsubmit){x.onsubmit=%22%22;++cs;}if(x.attributes[%22autocomplete%22]){x.attributes[%22autocomplete%22].value=%22on%22;++ca;}for(j=0;j<dfe.length;++j){y=dfe[j];if(y.attributes[%22autocomplete%22]){y.attributes[%22autocomplete%22].value=%22on%22;++cea;}}}alert(%22Removed%20autocomplete=off%20from%20%22+n(ca,%22form%22)+%22%20and%20from%20%22+n(cea,%22form%20element%22)+%22,%20and%20removed%20onsubmit%20from%20%22+n(cs,%22form%22)+%22.%20After%20you%20type%20your%20password%20and%20submit%20the%20form,%20the%20browser%20will%20offer%20to%20remember%20your%20password.%22)})();" name="javascript:(function(){var%20ca,cea,cs,df,dfe,i,j,x,y;function%20n(i,what){return%20i+%22%20%22+what+((i==1)?%22%22:%22s%22)}ca=cea=cs=0;df=document.forms;for(i=0;i<df.length;++i){x=df[i];dfe=x.elements;if(x.onsubmit){x.onsubmit=%22%22;++cs;}if(x.attributes[%22autocomplete%22]){x.attributes[%22autocomplete%22].value=%22on%22;++ca;}for(j=0;j<dfe.length;++j){y=dfe[j];if(y.attributes[%22autocomplete%22]){y.attributes[%22autocomplete%22].value=%22on%22;++cea;}}}alert(%22Removed%20autocomplete=off%20from%20%22+n(ca,%22form%22)+%22%20and%20from%20%22+n(cea,%22form%20element%22)+%22,%20and%20removed%20onsubmit%20from%20%22+n(cs,%22form%22)+%22.%20After%20you%20type%20your%20password%20and%20submit%20the%20form,%20the%20browser%20will%20offer%20to%20remember%20your%20password.%22)})();" ADD_DATE="1318292619" SHORTCUTURL="r"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>remember password</A><a name="remember password" href="#remember password" style="margin-left: 0.5em;">&para;</a>
1952 2015
        <HR>        <DT><A HREF="place:sort=14&type=6&maxResults=10&queryType=1" name="place:sort=14&type=6&maxResults=10&queryType=1"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Recent Tags</A><a name="Recent Tags" href="#Recent Tags" style="margin-left: 0.5em;">&para;</a>
1953 2016
        <DT><A HREF="place:folder=BOOKMARKS_MENU&folder=UNFILED_BOOKMARKS&folder=TOOLBAR&sort=12&excludeQueries=1&maxResults=10&queryType=1" name="place:folder=BOOKMARKS_MENU&folder=UNFILED_BOOKMARKS&folder=TOOLBAR&sort=12&excludeQueries=1&maxResults=10&queryType=1"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>Recently Bookmarked</A><a name="Recently Bookmarked" href="#Recently Bookmarked" style="margin-left: 0.5em;">&para;</a>

Also available in: Unified diff