RE: Remote Connection Help

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:

sudo ./configure
make world
su
make install
adduser postgres
mkdir /usr/local/pgsql/data
chown postgres /usr/local/pgsql/data
su - postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start
/usr/local/pgsql/bin/createdb test
/usr/local/pgsql/bin/psql test

Then I set the following environment variables:

LD_LIBRARY_PATH=/usr/local/pgsql/lib
export LD_LIBRARY_PATH

PATH=/usr/local/pgsql/bin:$PATH
export PATH

MANPATH=/usr/local/pgsql/share/man:$MANPATH
export MANPATH

Jason L. Amerson


-----Original Message-----
From: Adrian Klaver <[email protected]> 
Sent: Thursday, November 21, 2019 03:17 PM
To: Jason L. Amerson <[email protected]>; 'Tom Lane' <[email protected]>
Cc: 'Steve Crawford' <[email protected]>; 'PostgreSQL' <[email protected]>
Subject: Re: Remote Connection Help

On 11/21/19 12:07 PM, Jason L. Amerson wrote:
> pg_settings show localhost.

Lets back up a bit and:

1) Show output of ps ax | grep post on Ubuntu machine.

2) Explain how you installed Postgres, source, package and if package from what repo?

> 
> Jason L. Amerson
> 
> 
> -----Original Message-----
> From: Tom Lane <[email protected]>
> Sent: Thursday, November 21, 2019 02:42 PM
> To: Jason L. Amerson <[email protected]>
> Cc: 'Steve Crawford' <[email protected]>; 'Adrian Klaver'
> <[email protected]>; 'PostgreSQL'
> <[email protected]>
> Subject: Re: Remote Connection Help
> 
> "Jason L. Amerson" <[email protected]> writes:
>> Yes "listen_addresses" is not commented. I did notice when I did the
> netstat, for tcp, it was all "127.0.0.1" on various ports including 
> 5432 but I have a listing for tcp6 that has my static IP using port 
> 32305. Would that make a difference?
> 
> Hm, well, *something* is overriding the setting.  What did you find in 
> pg_settings?
> 
> 			regards, tom lane
> 
> 
> 
> 


--
Adrian Klaver
[email protected]