[
{ type: install
  message: <<EOM
/!\ This FreeBSD package REQUIRES postgresql DB to be initialized   /!\
/!\ as per the following example for the software to function       /!\

If starting with a fresh postgresql install:
service postgresql initdb
service postgresql start
service cardano_db_sync onefetch

To create a new database, this example uses "root" username for Cardano "mainnet".
Replace all instances of "mainnet" with "preview" or "preprod" for testnet setup.

su postgres
createuser --createdb --superuser root
exit

Next, setup pgpass file:
export PGPASSFILE=/var/db/cardano_db_sync/mainnet-configs/.pgpass
or
setenv PGPASSFILE /var/db/cardano_db_sync/mainnet-configs/.pgpass
echo "/tmp/:5432:cexplorer:*:*" > $PGPASSFILE
chmod 0600 $PGPASSFILE

Create the "cexplorer" database:
cardano-db-sync-pgsql-setup --createdb

Restore the database from a snapshot ( or skip this step to sync from genesis ):
IOG Repo - Mainnet: https://update-cardano-mainnet.iohk.io/cardano-db-sync/index.html#13.1/
IOG Repo - Testnet: https://updates-cardano-testnet.s3.amazonaws.com/cardano-db-sync/index.html
Koios Repo: https://snapshots.koios.rest/cardano-db-sync/
( Koios repo usually has extra indexes and fresh syncs from genesis )

fetch https://XXXX/cardano-db-sync/13.1/db-sync-snapshot-schema-XX.X-block-XXXXXXX-XXXX.tgz

cardano-db-sync-pgsql-setup --restore-snapshot db-sync-snapshot-schema-XX.X-block-XXXXXXX-XXXX.tgz /var/db/cardano_db_sync/mainnet-state/

EOM
}
{ type: upgrade
  message: <<EOM
If doing a major version upgrade ( ex. 13.0.0 to 14.0.0 ) you should drop
the current database and re-create it, as there will be breaking changes:

setenv PGPASSFILE /var/db/cardano_db_sync/mainnet-configs/.pgpass
cardano-db-sync-pgsql-setup --recreatedb

EOM
}
]