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

verdi presto failed to connect to the PostgreSQL on custom port #6669

Open
superstar54 opened this issue Dec 16, 2024 · 0 comments
Open

verdi presto failed to connect to the PostgreSQL on custom port #6669

superstar54 opened this issue Dec 16, 2024 · 0 comments
Labels

Comments

@superstar54
Copy link
Member

superstar54 commented Dec 16, 2024

I tried to set up a profile using verdi presto, and my Postgres's port is 5433, and I specified the 5433 as input, but it failed to connect. From the message, it seems that it still try to connect using the default port 5432.

$ verdi presto -p nano --use-postgres
Trying to become 'postgres' user. You may be asked for your 'sudo' password.
psql: error: could not connect to server: No such file or directory
        Is the server running locally and accepting
        connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

Unable to autodetect postgres setup.
Please provide PostgreSQL connection info:
postgres host [localhost]: 
postgres port [5432]: 5433
postgres super user [postgres]: 
database [template1]: nano
postgres password of {dsn_new["user"]} []: 
Trying to become 'postgres' user. You may be asked for your 'sudo' password.
psql: error: FATAL:  database "nano" does not exist

Unable to autodetect postgres setup.
Critical: Failed to connect to the PostgreSQL server using parameters: {'host': 'localhost', 'port': 5432, 'user': 'postgres', 'password': None}

Note: using $ verdi quicksetup works.

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

No branches or pull requests

1 participant