Re: Postgres on Unix/Debian - seeking "dummies guide"
От | Andrej |
---|---|
Тема | Re: Postgres on Unix/Debian - seeking "dummies guide" |
Дата | |
Msg-id | CACMx3pMgay1ZmvCWEH3VbYkoCYcJgAQ+mZkAe=kxYEAAzOtyuw@mail.gmail.com обсуждение исходный текст |
Ответ на | Postgres on Unix/Debian - seeking "dummies guide" (Damian Carey <jamianb@gmail.com>) |
Список | pgsql-novice |
Hi Damian, What does your pg_hba.conf and and postgres.conf look like? Cheers, Andrej On 11 June 2018 at 17:04, Damian Carey <jamianb@gmail.com> wrote: > Hi all, > > Utter newbie question. There will be no single answer - so if anyone could > just point me in the right direction with a "recipe" I would be most > grateful. > > In summary ... > =========== > - for last 10 years been Windows based with a java desktop accessing Postres > with no issues at all > - currently trying to port the app to Debian > - it's 20+ years since I last used *nix > - After several days - I still can't get the java app on (say) Debian user > "damian" to access the db that is running as Debian user "postgres". > PgAdmin3 works fine from "damian", but not the java app with the same user & > pwds. > - seeking any beginner clues / recipie for the most basic setup to get it > working > - not looking for "best practice", just an effective guide to what would > work for initial dev phase. > > > In more detail ... > ============= > Our distributed Java desktop app uses Postgres as its DB, and has been on > Windows for many years, and that process (dev to deployment) is completely > solid. In the target industry all customers must be on Windows, hence so is > our dev environment. > > My current task is porting to Debian - but it's my first Unix since 1993 > when I played on Solaris - so my familiarity has long gone and I'm fumbling > the basics. For the life of me I can't get the app to get access to the DB. > > For these trials I'm using Debian on VirtualBox. I don't think that would be > relevant. > > I *think* it is only a matter of users, permissions, roles, groups, pwds etc > - but after following 10+ tutorials and 2 days of trying I am officially > struggling. Particularly roles and groups, these are in the tutorials, but > > I just want to get the most basic case working, and I can scale from there. > > 2 Debian users / passwords > - postgres / pgpwd > - damian / mypwd > > DB added to PG > - db name: mydb > - db owner: postgres > > > PostgreSQL installed for user postgres - all good > > for user damian > 1. PgAdmin3 installed and connects to DB nicely > 2. Java app installed and running properly in every way except it is denied > access to the DB > > Even if I use dbuser: "postgres" and dbpwd: "pgpwd" the logs say ... > <logs> > Connection matched pg_hba.conf line 92: "host all all 127.0.0.1/32 md5" > postgres@qdb FATAL: password authentication failed for user "postgres" > postgres@qdb DETAIL: Password does not match for user "postgres". > </logs> > > - What username and password is PG expecting? > - is this expecting a role to be created or something? > > Any clues would be much appreciated. > > Thanks, > -Damian > > > > > -- Please don't top post, and don't use HTML e-Mail :} Make your quotes concise. http://www.georgedillon.com/web/html_email_is_evil.shtml http://www.catb.org/jargon/html/email-style.html
В списке pgsql-novice по дате отправления: