This machine hosts the both the Project’s public-facing website and our internal portal site (a Pylons-based web app). It’s also running the Postgres database backing the portal.
| hardware: | Mac Mini |
|---|---|
| ram: | 4 GB |
| os: | Snow Leopard (10.6.6) |
| dns: | ldp.spc.uchicago.edu |
| ip: | 128.135.189.218 |
| location: | Green 512 |
| services: | web app hosting, postgres database server |
The production environment is located in ~/virtualenvs/production.
Top-level contents:
bin/ (binaries and scripts)
build/
data/
images/
sessions/
templates/
docs/ (doc site contents)
include/ (link to Python lib)
initial_data/ (csv data files for postgres db)
lib/
production.ini (Pylons config file)
server-scripts/ (scripts for syncing files, etc.)
src/ (source files)
wsgi-scripts/
Our launchd *.plist files can be found in \Library\LaunchDaemons. (See Cron Jobs for overview.)
The log file for the doc site update script (~/virtualenvs/production/server-scripts/sync-docs) is in /var/log/ldpsite/docs.log.
Some of the scripts in ~/virtualenvs/production/server-scripts/* are triggered by launchd at specified times. See the *.plist files in /Library/LaunchDaemons or try sudo launchctl list | grep ldp to see a list of LDP-related jobs.
To access the postgres database use psql -U postgres ldp.
Use \d to see the overall schema or \d TABLE where “TABLE” is the name of one of the tables (e.g. \d samples)
To see the list of user defined data types use \dT (or \dT+ to see the data type definitions).
To dump a set of rows from a table use the following sequence:
\f ',' (set separator to comma)
\a (toggle alignment)
\t (toggle tuples/rows only)
\o out.csv (dump to "out.csv")
select ... (your select statement)
\o
\q
A log of significant changes made to the system.
For example ...
Added server-scripts dir to production environment. This currently contains a script, sync-docs, for updating the documentation site. (See comments in source file for implementation details.)
Also added com.ldp.sync-docs.plist to /Libary/LaunchDaemons and loaded this job using launchctl. This will run the sync-doc script at 3 AM nightly.