Installed `postgres` binary is throwing segmentation fault on macOS 12.0
dongxinEric opened this issue · 11 comments
The auto installed postgres
binary is throwing out segmentation fault when run on macOS 12.0
Version 10.18
works just fine.
Version 10.18 works just fine.
Turns out the version 10.18
from brew worked fine, but the one from EDB didn't work. 11.13
from EDB worked fine.
@dongxinEric Did you find any workaround for this on macOS 12.0? I installed postgresql@10 with homebrew, but segmentation fault is still here...
I've tried several versions of Postgres from EDB and via brew and continue to get segmentation faults:
no data was returned by command "".../build/PG-578c3302bce806451b07e3a73d8438d1/bin/postgres" -V"
when I try to run the embedded postgres
binary via command line:
build/PG-578c3302bce806451b07e3a73d8438d1/bin/postgres -V
[1] 14986 segmentation fault build/PG-578c3302bce806451b07e3a73d8438d1/bin/postgres -V
In case it helps...
I downloaded the Postgres binaries directly from the EDB website and they seg fault for me when I run them directly from command line (without using Opentable Embedded Posgtres) on macOS 12.0.1, so that seems to be where the root cause of the issue is I believe.
I tried the binaries from:
- http://get.enterprisedb.com/postgresql/postgresql-10.6-1-osx-binaries.zip - which is what is in the repack-postgres.sh script in this repo
- http://get.enterprisedb.com/postgresql/postgresql-10.18-1-osx-binaries.zip - I tried these binaries as well since the Enterprise DB website claims that version 10.18 is still supported on Mac OS, see: https://content-www.enterprisedb.com/downloads/postgres-postgresql-downloads
But I get the following when I try to run the binary:
./postgres
[1] 19003 segmentation fault ./postgres
Version 11.13 and 12.8 from http://get.enterprisedb.com/postgresql/postgresql-11.13-1-osx-binaries.zip and http://get.enterprisedb.com/postgresql/postgresql-12.8-1-osx-binaries.zip did seem to work for me:
./postgres -V
postgres (PostgreSQL) 11.13
and
./postgres -V
postgres (PostgreSQL) 12.8
So a couple of options would be to:
- Update this project to use Postgres 11.13 or 12.8 (or later presumably) and release a new version
- Customize Embedded Postgres to use a custom version of Postgres using
PgBinaryResolver
as described here: https://github.com/opentable/otj-pg-embedded#postgres-version
In case it helps... I downloaded the Postgres binaries directly from the EDB website and they seg fault for me when I run them directly from command line (without using Opentable Embedded Posgtres) on macOS 12.0.1, so that seems to be where the root cause of the issue is I believe. I tried the binaries from:
- http://get.enterprisedb.com/postgresql/postgresql-10.6-1-osx-binaries.zip - which is what is in the repack-postgres.sh script in this repo
- http://get.enterprisedb.com/postgresql/postgresql-10.18-1-osx-binaries.zip - I tried these binaries as well since the Enterprise DB website claims that version 10.18 is still supported on Mac OS, see: https://content-www.enterprisedb.com/downloads/postgres-postgresql-downloads
But I get the following when I try to run the binary:
./postgres [1] 19003 segmentation fault ./postgres
Version 11.13 and 12.8 from http://get.enterprisedb.com/postgresql/postgresql-11.13-1-osx-binaries.zip and http://get.enterprisedb.com/postgresql/postgresql-12.8-1-osx-binaries.zip did seem to work for me:
./postgres -V postgres (PostgreSQL) 11.13
and
./postgres -V postgres (PostgreSQL) 12.8
So a couple of options would be to:
- Update this project to use Postgres 11.13 or 12.8 (or later presumably) and release a new version
- Customize Embedded Postgres to use a custom version of Postgres using
PgBinaryResolver
as described here: https://github.com/opentable/otj-pg-embedded#postgres-version
Huge help - many thanks, Scott.
Sorry the notifications from this thread was lost among others. But yeah we ended up using version 11.13 for macOS 12.0.1. We forked this repo and did an internal release with the newer PG versions from EDB.
Hi there, I have the same error with macOS 12.1 (21C52)
and pgsql-10.6-1
.
As noted we've released 1.0.0 which is testcontainers based. We expect this resolves the issue, and while PRs are welcome against the legacy branch, we are not planning on formally maintaining pre-1.xx code base.
Seeing error zsh: segmentation fault ./pgfutter
when executing ./pgfutter --help
on macOS 12.2.1
More information. Is it pg-embedded 1.0.0+? If not, upgrade. Second, pgfutter is a go app isn't it? So this report seems irrelevant @saurabh-mish. Plus commenting on closed issues will not usually get you assistance ;)