![]() Performing post-bootstrap initialization. Selecting dynamic shared memory implementation. The default text search configuration will be set to "english".įixing permissions on existing directory /usr/local/var/postgres. The default database encoding has accordingly been set to "UTF8". The database cluster will be initialized with locale "en_US.UTF-8". This user must also own the server process. The files belonging to this database system will be owned by user "nyc". usr/local/opt/postgresql/bin/initdb /usr/local/var/postgres => Moving postgresql data from /usr/local/var/postgres to /usr/local/var/postgres.old. 17:37:33.282 CET LOG: database system is shut down 17:37:33.282 CET HINT: It looks like you need to initdb. 17:37:33.282 CET DETAIL: The database cluster was initialized with PG_CONTROL_VERSION 1300, but the server was compiled with PG_CONTROL_VERSION 1201. 17:37:33.282 CET FATAL: database files are incompatible with server => Upgrading postgresql data from 12 to -w -D /usr/local/var/postgres start usr/local/Homebrew/Library/Homebrew/brew.rb (Formulary::FormulaLoader): loading /usr/local/Homebrew/Library/Taps/homebrew/homebrew-core/Formula/postgresql.rb Install-on-request: 176,623 (30 days), 554,629 (90 days), 1,910,250 (365 days)įollowing the output, I'm trying to run brew postgresql-upgrade-database, but it does not work – here is the output: $ brew postgresql-upgrade-database -debug -verbose Or, if you don't want/need a background service you can just run: To have launchd start postgresql now and restart at login: Initdb -locale=C -E UTF-8 /usr/local/var/postgres This formula has created a default database cluster with: To migrate existing data from a previous major version of PostgreSQL run: ![]() Now I have 13.1 installed: $ brew info postgres I've just sit down to my work, forgetting that I've upgraded brew in the 2020 – so of course I have a postgresql problem.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |