This is so he can answer queries for release-drivers faster.
Josh informs me the machine is cunningly named tp-socorro01-master02
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.
Josh, over to you, please!
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.
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.