Hi!
I’m trying to set up an indexer in Testnet for searching purposes without having to use API (due to limitation about how many transactions I can search at a time). I have downloaded the binaries file, extract it. But I am currently stuck at the setting up PostgreSQL database part. Here are a few questions I have:
Is it true that I have to create a database, user, role in PostgreSQL prior to run the indexer?
Is there any naming convention I have to follow while creating the above items?
# start with local data directory
$ ./algorand-indexer daemon -P "host=[your-host] port=[your-port] user=[uname] password=[password] dbname=[ledgerdb] sslmode=disable" --algod=~/node/data
# start with networked Algorand node
$ ./algorand-indexer daemon -P "host=[your-host] port=[your-port] user=[uname] password=[password] dbname=[ledgerdb] sslmode=disable" --algod-net="http://[your-host]:[your-port]" ---algod-token="[your-api-token]
what are user name, password? Where do I get these from?
4. Does the indexer file and the node file has to be in the same system user? Or anything about location of the files I should pay attention to?
User and password of the postgresql user you created
with the first option “start with local data directory”, indexer and algod need to be on the same computer and running with the same user (or with compatible users). With the second option, there are no such restrictions: indexer and algod can be run from two different VMs, as long as the indexer VM can access the algod endpoint.
Oh I see. I fixed that an it ran but I got a different problem. It’s about authentication. I do understand pretty much the error’s saying that the password I provided was not right. But I am pretty sure it’s the one I enter when I created the user in psql.
I got this problem trying to install in indexer in a private network before and have never been able to figured out why. What should I do? I have tried to create a different user and put it in the parameter but it did not work.
Also the user I create in Linux system is different from the user I create in psql, is that correct? I am confused because I remember reading somewhere about using ident based authentication and that the Linux user name and role and database in Postgres should be the same. I am not quite familiar with it.
Also another issue has arisen. When I install a new node, set it to be an archival node without doing fast catchup. The node try to download every block that has been generated in the blockchain. My VM memory is currently full now and I cannot stop the node. What should I do? Should I delete the node file and reinstall it in a different way?
