Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: No existing local cluster is suitable as a default target

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Marco Ippolito <ippolito(dot)marco(at)gmail(dot)com>, Matthias Apitz <guru(at)unixarea(dot)de>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: No existing local cluster is suitable as a default target
Date: 2019-09-18 14:41:41
Message-ID: 793c3697-dc15-973b-575e-e269cf3b0cad@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 9/18/19 6:13 AM, Marco Ippolito wrote:
> Thanks Matthias,
> very kind. Hopefully I will get some hints on how to solve my problem.

You should probably take a look at:

https://help.ubuntu.com/lts/serverguide/postgresql.html

FYI, you should set the permission son /usr/lib/postgresql back to root
and use:

sudo pg_ctl <command>

>
> Marco
>
> Il giorno mer 18 set 2019 alle ore 15:11 Matthias Apitz
> <guru(at)unixarea(dot)de <mailto:guru(at)unixarea(dot)de>> ha scritto:
>
> El día Wednesday, September 18, 2019 a las 12:44:20PM +0200, Marco
> Ippolito escribió:
>
> > thanks Andreas.
> >
> > After changing ownership of /usr/lib/postgresql to postgres user,
> >
> > postgres(at)pc:/home/marco$ /usr/lib/postgresql/11/bin/pg_ctl -D
> > /usr/local/pgsql/data -l /usr/lib/postgresql/11/log/logfile start
> > waiting for server to start.... done
> > server started
> > postgres(at)pc:/home/marco$
> >
> > But now... how to call and use psql?
>
> Marco, I compiled 11.4 on Linux for our needs and wrote a Confluence
> page about this and the cluster setup. I could send you this pages
> in PDF off-list.
>
>         matthias
> --
> Matthias Apitz, ✉ guru(at)unixarea(dot)de <mailto:guru(at)unixarea(dot)de>,
> http://www.unixarea.de/ +49-176-38902045
> Public GnuPG key: http://www.unixarea.de/key.pub
> May, 9: Спаси́бо освободители! Thank you very much, Russian liberators!
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marco Ippolito 2019-09-18 14:44:16 Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: No existing local cluster is suitable as a default target
Previous Message Adrian Klaver 2019-09-18 14:31:16 Re: Pg_auto_failover