Revision 13254
Added by Aaron Marcuse-Kubitza over 10 years ago
index.htm | ||
---|---|---|
742 | 742 |
not be capable of replaying whatever happened since your last checkpoint." |
743 | 743 |
<DT><A HREF="http://www.postgresql.org/message-id/CB0FB369FF86E248A884BCC002562BCB010C0D9F@pisgsna01sxch01.ana.firstamdata.com" name="http://www.postgresql.org/message-id/CB0FB369FF86E248A884BCC002562BCB010C0D9F@pisgsna01sxch01.ana.firstamdata.com" ADD_DATE="1397777667" 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: what are the pg_clog and pg_xlog directories ?</A><a name="Re: what are the pg_clog and pg_xlog directories ?" href="#Re: what are the pg_clog and pg_xlog directories ?" style="margin-left: 0.5em;">¶</a> |
744 | 744 |
</DL><p> |
745 |
<DT><A HREF="http://www.postgresql.org/docs/9.3/static/continuous-archiving.html#BACKUP-BASE-BACKUP" name="http://www.postgresql.org/docs/9.3/static/continuous-archiving.html#BACKUP-BASE-BACKUP" ADD_DATE="1397776277" 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: Continuous Archiving and Point-in-Time Recovery (PITR)</A><a name="*** PostgreSQL: Documentation: 9.3: Continuous Archiving and Point-in-Time Recovery (PITR)" href="#*** PostgreSQL: Documentation: 9.3: Continuous Archiving and Point-in-Time Recovery (PITR)" style="margin-left: 0.5em;">¶</a>
|
|
745 |
<DT><A HREF="http://www.postgresql.org/docs/9.3/static/continuous-archiving.html" name="http://www.postgresql.org/docs/9.3/static/continuous-archiving.html" ADD_DATE="1397776277" 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.3: Continuous Archiving and Point-in-Time Recovery (PITR)</A><a name="*** PostgreSQL: Documentation: 9.3: Continuous Archiving and Point-in-Time Recovery (PITR)" href="#*** PostgreSQL: Documentation: 9.3: Continuous Archiving and Point-in-Time Recovery (PITR)" style="margin-left: 0.5em;">¶</a>
|
|
746 | 746 |
<DD>"To prepare for low level standalone hot backups, set wal_level to archive (or hot_standby), archive_mode to on, and set up an archive_command that performs archiving only when a switch file exists." |
747 | 747 |
|
748 | 748 |
to work with a filesystem-level backup, you need a WAL chain that's at least long enough (time-wise) for the WAL blocks created when it starts copying base/ to still be around when it finishes copying pg_xlog/ (it must also copy in alphabetical order, and not in parallel). |
... | ... | |
1054 | 1054 |
<DT><A HREF="http://postgresql.1045698.n5.nabble.com/9-3beta2-unrecognized-node-type-in-join-alias-vars-when-retrieving-view-definition-td5764616.html" name="http://postgresql.1045698.n5.nabble.com/9-3beta2-unrecognized-node-type-in-join-alias-vars-when-retrieving-view-definition-td5764616.html" ADD_DATE="1384528374" 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 - bugs - 9.3beta2 unrecognized node type in join alias vars when retrieving view definition</A><a name="PostgreSQL - bugs - 9.3beta2 unrecognized node type in join alias vars when retrieving view definition" href="#PostgreSQL - bugs - 9.3beta2 unrecognized node type in join alias vars when retrieving view definition" style="margin-left: 0.5em;">¶</a> |
1055 | 1055 |
<DD>page's own description: 9.3beta2 unrecognized node type in join alias vars when retrieving view definition. Hi all, While testing the 9.3 beta I am unable to get the view definition for some views. Because of this I... |
1056 | 1056 |
<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;">¶</a> |
1057 |
<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;">¶</a>
|
|
1057 |
<DT><A HREF="http://wiki.postgresql.org/wiki/Apt" name="http://wiki.postgresql.org/wiki/Apt" ADD_DATE="1384429170" ICON_URI="http://wiki.postgresql.org/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://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;">¶</a>
|
|
1058 | 1058 |
<DD>- |
1059 | 1059 |
on Linux: |
1060 | 1060 |
$ sudo apt-get --yes install postgresql-9.3 postgresql-contrib-9.3 postgresql-plpython-9.3 postgresql-plpython3-9.3 libpq-dev postgresql-9.3-postgis phppgadmin |
1061 |
<DT><A HREF="https://gist.github.com/pyk/8243010" name="https://gist.github.com/pyk/8243010" ADD_DATE="1397860988" ICON_URI="https://gist.github.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://gist.github.com/favicon.ico" style="margin-right: 0.5em;"/>installing postgresql 9.3.2 on ubuntu 12.04 . with error fix: ummet dependencies</A><a name="installing postgresql 9.3.2 on ubuntu 12.04 . with error fix: ummet dependencies" href="#installing postgresql 9.3.2 on ubuntu 12.04 . with error fix: ummet dependencies" style="margin-left: 0.5em;">¶</a> |
|
1062 |
<DD>page's own description: installing postgresql 9.3.2 on ubuntu 12.04 . with error fix: ummet dependencies - Gist is a simple way to share snippets of text and code with others. |
|
1061 | 1063 |
<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> |
1062 | 1064 |
<DL><p> |
1063 | 1065 |
<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;">¶</a> |
... | ... | |
2034 | 2036 |
<DT><a name="bash" href="#bash"><H3 ADD_DATE="1364942440">bash</H3></a> |
2035 | 2037 |
<DL><p> |
2036 | 2038 |
<DT><a name="** modifying a running shell script" href="#** modifying a running shell script"><H3 ADD_DATE="1387293257">** modifying a running shell script</H3></a> |
2037 |
<DD>you need to first unlink the file, and *then* upload the modified version. in jEdit, this can be done by enabling two-stage save. do **not** use `svn up`, as this is unsafe.
|
|
2039 |
<DD>you need to first unlink the file, and *then* upload the modified version. in jEdit, this can be done by enabling two-stage save. `svn up` and rsync (without --inplace) use two-stage save automatically.
|
|
2038 | 2040 |
|
2039 | 2041 |
to prevent this from occurring accidentally, always make all your shell scripts read-only. this will force applications to use two-stage save (where supported) to replace these files. |
2040 | 2042 |
</DD> |
... | ... | |
2130 | 2132 |
</DL><p> |
2131 | 2133 |
<DT><a name="rsync" href="#rsync"><H3 ADD_DATE="1371887829">rsync</H3></a> |
2132 | 2134 |
<DL><p> |
2135 |
<DT><A HREF="https://lists.samba.org/archive/rsync/2007-May/017762.html" name="https://lists.samba.org/archive/rsync/2007-May/017762.html" ADD_DATE="1398124582" ICON_URI="https://lists.samba.org/favicon.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="https://lists.samba.org/favicon.ico" style="margin-right: 0.5em;"/>rsync --append behavior</A><a name="rsync --append behavior" href="#rsync --append behavior" style="margin-left: 0.5em;">¶</a> |
|
2133 | 2136 |
<DT><A HREF="http://www.linuxquestions.org/questions/linux-networking-3/rsync-ignore-files-484569/" name="http://www.linuxquestions.org/questions/linux-networking-3/rsync-ignore-files-484569/" ADD_DATE="1371887755" ICON_URI="http://www.linuxquestions.org/favicon.ico" LAST_CHARSET="windows-1252"><img width="16" height="16" src="http://www.linuxquestions.org/favicon.ico" style="margin-right: 0.5em;"/>rsync ignore files</A><a name="rsync ignore files" href="#rsync ignore files" style="margin-left: 0.5em;">¶</a> |
2134 | 2137 |
<DD>page's own description: Hello colleague I have little problem with my rsync's.I make sync from our country to other and everything is working.When sync finish donwloading or |
2135 | 2138 |
|
... | ... | |
2838 | 2841 |
</DL><p> |
2839 | 2842 |
<DT><a name="e-mail" href="#e-mail"><H3 ADD_DATE="1380814310">e-mail</H3></a> |
2840 | 2843 |
<DL><p> |
2841 |
<DT><A HREF="http://gmvault.org/download.html" name="http://gmvault.org/download.html" ADD_DATE="1377193376" ICON_URI="http://gmvault.org/assets/ico/gmv-favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://gmvault.org/assets/ico/gmv-favicon.ico" style="margin-right: 0.5em;"/>Gmvault: gmail backup</A><a name="Gmvault: gmail backup" href="#Gmvault: gmail backup" style="margin-left: 0.5em;">¶</a> |
|
2844 |
<DT><a name="Gmail" href="#Gmail"><H3 ADD_DATE="1397858146">Gmail</H3></a> |
|
2845 |
<DL><p> |
|
2846 |
<DT><A HREF="http://gmvault.org/download.html" name="http://gmvault.org/download.html" ADD_DATE="1377193376" ICON_URI="http://gmvault.org/assets/ico/gmv-favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="http://gmvault.org/assets/ico/gmv-favicon.ico" style="margin-right: 0.5em;"/>Gmvault: gmail backup</A><a name="Gmvault: gmail backup" href="#Gmvault: gmail backup" style="margin-left: 0.5em;">¶</a> |
|
2842 | 2847 |
<DD>page's own description: backup and restore your gmail account |
2843 | 2848 |
|
2844 | 2849 |
To do full backup: /Applications/gmvault-v1.8.1-beta/bin/gmvault sync --multiple-db-owner user@gmail.com |
2845 | 2850 |
To backup only new e-mails: /Applications/gmvault-v1.8.1-beta/bin/gmvault sync --multiple-db-owner --type quick user@gmail.com |
2846 | 2851 |
|
2847 | 2852 |
In Mac OS X (including 10.8), you need to run `.../gmvault-v1.8.1-beta/bin/gmvault`. This is in the README.txt under "Linux and Mac OS X install". However, other methods don't work: gmv_runner.app just opened and closed, `pip install gmvault` gave me an error "pkg_resources.DistributionNotFound: pip==1.1", and `sudo easy_install gmvault` gave me an error "ImportError: No module named gmv.gmv_cmd". |
2853 |
<DT><A HREF="https://developer.mozilla.org/en-US/docs/WebAPI/Using_Web_Notifications" name="https://developer.mozilla.org/en-US/docs/WebAPI/Using_Web_Notifications" ADD_DATE="1397858093" ICON_URI="https://developer.cdn.mozilla.net/media/redesign/img/favicon32.png" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://developer.cdn.mozilla.net/media/redesign/img/favicon32.png" style="margin-right: 0.5em;"/>Using Web Notifications - WebAPI | MDN</A><a name="Using Web Notifications - WebAPI | MDN" href="#Using Web Notifications - WebAPI | MDN" style="margin-left: 0.5em;">¶</a> |
|
2854 |
<DD>page's own description: The Web Notifications API allows a web page to send notifications that are displayed outside the page at the system level. This allows web apps to send information to a user even if the application is idle. One of the main obvious use cases is a webmail application that would notify the user each time a new e-mail is received, even if the user is doing something else with another application. |
|
2855 |
|
|
2856 |
"Firefox and Safari close the notifications automatically after a few moments, e.g. 4 seconds" |
|
2857 |
</DL><p> |
|
2848 | 2858 |
</DL><p> |
2849 | 2859 |
<DT><a name="server side" href="#server side"><H3 ADD_DATE="1380326988">server side</H3></a> |
2850 | 2860 |
<DL><p> |
... | ... | |
2994 | 3004 |
<DD>page's own description: Free HTML XHTML CSS JavaScript jQuery XML DOM XSL XSLT RSS AJAX ASP .NET PHP SQL tutorials, references, examples for web building. |
2995 | 3005 |
</DL><p> |
2996 | 3006 |
<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;">¶</a> |
2997 |
<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_17.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://calendar.google.com/googlecalendar/images/favicon_v2013_17.ico" style="margin-right: 0.5em;"/>Google Calendar</A><a name="Google Calendar" href="#Google Calendar" style="margin-left: 0.5em;">¶</a>
|
|
3007 |
<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_21.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://calendar.google.com/googlecalendar/images/favicon_v2013_21.ico" style="margin-right: 0.5em;"/>Google Calendar</A><a name="Google Calendar" href="#Google Calendar" style="margin-left: 0.5em;">¶</a>
|
|
2998 | 3008 |
<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;">¶</a> |
2999 | 3009 |
<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;">¶</a> |
3000 | 3010 |
<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;">¶</a> |
Also available in: Unified diff
web/links/index.htm: updated to Firefox bookmarks: modifying a running shell script: updated to document that `svn up` actually does use two-stage save automatically