'Solana. Need to export all addresses from the blockchain to the DB

I found a way: https://docs.solana.com/developing/plugins/geyser-plugins OR https://github.com/solana-labs/solana-accountsdb-plugin-postgres

But for this need to deploy the validator with very high requirements https://docs.solana.com/running-validator/validator-reqs

Is it possible to find a dump such a DB?
Or can configure the validator with minimal settings only for create such a DB?

Solution 1:^[1]

You could run a low-spec validator (maybe even from your local machine) just to fetch a snapshot from the network, and once the ledger is populated, use solana-ledger-tool to export all addresses:

$ solana-ledger-tool accounts -l path/to/your/ledger --no-account-data

Here's some sample output:

11111111111111111111111111111111:
  - balance: 0.000000001 SOL
  - owner: 'NativeLoader1111111111111111111111111111111'
  - executable: true
  - slot: 0
  - rent_epoch: 0
  - data_len: 14
AddressLookupTab1e1111111111111111111111111:
  - balance: 0.000000001 SOL
  - owner: 'NativeLoader1111111111111111111111111111111'
  - executable: true
  - slot: 0
  - rent_epoch: 0
  - data_len: 28
BPFLoader1111111111111111111111111111111111:
  - balance: 0.000000001 SOL
  - owner: 'NativeLoader1111111111111111111111111111111'
  - executable: true
  - slot: 0
  - rent_epoch: 0
  - data_len: 36

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Jon C

'Solana. Need to export all addresses from the blockchain to the DB

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]