Project

General

Profile

action #6058

Run migrations with the right user in the package

Added by ancorgs over 8 years ago. Updated over 8 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
Concrete Bugs
Target version:
Start date:
2015-01-27
Due date:
% Done:

0%

Estimated time:
Difficulty:

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.

History

#1 Updated by coolo over 8 years ago

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

#2 Updated by ancorgs over 8 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.

#3 Updated by coolo over 8 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

#5 Updated by coolo over 8 years ago

  • Category set to Concrete Bugs
  • Status changed from New to Resolved

fixed in the package

Also available in: Atom PDF