[prev] 18 [next]

Before Installing ...

If you have databases from previous DB courses
  • the databases will no longer work under v12.1
  • to preserve them, use dump/restore
E.g. 

... login to grieg ...
... run your old server for the last time ...
$ pg_dump -O -x myFavDB > /srvr/YOU/myFavDB.dump
... stop your old server for the last time ...
... remove data from your old server ...
$ rm -fr /srvr/YOU/pgsql
... install and run your new PostgreSQL 12.1 server ...
$ createdb myFavDB
$ psql myFavDB -f /srvr/YOU/myFavDB.dump
... your old database is restored under 12.1 ...