Absence of `make_apdb.py` in v29.2.0

Hi,

During our upgrade from LSST Science Pipelines v24 to v29.2.0, we’ve been updating our alert production and source association workflow.

In v24, we created the APDB (Alert Production Database) using:

make_apdb.py -c db_url="postgresql://User:Password@ip/ap"

This worked well in the older version.

However, in v29.2.0, we find that the make_apdb.py script is no longer available.

Could you please let us know if this script has been deprecated or replaced?
Is there a new recommended way to set up the APDB in this version?

Thank you for your guidance!

The new command is apdb-cli. Using your example, the syntax is:
apdb-cli create-sql postgresql://User:Password@ip/ap apdb_config.yaml. If you have a postgres namespace you want to use such as myNamespace, you can use apdb-cli create-sql --namespace myNamespace postgresql://User:Password@ip/ap apdb_config.yaml
Either way, set -c parameters:apdb_config=apdb_config.yaml to configure the AP pipeline.

2 Likes

Thank you very much for the clear guidance!

Following your suggestion, we successfully created the APDB tables.

Your support is greatly appreciated!