<DT><a name="licenses" href="#licenses"><H3 ADD_DATE="1384772538">licenses</H3></a>

                <DL><p>

                    <DT><A HREF="https://raw.github.com/Datafable/gbif-data-licenses/master/data/licenses.csv" name="https://raw.github.com/Datafable/gbif-data-licenses/master/data/licenses.csv" ADD_DATE="1384772508" ICON_URI="https://raw.github.com/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://raw.github.com/favicon.ico" style="margin-right: 0.5em;"/>licenses.csv</A><a name="licenses.csv" href="#licenses.csv" style="margin-left: 0.5em;">&para;</a>

                    <DT><A HREF="https://github.com/Datafable/gbif-data-licenses/blob/master/guidelines.md" name="https://github.com/Datafable/gbif-data-licenses/blob/master/guidelines.md" ADD_DATE="1384772513" 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;"/>guidelines</A><a name="guidelines" href="#guidelines" style="margin-left: 0.5em;">&para;</a>

<DD>page's description: gbif-data-licenses - Standardizing licenses of GBIF mediated data

                </DL><p>

            <DT><A HREF="https://utk.co1.qualtrics.com/SE/?SID=SV_aWxuyT94cZBsBb7" name="https://utk.co1.qualtrics.com/SE/?SID=SV_aWxuyT94cZBsBb7" ADD_DATE="1384453000" ICON_URI="https://utk.co1.qualtrics.com/WRQualtricsShared/Brands/utk/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://utk.co1.qualtrics.com/WRQualtricsShared/Brands/utk/favicon.ico" style="margin-right: 0.5em;"/>Survey | Qualtrics Survey Software | Current Progress 21%</A><a name="Survey | Qualtrics Survey Software | Current Progress 21%" href="#Survey | Qualtrics Survey Software | Current Progress 21%" style="margin-left: 0.5em;">&para;</a>

<DD>page's description: Survey Software, Enterprise Survey software for enterprise feedback management and CRM solutions. Enables high-quality data collection, panel management and results analysis. Perfect for market research or CRM solution (Customer Relationship Management) integration. Free trial and consultation.

"Which of the following do you use to access or submit data? (Choose all that apply.)

    DAAC (A Distributed Active-Archive Center)

    DataONE (Data Observation Network for Earth)

    Dryad

    ESA (Ecological Society of America)

    GBIF (A Global Biodiversity Information Facility)

    ILTER (International Long-term Ecological Research Network)

    KNB (Knowledge Network of Biocomplexity)

    LTER (Long-term Ecological Research Network)

    NEON (National Ecological Observatory Network)

    ORNL DAAC (Oak Ridge National Laboratory Distributed Active Archive Center)

    PISCO (Partnership for Interdisciplinary Study of Coastal Oceans)

    SAEON (South African Environmental Observation Network)

    SanParks (South Africa National Parks)

    TERN (Taiwan Ecological Research Network)

    UC3 (University of California Curation Center)

    USGS CSC (USGS Core Sciences Clearinghouse)

"

<DD>after installing, you need to restore config values that the upgrade reset:

- in pgAdmin > Preferences > Query tool > Query editor, set Max characters per column back to -1 (to avoid cells being truncated). this is *not* a bug in PostgreSQL, only in pgAdmin, and does *not* signal a need to downgrade.

</DD>

                                <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;">&para;</a>

<DD>page's 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...

<DD>-

on Linux:

$ 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

on Linux:

$ sudo -u postgres /usr/lib/postgresql/9.3/bin/initdb -D /var/lib/postgresql/9.3/main/ -E UTF8 --lc-collate=en_US.UTF-8

$ sudo -u postgres initdb -D /Library/PostgreSQL/9.3/data/ -E UTF8 --lc-collate=en_US.UTF-8

                                    <DT><A HREF="http://stackoverflow.com/questions/19271219/ubuntu-12-04-postgresql-9-1-cant-access-libdir-postgis-2-0" name="http://stackoverflow.com/questions/19271219/ubuntu-12-04-postgresql-9-1-cant-access-libdir-postgis-2-0" ADD_DATE="1384519712" 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;"/>Ubuntu 12.04, PostgreSQL-9.1 - Can&#39;t access $libdir/postgis-2.0 - Stack Overflow</A><a name="Ubuntu 12.04, PostgreSQL-9.1 - Can&#39;t access $libdir/postgis-2.0 - Stack Overflow" href="#Ubuntu 12.04, PostgreSQL-9.1 - Can&#39;t access $libdir/postgis-2.0 - Stack Overflow" style="margin-left: 0.5em;">&para;</a>

<DD>-

on Linux:

$ sd ln -s postgis-2.1.so /usr/lib/postgresql/9.3/lib/postgis-2.0.so

on Linux:

$ sudo service postgresql stop

$ for i in /etc/postgresql/9.1/main/*.conf*; do sudo ln -sf "$i" /var/lib/postgresql/9.1/main/; done

$ for i in /etc/postgresql/9.3/main/*.conf*; do sudo ln -sf "$i" /var/lib/postgresql/9.3/main/; done

$ sudo -u postgres -s

$ mkdir /tmp/postgres_install

$ cd /tmp/postgres_install

$ /usr/lib/postgresql/9.3/bin/pg_upgrade --user=postgres -b /usr/lib/postgresql/9.1/bin/ -B /usr/lib/postgresql/9.3/bin/ -d /var/lib/postgresql/9.1/main/ -D /var/lib/postgresql/9.3/main/ # runtime: 1 h ("04:47:01" - ~"05:50") for a 312 GB cluster (staging tables+import)

$ sudo service postgresql start

$ sudo -u postgres psql -p 5433 # try connecting to the new DB

$ sudo apt-get remove postgresql-9.1

$ ./delete_old_cluster.sh

$ ./analyze_new_cluster.sh # runtime: 30 min ("31m6.298s")

# stop the PostgreSQL server

$ 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 ("06:28:35" - "06:14:41") for a 30 GB cluster (staging tables only)

# start the PostgreSQL server

# try connecting to the new DB

$ ./analyze_new_cluster.sh # runtime: 30 min ("07:10:59" - "06:40:23") for a 30 GB cluster (staging tables only)

                                <DT><A HREF="https://groups.google.com/forum/#!msg/django-users/Bv63_job__w/b5ylXGwVW8kJ" name="https://groups.google.com/forum/#!msg/django-users/Bv63_job__w/b5ylXGwVW8kJ" ADD_DATE="1384765320" ICON_URI="https://groups.google.com/forum/favicon.ico" LAST_CHARSET="UTF-8"><img width="16" height="16" src="https://groups.google.com/forum/favicon.ico" style="margin-right: 0.5em;"/>Psycopg2 on Mac OS X (Snow Leopard) - Google Groups</A><a name="Psycopg2 on Mac OS X (Snow Leopard) - Google Groups" href="#Psycopg2 on Mac OS X (Snow Leopard) - Google Groups" style="margin-left: 0.5em;">&para;</a>

<DD>page's description: Google Groups allows you to create and participate in online forums and email-based groups with a rich experience for community conversations.

on Mac:

'(2) Create symbolic links in /usr/lib :

sudo ln -s /Library/PostgreSQL/9.3/lib/libpq.5.dylib /usr/lib/libpq.5.dylib

sudo ln -s /Library/PostgreSQL/9.3/lib/libssl.1.0.0.dylib /usr/lib/libssl.1.0.0.dylib

sudo ln -s /Library/PostgreSQL/9.3/lib/libcrypto.1.0.0.dylib /usr/lib/libcrypto.1.0.0.dylib

'