thanks Andreas. After changing ownership of /usr/lib/postgresql to postgres user,
postgres@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@pc:/home/marco$ But now... how to call and use psql? postgres@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@pc:/home/marco$ I guess I'm still missing something... Il giorno mer 18 set 2019 alle ore 12:28 Andreas Joseph Krogh < andr...@visena.com> ha scritto: > På onsdag 18. september 2019 kl. 12:25:05, skrev Marco Ippolito < > ippolito.ma...@gmail.com>: > > Hi Andreas, > if I understand correctly, this is what I've done afterwards: > > postgres@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@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 > andr...@visena.com > www.visena.com > <https://www.visena.com> > >
