Project

General

Profile

Actions

action #6058

closed

Run migrations with the right user in the package

Added by ancorgs about 9 years ago. Updated about 9 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
Regressions/Crashes
Target version:
Start date:
2015-01-27
Due date:
% Done:

0%

Estimated time:

Description

Make sure migrations are run with the geekotest user in the package, so it works with both SQLite and PostgreSQL using "peer" as authentication method.

Actions #1

Updated by coolo about 9 years ago

initdb and upgradedb change users in case they are SQlite, but don't if postgresql. So we need to add it there.

Actions #2

Updated by ancorgs about 9 years ago

I'm not so sure because it will only work for a local PostgreSQL server using "peer" as authentication method and geekotest as user. That is just a concrete configuration from the many many possible ones... and most likely not the one used in big deployments in which the database server is usually in another machine.

Actions #3

Updated by coolo about 9 years ago

but geekotest is the user running all other DB tasks - so he's able to connect to postgresql in the context of openqa daemon, he should also be able to connect to postgresql in the context of migrations

Actions #5

Updated by coolo about 9 years ago

  • Category set to Regressions/Crashes
  • Status changed from New to Resolved

fixed in the package

Actions

Also available in: Atom PDF