[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04 |
Date: |
Tue, 12 Apr 2016 16:06:14 +0200 |
User-agent: |
Mutt/1.5.24 (2015-08-30) |
Hi Rogerio !
> > got this after bootstrap of a new gnumed_v19 in a NEW main cluster(after
> >pg_dumpcluster / pg_createcluster)
> >
> > List of databases
> > Name | Owner | Encoding | Collate | Ctype | Access
> >privileges
> >------------+----------+----------+-------------+-------------+-----------------------
> > gnumed_v18 | gm-dbo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
> > gnumed_v19 | gm-dbo | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
> > postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 |
> > template0 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
> > +
> > | | | | |
> >postgres=CTc/postgres
> > template1 | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
> > +
> > | | | | |
> > postgres=CTc/postgres
> > (5 rows)
>
> Looks spot on. First things would be to
>
> - re-check pg_hba.conf for the proper position of the "samerole gm-logins
> md5" line
> - dropdb gnumed_v19 (because we want to restore)
> - check out whether any password is set for gm-dbo:
> psql -d gnumed_v18 -U gm-dbo
> - if an unknown password is set, reset it to something known
> connect as user postgres
> alter role 'gm-dbo' encrypted password 'your-new-password';
> - try connecting as gm-dbo
> - try connecting as any-doc (default password should be any-doc)
>
> and check back here.
Any news ? Help needed ?
Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
- [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04, Rogerio Luz Coelho, 2016/04/06
- Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04, Karsten Hilbert, 2016/04/07
- Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04, Rogerio Luz Coelho, 2016/04/07
- Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04, Rogerio Luz Coelho, 2016/04/07
- Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04, Karsten Hilbert, 2016/04/08
- Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04, Rogerio Luz Coelho, 2016/04/08
- Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04, Karsten Hilbert, 2016/04/09
- Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04, Karsten Hilbert, 2016/04/09
- Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04, Rogerio Luz Coelho, 2016/04/09
- Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04, Karsten Hilbert, 2016/04/09
- Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04,
Karsten Hilbert <=
- Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04, Rogerio Luz Coelho, 2016/04/23
- Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04, Karsten Hilbert, 2016/04/24
- Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04, Rogerio Luz Coelho, 2016/04/26
- Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04, Karsten Hilbert, 2016/04/27
- Re: [Gnumed-devel] Having trouble with gm-restore_database in Mint 17.3 ... Ubuntu 14.04, Karsten Hilbert, 2016/04/08