11/3/2023 0 Comments Homebrew postgres syntax error![]() = > Upgrading postgresql data from 12 to 13. This issue looks very similar to this /u/l/v/p/pg_snapshots > brew postgresql-upgrade-database 07:31:24.475 AEST LOG: database system is shut downĮrror: Failure while executing `/usr/local/Cellar/postgresql/12.4/bin/initdb -lc-collate=en_AU.UTF-8 -lc-ctype=en_AU.UTF-8 -lc-messages=en_AU.UTF-8 -lc-monetary=en_AU.UTF-8 -lc-numeric=en_AU.UTF-8 -lc-time=en_AU.UTF-8 -E\ UTF8 /usr/local/var/postgres` exited with 1. 07:31:24.467 AEST LOG: background worker "logical replication launcher" (PID 22178) exited with exit code 1 07:31:24.466 AEST LOG: aborting any active transactions 07:31:24.464 AEST LOG: received fast shutdown request 07:31:24.251 AEST LOG: database system is ready to accept connections 07:31:24.247 AEST LOG: database system was shut down at 07:31:09 AEST Running brew postgresql-upgrade-database to upgrade database and data from 11.8 to 12 Command output => Upgrading postgresql data from 11 to 12. Git: 2.24.3 => /Library/Developer/CommandLineTools/usr/bin/git Homebrew Ruby: 2.6.3 => /System/Library/Frameworks/amework/Versions/2.6/usr/bin/ruby This issue looks very similar to this issue. Just run brew postgresql-upgrade-database. Step-by-step reproduction instructions (by running brew install commands) I expected the version of posgres to be updated to the most recent version 12 and my data migrated from the version 11 format to the version 12 format. => Moving postgresql data back from /usr/local/var/postgres.old to /usr/local/var/postgres.Įrror: Failure while executing /usr/local/Cellar/postgresql/12.4/bin/initdb -lc-collate=en_US.UTF-8 -lc-ctype=en_US.UTF-8 -lc-messages=en_US.UTF-8 -lc-monetary=en_US.UTF-8 -lc-numeric=en_US.UTF-8 -lc-time=en_US.UTF-8 -E\ UTF8 /usr/local/var/postgres exited with 1. ![]() => Moving postgresql data from /usr/local/var/postgres to /usr/local/var/postgres.old.Įrror: Upgrading postgresql data from 11 to 12 failed! => Successfully stopped (label: for server to shut down. ![]() Running brew postgresql-upgrade-database to upgrade database and data from 11.8 to 12 What happened (include command output) Command output Included brew_config.txt and brew_doctor.txt and brew_doctor1.txt (output of brew doctor after trying to fix issues outlined initial run of brew_doctor if brew gist-logs didn't work: ran brew config and brew doctor and included their output with your issue?. ![]() When I run brew gist-logs postgresql-upgrade-database I get this output:Įrror: No available formula with the name "postgresql-upgrade-database" ran brew gist-logs (where is the name of the formula that failed) and included the output link?.I have run brew doctor and fixed a number of issues, but cannot reproduce the problem (see above). ran brew doctor, fixed all issues and can still reproduce the problem?.I have also asked this ) on SO but received no answer. On the other hand, brew update did not update any postgresl formulae. ran brew update and can still reproduce the problem?.Please see post below to see problem in a reproducible format.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |