主页 / dba / 问题 / 256255
Accepted
rawmain
Asked: 2019-12-25 17:02:54 +0800 CST

无法在 macOS 上连接 psql

  • 772

安装

$ brew install postgresql
Updating Homebrew...
==> Downloading https://homebrew.bintray.com/bottles/postgresql-12.1.mojave.bottle.tar.gz
Already downloaded: /Users/user/Library/Caches/Homebrew/downloads/525a3637cd6f7b7a7e0bfe5adb102483ae01f4be31269aaf4348f6f4291f8a86--postgresql-12.1.mojave.bottle.tar.gz
==> Pouring postgresql-12.1.mojave.bottle.tar.gz
==> /usr/local/Cellar/postgresql/12.1/bin/initdb --locale=C -E UTF-8 /usr/local/var/postgres
==> Caveats
To migrate existing data from a previous major version of PostgreSQL run:
  brew postgresql-upgrade-database

To have launchd start postgresql now and restart at login:
  brew services start postgresql
Or, if you don't want/need a background service you can just run:
  pg_ctl -D /usr/local/var/postgres start
==> Summary
?  /usr/local/Cellar/postgresql/12.1: 3,217 files, 37.3MB

检查状态

$ brew services list
postgresql     started user /Users/user/Library/LaunchAgents/homebrew.mxcl.postgresql.plist

连接

$ psql
psql: error: could not connect to server: FATAL:  database "user" does not exist

$ psql -U postgres
psql: error: could not connect to server: FATAL:  database "postgres" does not exist

它已经初始化了数据库，为什么postgres不存在呢？

postgresql macos

2 个回答

  1. Best Answer

    本指南效果很好：

    https://gist.github.com/ibraheem4/ce5ccd3e4d7a65589ce84f2a3b7c23a3

    有必要手动创建数据库和角色，因为它们不存在。

    • 0

  2. 我在 macOS monterey 上为自制 postgresql 14 找到的唯一解决方案是：

        brew services stop postgresql
    cd /opt/homebrew/var/postgres
    rm -rf /opt/homebrew/var/postgres/*
    initdb -U `whoami` .
    brew services start postgresql
    psql template1
    • 0

相关问题