Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Installation problem #65

Open
ElvinGuluzade opened this issue Aug 24, 2023 · 4 comments
Open

Installation problem #65

ElvinGuluzade opened this issue Aug 24, 2023 · 4 comments
Labels
question Further information is requested

Comments

@ElvinGuluzade
Copy link

Hi, I am working in a Virtual machine on the adress xx.xx.xx.25 and I have installed this extension going over the steps provided in the readme file. However in the last stage when I run CREATE EXTENSION pg_ivm; I get an error indicating the pg_ivm.control does not exist. But when I check the path mentioned in the error, there are a few files like pg_ivm--1.0--1.1.sql pg_ivm--1.0.sql pg_ivm--1.1--1.2.sql pg_ivm--1.2--1.3.sql pg_ivm--1.3--1.4.sql pg_ivm--1.4--1.5.sql pg_ivm.control. Why would the pg_ivm.control not be available? My first instinct is that, the database I am trying to install and implement the extension to is in another server and when it tries to locate the control file, it cannot access the file in the virtual machine.

@yugo-n yugo-n added the question Further information is requested label Aug 24, 2023
@yugo-n
Copy link
Collaborator

yugo-n commented Aug 27, 2023

My first instinct is that, the database I am trying to install and implement the extension to is in another server and when it tries to locate the control file, it cannot access the file in the virtual machine.

I guess your instinct is right. If the machine you installed pg_ivm is different than the machine on which your database is working, the error will be raised. You have to install pg_ivm on the machine where PostgreSQL is installed after setting PATH to pg_config of the appropriate PostgreSQL .

@ElvinGuluzade
Copy link
Author

Thank you for the answer. Do you mean adding the path of pg_config to the PATH in the environment variables? Or there is another way to set the PATH in the PostgreSQL itself?

@yugo-n
Copy link
Collaborator

yugo-n commented Aug 28, 2023

Do you mean adding the path of pg_config to the PATH in the environment variables?

Yes, I mean adding the path of the directory where pg_config is located to the PATH environment variable.

@ElvinGuluzade
Copy link
Author

Thank you very much.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
question Further information is requested
Projects
None yet
Development

No branches or pull requests

2 participants