search

ankane / dexter

The automatic indexer for Postgres
MIT License
1.9k stars 47 forks source link

Installation via package does not work #26

Closed alexanderadam closed 6 years ago

alexanderadam commented 6 years ago

First of all: dexter is awesome! I like the idea and how it's done. This is wonderful! So thank you for dexter.

I tried to install dexter within the official Postgres Docker container and everything went fine until I actually tried to run dexter. It resulted in an error that looks a bit like a old bundler error:

screenshot_20180321_152302

I "solved" it by installing it via the traditional way (current ruby + rubygems) and everything went fine. So I guess that the binary packages don't run flawlessly on every system.

ankane commented 6 years ago

Hey @alexanderadam, thanks for another report 👍 Which platform are you on? My guess is the package is missing a dependency for that platform.

alexanderadam commented 6 years ago

It's the official Postgres 9.4 Docker container (Debian Jessie).

ankane commented 6 years ago

Hey @alexanderadam, I'm unable to repro. Can you share the Dockerfile you're using?

alexanderadam commented 6 years ago

I did not create a separate Dockerfile. I just used the linked one and executed this within the container for development purposes:

apt update && apt install curl build-essentials build-essential wget apt-transport-https git postgresql-server-dev-9.4
curl -L https://dl.packager.io/srv/pghero/dexter/key | sudo apt-key add -
wget -O /etc/apt/sources.list.d/dexter.list https://dl.packager.io/srv/pghero/dexter/master/installer/debian/9.repo
wget -O /etc/apt/sources.list.d/dexter.list https://dl.packager.io/srv/pghero/dexter/master/installer/debian/8.repo
apt update && apt install dexter

cd /tmp
git clone https://github.com/HypoPG/hypopg.git
cd hypopg
make && make install

Then I activated the query log and tailed it into dexter (but calling dexter with credentials failed in general).

ankane commented 6 years ago

Any reason you're installing the Debian 9 package instead of just 8? The following works fine for me with the postgres:9.4 image:

apt update && apt install curl build-essential wget apt-transport-https git postgresql-server-dev-9.4
curl -L https://dl.packager.io/srv/pghero/dexter/key | apt-key add -
wget -O /etc/apt/sources.list.d/dexter.list https://dl.packager.io/srv/pghero/dexter/master/installer/debian/8.repo
apt-get update
apt-get install dexter
alexanderadam commented 6 years ago

Oh, that was indeed by accident. My fault, sorry. 😳