Re: Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04

On Thu, Apr 07, 2016 at 10:50:59PM -0300, Rogerio Luz wrote:

> pg_hba.conf:
> 
> A whole lot of TEXT ... bla bla bla
> 
> #
> #
> # Database administrative login by Unix domain socket
> local   all             postgres                                peer
> 
> # TYPE  DATABASE        USER            ADDRESS                 METHOD
> # allow anyone knowing the proper password to log into our GNUmed databases:
> local   samegroup      +gm-logins                md5

So far so good.

> I have to to a: sudo -u postgres sudo psql -d gnumed_v19 -U rogluz
> as 'rogluz' is not a normal user in my system.
> results in:
> psql: FATAL:  Peer authentication failed for user "rogluz"

Likely, "rogluz" (inside PostgreSQL) isn't part of the group
"gnumed_v19".  How did you (re)create the users and groups ? 
The backup should have included a file containing the roles
needed. Which needs to be restored, too, after careful
scrutiny.

Karsten
-- 
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346