<DT><A HREF="http://vegpath.org/links/" name="__http://vegpath.org/links/" ADD_DATE="1389762684" ICON_URI="http://vegpath.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://vegpath.org/favicon.ico" style="margin-right: 0.5em;"/>links</A><a name="__links" href="#__links" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="http://vegpath.org./" name="__http://vegpath.org./" ADD_DATE="1365044622" ICON_URI="http://vegpath.org./favicon.ico"><img width="16" height="16" src="http://vegpath.org./favicon.ico" style="margin-right: 0.5em;"/>VegPath</A><a name="__VegPath" href="#__VegPath" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="http://bien.nceas.ucsb.edu/bien/" name="__http://bien.nceas.ucsb.edu/bien/" ADD_DATE="1317673928" ICON_URI="http://bien.nceas.ucsb.edu/bien/wp-content/ata-images/bien_favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://bien.nceas.ucsb.edu/bien/wp-content/ata-images/bien_favicon.ico" style="margin-right: 0.5em;"/>BIEN</A><a name="__BIEN" href="#__BIEN" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="http://www.redmine.org/projects/redmine/wiki/RedmineTextFormatting" name="__http://www.redmine.org/projects/redmine/wiki/RedmineTextFormatting" ADD_DATE="1318963452" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>markup</A><a name="__markup" href="#__markup" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Meetings" name="__https://projects.nceas.ucsb.edu/nceas/projects/bien/wiki/Meetings" ADD_DATE="1389763462" ICON_URI="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1391043242" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1391043242" style="margin-right: 0.5em;"/>meetings</A><a name="__meetings" href="#__meetings" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="https://projects.nceas.ucsb.edu/nceas/projects/bien/issues?c[]=status&c[]=priority&c[]=tracker&c[]=subject&c[]=updated_on&c[]=done_ratio&f[]=status_id&f[]=&group_by=&op[status_id]=o&per_page=100&set_filter=1&utf8=%E2%9C%93" name="__https://projects.nceas.ucsb.edu/nceas/projects/bien/issues?c[]=status&c[]=priority&c[]=tracker&c[]=subject&c[]=updated_on&c[]=done_ratio&f[]=status_id&f[]=&group_by=&op[status_id]=o&per_page=100&set_filter=1&utf8=%E2%9C%93" ADD_DATE="1328841076" ICON_URI="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1391043242"><img width="16" height="16" src="https://projects.nceas.ucsb.edu/nceas/favicon.ico?1391043242" style="margin-right: 0.5em;"/>issues</A><a name="__issues" href="#__issues" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="http://vegbiendev.nceas.ucsb.edu/phppgadmin/redirect.php?server=localhost%3A5432%3Aallow&subject=database&database=vegbien" name="__http://vegbiendev.nceas.ucsb.edu/phppgadmin/redirect.php?server=localhost%3A5432%3Aallow&subject=database&database=vegbien" ADD_DATE="1362008923" ICON_URI="http://vegbiendev.nceas.ucsb.edu/phppgadmin/images/themes/default/Introduction.png"><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>

        <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;"/>&quot;</A><a name="__&quot;" href="#__&quot;" style="margin-left: 0.5em;">&para;</a>

        <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>

        <DT><A HREF="http://rs.tdwg.org/dwc/terms/" name="__http://rs.tdwg.org/dwc/terms/" ADD_DATE="1344350345"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>DwC</A><a name="__DwC" href="#__DwC" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="http://vegbank.org/vegbank/views/dba_tabledescription_index.jsp?view=index&entity=dba_tabledescription" name="__http://vegbank.org/vegbank/views/dba_tabledescription_index.jsp?view=index&entity=dba_tabledescription" ADD_DATE="1345855547" ICON_URI="http://vegbank.org/vegbank/images/vegbank_logo16x16.gif" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://vegbank.org/vegbank/images/vegbank_logo16x16.gif" style="margin-right: 0.5em;"/>VegBank</A><a name="__VegBank" href="#__VegBank" style="margin-left: 0.5em;">&para;</a>

        <DT><A HREF="http://tnrs.iplantcollaborative.org/TNRSapp.html" name="__http://tnrs.iplantcollaborative.org/TNRSapp.html" ADD_DATE="1350962070" LAST_CHARSET="UTF-8"><img width="16" height="16" src="blank.gif" style="margin-right: 0.5em;"/>TNRS</A><a name="__TNRS" href="#__TNRS" style="margin-left: 0.5em;">&para;</a>

                                    <DD>page's self-description: ... so I deleted several GB of log files from the pg_xlog directory to free up some disk space.  Now my database won&#39;t start.     Oh-oh.  Um ... when ...

"Should you ever delete files from pg_clog, you might as well delete the entire database directory.  There is no recovery from a missing clog."

                                    <DD>page's self-description:  Symptoms 

Sometimes the transaction log files become corrupted or deleted due to hordware crash, orpower failure, usually the error is like folowing:

 hsphere=# select * from TABLE;

ERROR:  could not access status of transaction 1918986094

DETAIL:  could not open file "/var/lib/pgsql/data/pg_clog/0726": No such file or directory  ...

                                    <DT><A HREF="http://bytes.com/topic/postgresql/answers/422686-pg_clog-pg_xlog-empty-postgresql-refuses-start" name="http://bytes.com/topic/postgresql/answers/422686-pg_clog-pg_xlog-empty-postgresql-refuses-start" ADD_DATE="1397778294" ICON_URI="http://bytes.com/favicon.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://bytes.com/favicon.ico" style="margin-right: 0.5em;"/>pg_clog and pg_xlog empty, postgresql refuses to start - PostgreSQL Database</A><a name="pg_clog and pg_xlog empty, postgresql refuses to start - PostgreSQL Database" href="#pg_clog and pg_xlog empty, postgresql refuses to start - PostgreSQL Database" style="margin-left: 0.5em;">&para;</a>

                                    <DD>page's self-description: pg_clog and pg_xlog empty, postgresql refuses to start. PostgreSQL Database Forums on Bytes.

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/functions-conditional.html#FUNCTIONS-CASE" name="http://www.postgresql.org/docs/9.3/static/functions-conditional.html#FUNCTIONS-CASE" ADD_DATE="1399980245" 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: Conditional Expressions: CASE</A><a name="PostgreSQL: Documentation: 9.3: Conditional Expressions: CASE" href="#PostgreSQL: Documentation: 9.3: Conditional Expressions: CASE" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/sql-createcast.html" name="http://www.postgresql.org/docs/9.3/static/sql-createcast.html" ADD_DATE="1397607986" 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: CREATE CAST</A><a name="PostgreSQL: Documentation: 9.3: CREATE CAST" href="#PostgreSQL: Documentation: 9.3: CREATE CAST" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/sql-createdomain.html" name="http://www.postgresql.org/docs/9.3/static/sql-createdomain.html" ADD_DATE="1386257057" 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: CREATE DOMAIN</A><a name="PostgreSQL: Documentation: 9.3: CREATE DOMAIN" href="#PostgreSQL: Documentation: 9.3: CREATE DOMAIN" style="margin-left: 0.5em;">&para;</a>

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/sql-createview.html" name="http://www.postgresql.org/docs/9.3/static/sql-createview.html" ADD_DATE="1393552021" 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: CREATE VIEW</A><a name="PostgreSQL: Documentation: 9.3: CREATE VIEW" href="#PostgreSQL: Documentation: 9.3: CREATE VIEW" style="margin-left: 0.5em;">&para;</a>

                                <DD>&quot;Simple views are automatically updatable: the system will allow INSERT, UPDATE and DELETE statements to be used on the view in the same way as on a regular table.&quot; (this is only available in 9.3+)

                                <DT><A HREF="http://www.postgresql.org/docs/9.3/static/runtime-config-logging.html#GUC-LOG-ERROR-VERBOSITY" name="http://www.postgresql.org/docs/9.3/static/runtime-config-logging.html#GUC-LOG-ERROR-VERBOSITY" ADD_DATE="1384823719" 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: Error Reporting and Logging</A><a name="PostgreSQL: Documentation: 9.3: Error Reporting and Logging" href="#PostgreSQL: Documentation: 9.3: Error Reporting and Logging" style="margin-left: 0.5em;">&para;</a>

                            <DD>&quot;Set the display height to a specified number of lines&quot;

this will *not* change the scrollback height

                            <DD>page's self-description: Redmine

                        </DL><p>

                        <DT><A HREF="http://www.cs.utah.edu/dept/old/texinfo/screen/screen.html" name="http://www.cs.utah.edu/dept/old/texinfo/screen/screen.html" ADD_DATE="1370786697" ICON_URI="http://www.cs.utah.edu/favicon.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://www.cs.utah.edu/favicon.ico" style="margin-right: 0.5em;"/>Screen</A><a name="Screen" href="#Screen" style="margin-left: 0.5em;">&para;</a>

            <DT><A HREF="http://lists.samba.org/archive/rsync/2005-December/014176.html" name="http://lists.samba.org/archive/rsync/2005-December/014176.html" ADD_DATE="1348715930" ICON_URI="http://lists.samba.org/favicon.ico" LAST_CHARSET="us-ascii"><img width="16" height="16" src="http://lists.samba.org/favicon.ico" style="margin-right: 0.5em;"/>WARNING: &lt;file&gt; failed verification -- update discarded (will try again).</A><a name="WARNING: &lt;file&gt; failed verification -- update discarded (will try again)." href="#WARNING: &lt;file&gt; failed verification -- update discarded (will try again)." style="margin-left: 0.5em;">&para;</a>

        </DL><p>

        <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>

        <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>

        <HR>        <DT><A HREF="place:type=6&sort=14&maxResults=10" name="place:type=6&sort=14&maxResults=10" ADD_DATE="1403193938"><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>

        <DT><A HREF="place:folder=BOOKMARKS_MENU&folder=UNFILED_BOOKMARKS&folder=TOOLBAR&queryType=1&sort=12&maxResults=10&excludeQueries=1" name="place:folder=BOOKMARKS_MENU&folder=UNFILED_BOOKMARKS&folder=TOOLBAR&queryType=1&sort=12&maxResults=10&excludeQueries=1" ADD_DATE="1403193938"><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>