Postgres app update db version12/17/2023 pg_upgrade will leave behind two scripts, analyze_new_cluster.sh and delete_old_cluster.sh.Finally, run the upgrade with /Applications/Postgres.app/Contents/Versions/9.6/bin/pg_upgrade -b /Applications/Postgres.app/Contents/Versions/9.5/bin -B /Applications/Postgres.app/Contents/Versions/9.6/bin -d ~/Library/Application\ Support/Postgres/var-9.5 -D ~/Library/Application\ Support/Postgres/var-9.6 -v (see the pg_upgrade documentation for details).In the terminal, create a new database cluster with /Applications/Postgres.app/Contents/Versions/9.6/bin/initdb -D ~/Library/Application\ Support/Postgres/var-9.6 -encoding=UTF-8 -locale=en_US.UTF-8.> Successfully started postgresql (label: homebrew.mxcl. brew services start postgres We will get a similar output shown below. To start PostgreSQL run the following command in the Terminal. ![]() psql -version psql (PostgreSQL) 11.5 Start PostgreSQL.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |