Postgres:Upgrading

From Earlham Cluster Department

Jump to: navigation, search

FreeBSD

pg_ctl -m fast stop && pg_ctl start

You might have to do a

postmaster -D /usr/local/pgsql/data

if there's a problem with the new client utilities when you're starting the server.

pg_dumpall > pg.dump

cp $HOME/data/*.{conf,key,crt} $HOME

rm -fr $HOME/data

initdb && cp $HOME/*.{conf,crt,key} $HOME/data

pg_ctl start

createdb pgsql && psql < pg.dump

Personal tools
Namespaces
Variants
Actions
websites
wiki
this semester
Toolbox