search

Thisislegit / LeonProject

ML-aided Query Optimizer
Other
12 stars 2 forks source link

Missing Data Directory in setup_pg.sh #1

Open Neurotoxin0 opened 1 week ago

Neurotoxin0 commented 1 week ago

Dear Author,

I am attempting to reproduce the LEON experiment, but I encountered an issue in the provided script LEON/setup_pg.sh. Specifically, the command:

./bin/pg_ctl -D ./data restart ./bin/pg_ctl -D ./data1 restart ./bin/pg_ctl -D ./data2 restart

is used to restart three databases (./data, ./data1, and ./data2). However, the data directories do not exist and have not been provided in the repository. I tried to manually create and initialize them, but the setup also requires a role chenx, which is missing. Without this role, I cannot proceed to the next steps of the experiment.

Could you kindly provide guidance or upload the required data directories and role configuration to help me complete the reproduction of the experiment?

Looking forward to your assistance.

Thisislegit commented 1 week ago

Hi, the script we provide has some personal absolute paths and configurations. The data directory is generated by PostgreSQL (You can initialize your own database by ./initdb -D /path/to/your/dir). For the role, it is also PostgreSQL configuration, you can change to postgres or any other role by specifying -U option.