ro access for lars to postgres PHX slave

RESOLVED FIXED

Status

--
major
RESOLVED FIXED
8 years ago
3 years ago

People

(Reporter: laura, Assigned: jabba)

Tracking

Details

(Reporter)

Description

8 years ago
This is so he can answer queries for release-drivers faster.
(Reporter)

Comment 1

8 years ago
Josh informs me the machine is cunningly named tp-socorro01-master02
(Assignee)

Comment 2

8 years ago
Is access to the machine required or does a postgres user need to be set up? I'm not sure how to do the latter. If that is required, perhaps Josh can help set that up. As far as network-wise, lars can log into sp-admin01.phx1.mozilla.com via ssh and connect to postgres from there.
(Reporter)

Comment 3

8 years ago
Josh, over to you, please!
Assignee: server-ops → jdow
If Lars has a psql client on sp-admin01, he should be able to connect to PostgreSQL from there.  That would be preferrable to logging into the PostgreSQL database server itself for this kind of activity.

That being said, I'd *also* like Lars to have a shell login on the PostgreSQL servers.  He's the only postgresql-skilled full-time Mozilla staff member assigned to the Socorro project, and as such should have a shell login, even if just for emergency use.
(Assignee)

Comment 5

8 years ago
Access works to postgres works now using the breakpad_ro user from sp-admin01 and lars also has a shell account on the db servers.
Status: NEW → RESOLVED
Last Resolved: 8 years ago
Resolution: --- → FIXED
Product: mozilla.org → Infrastructure & Operations
Product: Infrastructure & Operations → Infrastructure & Operations Graveyard
You need to log in before you can comment on or make changes to this bug.