RE: Remote Connection Help

I am start/stopping the server by using sudo service postgresql start/stop/restart/status. When I run any of these commands, I do not get anything. No confirmation, except for the status, it does show the server is running. But otherwise, all I see is that it just goes to a new line with no confirmation or errors.

Jason L. Amerson

-----Original Message-----
From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Sent: Thursday, November 21, 2019 04:53 PM
To: Jason L. Amerson <drjason(at)alphagenius(dot)org>
Cc: 'Steve Crawford' <scrawford(at)pinpointresearch(dot)com>; 'PostgreSQL' <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Remote Connection Help

On 11/21/19 1:14 PM, Jason L. Amerson wrote:
> 1) I have attached a screenshot of the output of "ps ax | grep post" on the Ubuntu machine.
>
> 2) Since I was new to PostgreSQL, I followed a tutorial online. I did install from source which I already knew how to do. I got the source package from PostgreSQL. I basically followed these instructions:
>

Additional questions that came to mind:

1) How are you starting/stopping server?

2) What do you see on the terminal when you restart the server? I see:

aklaver(at)ranger:~> sudo /etc/init.d/postgresql11 restart Restarting PostgreSQL: ok

aklaver(at)ranger:~> -2019-11-21 13:49:30.104 PST-0LOG: listening on IPv6 address "::1", port 5432

-2019-11-21 13:49:30.104 PST-0LOG: listening on IPv4 address
"127.0.0.1", port 5432

-2019-11-21 13:49:30.193 PST-0LOG: listening on Unix socket
"/tmp/.s.PGSQL.5432"

-2019-11-21 13:49:30.322 PST-0LOG: redirecting log output to logging
collector process

-2019-11-21 13:49:30.322 PST-0HINT: Future log output will appear in
directory "log".

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