Postgres Pro
Downloads
Home   >   mailing lists

Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: Noexisting local cluster is suitable as a default target - Mailing list pgsql-general

From Marco Ippolito
Subject Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: Noexisting local cluster is suitable as a default target
Date
Msg-id CAFegzBQ-mO076Xrs7KSLeZCDXw3JzA6R3kTm4y1W64zDGDnrvg@mail.gmail.com
Whole thread Raw
In response to Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: No existing local cluster is suitable as a default target  (Andreas Joseph Krogh <andreas@visena.com>)
Responses Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: Noexisting local cluster is suitable as a default target
List pgsql-general
Tree view
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 <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 Krogh
CTO / Partner - Visena AS
Mobile: +47 909 56 963
 
Attachment

pgsql-general by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Re: Installed PostgreSQL-11 in Ubuntu 18.04.02 Server Edition: No existing local cluster is suitable as a default target
Next
From: David Steele
Date:
Subject: Re: pgbackrest restore to new location?