On Tue, Jan 9, 2018 at 3:48 AM, Agnar Renolen <agnar.reno...@gmail.com> wrote:
> I have just installed PostGIS (Postgres9.6) on a Debian server using > apt-get. > > But I have problems doing anything: > > I installed as root, but trying doing things as my local user "me" > > me> createuser me > createuser: could not connect to database postgres: FATAL: role "me" does > not exist > > Then, trying the same as root, but gettinge the same result. > > root> createuser me > createuser: could not connect to database postgres: FATAL: role "root" > does not exist > > Then trying with the -U postgres option. > > root> createuser -U postgres me > createuser: could not connect to database postgres: FATAL: Peer > authentication failed for user "postgres" > > How do I get started? > It's been a long time for me, but as I recall, I did something like: me$ sudo su - # change to root root# su - postgres # change to postgres user postgres$ createuser -s me #create "me" postgres$ exit # go back to root root# exit # go back to me me$ createdb me # create my default database In /var/lib/pgsql/data/pg_hba.conf , I have lines like: # TYPE DATABASE USER ADDRESS METHOD # "local" is for Unix domain socket connections only local all all trust # IPv4 local connections: host all all 127.0.0.1/32 trust # IPv6 local connections: host all all ::1/128 trust -- I have a theory that it's impossible to prove anything, but I can't prove it. Maranatha! <>< John McKown
