Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: Noexisting local cluster is suitable as a default target
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$
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$
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 <andreas@visena.com> ha scritto:
På onsdag 18. september 2019 kl. 12:25:05, skrev Marco Ippolito <ippolito.marco@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 KroghCTO / Partner - Visena ASMobile: +47 909 56 963
Вложения
В списке pgsql-general по дате отправления: