btcpayserver: [Bug]: Db Migration, creates table in postgres, but no data is migrated

What is your BTCPay version?

BtcPay v1.7.9

How did you deploy BTCPay Server?

Run from source using dotnet run --no-launch-profile -c Release --project “.\BTCPayServer\BTCPayServer.csproj” --debuglog “C:\debug.log”

What happened?

So I created a postgres blank database “btcpayserver” and user for it Added this to the configuration

postgres=User ID=btcpay;Password=???;Application Name=btcpayserver;Host=127.0.0.1;Port=5432;Database=btcpayserver;

and commented out the “sqlitefile” config

How did you encounter this bug?

Ran btcpay with new postgres config for migration. The tables were created in the postgres database, however no data was migrated. When I access the btc pay server it was like accessing fresh instance, nothing migrated.

Relevant log output

nothing found in log file that suggested migration was running

What browser do you use?

No response

Additional information

No response

Are you sure this is a bug report?

  • I confirm this is a bug report

About this issue

  • Original URL
  • State: closed
  • Created a year ago
  • Comments: 53 (26 by maintainers)

Most upvoted comments

Got you. Thanks for everything, your a rockstar! in the space!

You will be pleased to see this -> info: BTCPayServer.Hosting.ToPostgresMigrationStartupTask: Migration to postgres from SQLite successful

Thank you very much for your time !