Add Postgres initialization to Vagrant

RESOLVED FIXED in 95

Status

Socorro
Infra
RESOLVED FIXED
4 years ago
4 years ago

People

(Reporter: bramwelt, Assigned: bramwelt)

Tracking

unspecified
x86_64
Linux

Firefox Tracking Flags

(Not tracked)

Details

(Assignee)

Description

4 years ago
There are two problems when booting a new VM related to Postgres:
1) The PATH is not correctly set to include `/usr/psql-9.3/bin`
2) The test role is not created in Postgres

#1 specifically, causes `make bootstrap` to fail as psycopg looks for `pg_config`. When peep fails, none of the downloaded packages are cached and all have to be downloaded again.

Both should be simple changes. #2 specifically should be done exactly as the docs say, but has yet to be added.

#2 - http://socorro.readthedocs.org/en/latest/installation/postgres.html#add-a-new-superuser-account-to-postgresql
(Assignee)

Updated

4 years ago
Assignee: nobody → tbramwell

Comment 1

4 years ago
Commit pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/9df367db8612dcb3d025b470d3d8a1db46b3cdc8
Create psql test role if not exists in Vagrant

Fixes Bug #1038956

Updated

4 years ago
Status: NEW → RESOLVED
Last Resolved: 4 years ago
Resolution: --- → FIXED

Comment 2

4 years ago
Commit pushed to master at https://github.com/mozilla/socorro

https://github.com/mozilla/socorro/commit/878cd6b79c95fb3b937f08621a4789d4c2b63164
Wait for pg_hba to be updated before creating user

Puppet tries to create the postgres test user after postgres has been
initialized, but before pg_hba.conf has been updated and the service
restarted.

Fixes Bug 1038956
(Assignee)

Updated

4 years ago
See Also: → bug 1039762

Updated

4 years ago
Target Milestone: --- → 95
You need to log in before you can comment on or make changes to this bug.