PugsDrupalInstall

From PostgreSQL wiki
Jump to navigationJump to search

Rough Notes

  • dumped the postgres database
  • pkgdb -F (clean up ports dir)
  • portsnap fetch (to update ports)

uh oh.

pugs# cd /
pugs# du -sh .
2.4G	.
pugs# pwd
/
pugs# df
Filesystem  1K-blocks      Used   Avail Capacity  Mounted on
/dev/da0s1g 195122110 173737996 5774346    97%    /
pugs# df -hl
Filesystem     Size    Used   Avail Capacity  Mounted on
/dev/da0s1g    186G    166G    5.5G    97%    /
pugs#

5/31/2009, sweet:

pugs:root /usr/local/etc/apache22/virtual_hosts> df -hl
Filesystem     Size    Used   Avail Capacity  Mounted on
/dev/da0s1g    186G    169G    2.3G    99%    /

Plowing ahead...

  • Downloaded version 5.18 of drupal
  • Updated apache config: /usr/local/etc/apache22/virtual_hosts/www.pugs.postgresql.org.conf to point to test directory
  • pg_dump -U drupal -d drupal > drupaldb_backup2.sql
  • dropdb -U pgsql testdrupal
  • createdb -U pgsql testdrupal -O drupal -E UTF8
  • psql -U pgsql -d testdrupal < drupaldb_backup2.sql