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

Startup error when using postgres as database #359

Open
yukoDotMoe opened this issue Apr 9, 2022 · 2 comments
Open

Startup error when using postgres as database #359

yukoDotMoe opened this issue Apr 9, 2022 · 2 comments

Comments

@yukoDotMoe
Copy link

Current setup
Ubuntu 18.04

Step of reproduce
NBX built from source using provided instruction
My settings.config :

btc.rpc.auth=<username>:<password>
port=24445
mainnet=1
postgres=User ID=<username>;Password=<password>;Host=localhost;Port=5432;Database=nbxplorer

The error I got
(But using --dbtrie still working like normal)

info: NBXplorer.DatabaseSetup: Postgres services activated
info: NBXplorer.DatabaseSetup: Execute script 001.Migrations...
info: NBXplorer.DatabaseSetup: Execute script 002.Model...
Unhandled exception. Npgsql.PostgresException (0x80004005): 42601: syntax error at or near "INCLUDE"

image

Thanks for reading and hope you guys can help me out since I'll use postgres as database in my production env.

@NicolasDorier
Copy link
Member

NicolasDorier commented Apr 23, 2022

What version is your postgres database? we support from Postgres 11. (we depend on covering index)
Postgres 13 or more recommended as we depend on incremental sort for performance on some requests.

@ktfth
Copy link

ktfth commented Sep 17, 2022

@NicolasDorier I have a similar issue, but to connect to postgres, the connection has been refused. Have a suggestion to run the project? I'm using Windows as development environment, but planning to deploy on a Linux machine.

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

No branches or pull requests

3 participants