Develop a "dummies guide" for Debian user apps to have full access to PostgreSQL
$30-250 AUD
Paid on delivery
Hi.
Background…
We have a Java application that uses PostgreSQL to access several DBs. Currently all customers use Windows, so our whole dev and distribution is based on Windows. This works perfectly for us. These Java apps are typically on localhost, but may be elsewhere on the LAN.
My current task is to port our application (Java & PostgreSQL) to Debian.
- Currently I am using VirtualBox 5.2.12 and can run Debian 9, and PostgreSQL 10.
- As a normal Debian user I can access everything I want using pgAdmin 3.
- However, our Java app can't access any database.
I have spent too many hours trialing, following tutorials, asking on the user groups etc, but I do not have the Linux/Debian or PostgreSQL admin skills to get this going with the appropriate logins, usernames, passwords, roles, permissions etc.
Your task is to develop a canonical procedure (ie "a dummies guide") with every required baby step that assumes no Debian, Linux or Postgres pre-knowledge.
- the outcome is a detailed step-by-step procedure
- when I follow your procedure then my java application (not pgAdmin3 or psql etc) using only a username ("pguser") and password ("pguserpwd") has full access rights to the PostgreSQL server so that it can create, drop, read write to any database on that server.
- start with a fresh Debian installation (probably 9 stretch)
- create a Debian user "debuser" with password "debpwd"
- install PG (presumably 10?)
- make all required changes to postgres users, roles, [login to view URL], [login to view URL] etc
- work from local host or any specified IP
- it must use "out-of-the-box" Debian tools & commands etc
- I would like you to do this in VirtualBox, so you can also advise how to install "virtualbox-guest-additions" onto the Debian guest (so I can get share folders working)
The task is complete when I can follow your procedure like a robot and my app can access postgres exactly as it can now on Windows.
My outcome is clear. The process to achieve that is negotiable.
Thanks
Project ID: #17178010
About the project
Awarded to:
i curently work for on postgresedb and Linux and my work entails to manage and implement them. I would also love to help you write indetailed steps with screenshots if required for more easier understanding!
3 freelancers are bidding on average $129 for this job
Hi. I've worked with debian from long time ago installing any kind of software without problem. I can write for you a manual with detaileds instructions about your requirements. Open to questions