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

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


# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             127.0.0.1/32            md5
# IPv6 local connections:
host    all             all             ::1/128                 md5
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local   replication     postgres                                peer
#host    replication     postgres        127.0.0.1/32            md5
#host    replication     postgres        ::1/128                 md5


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"


Thx Karsten

Rogerio

2016-04-07 6:26 GMT-03:00 Karsten Hilbert <[email protected]>:

> On Wed, Apr 06, 2016 at 10:18:03PM -0300, Rogerio Luz wrote:
>
> > So I finally got to restoring my old v19 database in Mint 17.3, which has
> > gnumed-server 19.6-1  and gnumed-client  1.4.6+dfsg-1 by Ubuntu.
> >
> > The restore script seems to work ok without erros, but when I try to
> > connect I get :
> >
> > Unable to connect to database:
> >
> > PostgreSQL: FATAL:  Peer authentication failed for user "rogluz"
> > DSN: dbname=gnumed_v19 port=5432 user=rogluz password=� sslmode=prefer
>
> This seems to point at pg_hba.conf.
>
> Can you (as rogluz, on the console) do:
>
>         $> psql -d gnumed_v19 -U rogluz
>
> What does your pg_hba.conf look like ?
>
> Karsten
> --
> GPG key ID E4071346 @ eu.pool.sks-keyservers.net
> E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346
>
> _______________________________________________
> Gnumed-devel mailing list
> [email protected]
> https://lists.gnu.org/mailman/listinfo/gnumed-devel
>

_______________________________________________
Gnumed-devel mailing list
[email protected]
https://lists.gnu.org/mailman/listinfo/gnumed-devel