search

dhardestylewis / terrain_aggregator

Workflow to aggregate terrain imagery at scale to a single seamless image dataset
Other
10 stars 3 forks source link

Troubleshoot Stampede2 concurrent PostgreSQL connections #66

Open dhardestylewis opened 2 years ago

dhardestylewis commented 2 years ago

Troubleshoot Stampede2 concurrent PostgreSQL connections

A whole host of questions we need to resolve,

Can't concurrent users with permissions of pgdata getting reset to 700 (u:rwx: read, write, execute for the owner) with every DB restart

dhardestylewis commented 2 years ago

@jeaimehp could you post your related PEARC 2022 poster here, for reference?

dhardestylewis commented 2 years ago

Troubleshoot Stampede2 concurrent PostgreSQL connections

A whole host of questions we need to resolve,

  • including ownership of files in the DB directory,
  • where lockfiles are created,
  • etc

Can't concurrent users with permissions of pgdata getting reset to 700 (u:rwx: read, write, execute for the owner) with every DB restart

@urban011 is this specific to the way I am using PostgreSQL on Stampede2 or is this just a PostgreSQL configuration option issue? https://github.com/Khushbooagarwalhub/PostgreSQL-Singularity

@brentporter mentions might be a config options issue 👇 https://www.mydatahack.com/top-10-configuration-parameters-to-tune-postgresql-for-better-performance/