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

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?

postgres(at)pc:/home/marco$ psql
Warning: No existing local cluster is suitable as a default target. Please
see man pg_wrapper(1) how to specify one.
Error: You must install at least one postgresql-client-<version> package
postgres(at)pc:/home/marco$

I guess I'm still missing something...

Il giorno mer 18 set 2019 alle ore 12:28 Andreas Joseph Krogh <
andreas(at)visena(dot)com> ha scritto:

> På onsdag 18. september 2019 kl. 12:25:05, skrev Marco Ippolito <
> ippolito(dot)marco(at)gmail(dot)com>:
>
> Hi Andreas,
> if I understand correctly, this is what I've done afterwards:
>
> postgres(at)pc:/home/marco$ /usr/lib/postgresql/11/bin/pg_ctl -D
> /usr/local/pgsql/data -l logfile start
> waiting for server to start..../bin/sh: 1: cannot create logfile:
> Permission denied
> stopped waiting
> pg_ctl: could not start server
> Examine the log output.
> postgres(at)pc:/home/marco$
>
> What am I doing wrong?
>
>
> You don't have permissions to create the logfile (named "logfile" in your
> command) in CWD (/home/macro). Specify absolute path to somewhere writable
> for user "postgres".
>
> --
> *Andreas Joseph Krogh*
> CTO / Partner - Visena AS
> Mobile: +47 909 56 963
> andreas(at)visena(dot)com
> www.visena.com
> <https://www.visena.com>
>
>