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@ranger:~> sudo /etc/init.d/postgresql11 restart
Restarting PostgreSQL: ok 
 
 

aklaver@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.klaver@aklaver.com