Upgrade macports postgresql92-server to postgresql93-server, make sure lc-collate, lc-type and encoding match your current cluster.

pg92-upgrade-topg93.sh

#!/usr/bin/env bash

set -x 

homedir=/opt/local/var/db/postgresql93
datadir=${homedir}/defaultdb

if [ -e $datadir ]; then
  echo "$datadir already exists, removing....[no]"
  # then rm -fr $datadir
  exit 1
fi

mkdir -p $datadir \
  && chown postgres:postgres $datadir \
  && su postgres -c '/opt/local/lib/postgresql93/bin/initdb -D /opt/local/var/db/postgresql93/defaultdb --lc-collate=C --lc-ctype=C --encoding=UTF-8' \
  && echo 'export PATH=/opt/local/lib/postgresql93/bin:$PATH' >> ${homedir}/.bashrc \
  && echo 'source .bashrc' > ${homedir}/.bash_profile \
  && chown postgres:postgres ${homedir}/.bash* \
  && su postgres -c "cd $datadir && pg_upgrade -b /opt/local/lib/postgresql92/bin -B /opt/local/lib/postgresql93/bin -d /opt/local/var/db/postgresql92/defaultdb -D /opt/local/var/db/postgresql93/defaultdb -v -j 8"