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?
- In this command I found from Install the Indexer:
# 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?