Skip to content

PostgreSQL update during pgcli installation via Homebrew #718

@ghost

Description

Description

Hi there,

I discovered pgcli yesterday and gave it a shot (like it so far).
I installed it via Homberew and unfortunately it seems that Homebrew also updated Postgres during the installation process. I can not start the Postgres server with my existing database files anymore. PostgreSQL server log says:

FATAL:  database files are incompatible with server
DETAIL:  The data directory was initialized by PostgreSQL version 9.4, which is not compatible with this version 9.6.3.

I've checked my /usr/local/bin directory - the timestamps of the pgcli and postgres symlinks are equal, whereas Python related symlinks and all of my other Homebrew installed programs are of an older date.
Could it be, that there is a bug in the Homebrew formula and Postgres will be always installed in bundle with pgcli? I couldn't find the formula for pgcli in this repository and don't have time ATM to investigate further.

Your environment

macOS 10.12.4
pgcli 1.5.1
PostgreSQL 9.4 yesterday, and 9.6.3 today 🙈
pip freeze says:

backports-abc==0.4
certifi==2016.8.31
click==6.6
Jinja2==2.8
livereload==2.4.1
Markdown==2.6.6
MarkupSafe==0.23
mkdocs==0.15.3
mkdocs-bootstrap==0.1.1
mkdocs-bootswatch==0.4.0
PyYAML==3.12
singledispatch==3.4.0.3
six==1.10.0
tornado==4.4.1
vboxapi==1.0
wheel==0.26.0

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions