Skip to main content

Questions tagged [postgres]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
53 views

Stellar postgres errors: canceling statement due to user request

I am using Stellar (mainnet) and after latest update got errors in postgresql: canceling statement due to user request UTC [64] STATEMENT: delete from history_assets where id IN (select id from (...
Roman's user avatar
  • 1
1 vote
1 answer
143 views

How to stop evergrowing disk usage by Stellar node

Disk usage is growing steadily and we cannot find the solution. There are two questions from about 2-3 years ago: Stop Horizon/Stellar node growing disk usage Pruning and keeping disk usage low But in ...
hotbit's user avatar
  • 131
1 vote
0 answers
35 views

Problems when running on ClearOS7/Centos7

In order to get stellar-core running on ClearOS7 (binary compatible with Centos7), I have had to use postgresql from one of the SCLo repos (Special interest groups) as the normal Centos version of ...
NickH's user avatar
  • 31
0 votes
1 answer
192 views

How to set up a anchor on stellar?

As I working on stellar Blockchain, can anyone guide me on how to create an anchor on stellar? and How it will give a withdraw amount in fiat currency & which protocol is it used to convert ...
Isha Padalia's user avatar
0 votes
1 answer
220 views

Connection refused error in Horizon

Launching Horizon with stellar/quickstart docker image: horizon db init --db-url postgres://stellar:[email protected]:5432/core --stellar-core-db-url postgres://stellar:[email protected]:5432/...
Denizhan Şahin's user avatar
1 vote
0 answers
38 views

(Install Error) Package stellar-horizon-postgres is not configured yet

1- I cannot install stellar horizon it gives an error. I tried this solution https://stellar.stackexchange.com/a/2400 but it didn't work. 2- I tried this solution https://github.com/stellar/packages/...
Emin's user avatar
  • 11
0 votes
1 answer
129 views

How to setup an anchor in Stellar network using Windows?

While there is a great deal of documentation on installing the packages, however, I couldn't follow it properly to install the stellar-core, horizon and Postgres database in windows. There is not ...
Sufi Shah Hamid Jalali's user avatar
0 votes
1 answer
242 views

Getting up and running with a Stellar-Core and Horizon with a Database

I am new to the Stellar world and wanted to set up a node (Stellar Core, Horizon and a Database) for the first time to run as an anchor. However, I couldn't figure it out from the documentation how to ...
Sufi Shah Hamid Jalali's user avatar
1 vote
1 answer
177 views

How to provide password when running horizon db migrate up command inside docker container?

I have issues with horizon, when inside the docker container I run horizon db clear and I get the output There are 18 migrations to apply in the "up" direction. ... 2019/06/20 10:44:26 A database ...
John Murphy's user avatar
1 vote
0 answers
93 views

postgres PANI[0000] connect failed: pq: role "root" does not exist pid=13863, postgres v 9.5 - Horizon

Getting below error when trying to connect to postgres (trying to start Horizon) PANI[0000] connect failed: pq: role "root" does not exist pid=13863 panic: (*logrus.Entry) (0xbcb320,0xc4200112c0) ...
sweta's user avatar
  • 239
3 votes
0 answers
58 views

Change stellar quickstart docker from ephemeral to persistent without shutting it down

I made the mistake of running my Stellar instances with the -v "/home/Drew/XCoin:/Drew/XCoin" flags instead of the required -v "/home/Drew/stellar:/opt/stellar"flags that Stellar recommends on the ...
Drew Patel's user avatar
2 votes
1 answer
244 views

Core breaks after upgrade to 10.0.0

After upgrading both Horizon and Core to new stable versions, I can no longer get stellar-core to start. before: ENV STELLAR_CORE_VERSION 9.2.0-551-7561c1d5 ENV HORIZON_VERSION 0.13.1 after: ENV ...
relik's user avatar
  • 315
7 votes
2 answers
461 views

Lost ledger data: what is the proper way to shutdown and restart a node?

I had to restart Docker Engine, and I stopped the services by attaching to the container and issuing ctrl+c. It was in the process of downloading ledger files, and I thought that it would pick up from ...
relik's user avatar
  • 315
2 votes
1 answer
415 views

FATAL when switching from test network to public network on stellar-core

My question is about transitioning from the test-network to the public network. I am curious about whether there is a standard procedure to follow, not only in terms of configuration, but also in ...
M.Bradascio's user avatar
5 votes
1 answer
164 views

Could not complete "horizon db init" exec failed: pq: unrecognized configuration parameter "lock_timeout"

I get the following error on running the command - horizon db init. My Horizon install is compiled from the source for CentOS 7 following https://www.stellar.org/developers/horizon/reference/admin....
Sivaji's user avatar
  • 155
2 votes
1 answer
109 views

How to connect to peers/store into account/accountdata tables when running stellar-core on windows?

I set up stellar-core on windows following the windows installation instructions. I was able to build the solution successfully and am able to run "stellar-core" from the command line. I've set up a ...
Jarret's user avatar
  • 121