"Jason L. Amerson" writes:
> I removed both version of PostgreSQL from Ubuntu. I had to delete some
> files manually. I used the repository to install PostgreSQL and then I
> configured it for remote access and now everything works great! I can
> log in from my Windows computers using pgAdmin.
made that much
difference.
Thanks again to everyone,
Jason L. Amerson
-Original Message-
From: Adrian Klaver
Sent: Friday, November 22, 2019 01:11 PM
To: Jason L. Amerson
Cc: 'PostgreSQL'
Subject: Re: Remote Connection Help
On 11/22/19 8:27 AM, Jason L. Amerson wrote:
> Whe
: Re: Remote Connection Help
On 11/22/19 5:40 AM, Jason L. Amerson wrote:
Adrian,
I originally did install PostgreSQL 12 from the repository. Then I
removed it and decided to do it from source. I do have two
postgresql.conf files and two pg_hba.conf files in
Well from your previous post "
: Adrian Klaver
Sent: Friday, November 22, 2019 09:56 AM
To: Jason L. Amerson
Cc: 'PostgreSQL'
Subject: Re: Remote Connection Help
On 11/22/19 5:40 AM, Jason L. Amerson wrote:
> Adrian,
>
> I originally did install PostgreSQL 12 from the repository. Then I
> removed it and d
: 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
o: Jason L. Amerson
Cc: 'Steve Crawford' ; 'PostgreSQL'
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.
What program are you using to SSH into the remote machine?
with no
confirmation or errors.
Jason L. Amerson
-Original Message-
From: Adrian Klaver
Sent: Thursday, November 21, 2019 04:53 PM
To: Jason L. Amerson
Cc: 'Steve Crawford' ; 'PostgreSQL'
Subject: Re: Remote Connection Help
On 11/21/19 1:14 PM, Jason L. Amerson wrote:
> 1) I have attac
.
Jason L. Amerson
-Original Message-
From: Adrian Klaver
Sent: Thursday, November 21, 2019 04:32 PM
To: Jason L. Amerson
Cc: 'Steve Crawford' ; 'PostgreSQL'
Subject: Re: Remote Connection Help
On 11/21/19 1:14 PM, Jason L. Amerson wrote:
> 1) I have attached a screenshot of the out
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
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.
What program are you using to SSH into the remote machine?
It should allow you to copy 'n' paste the screen output without
resorting to screenshots. Text
/local/pgsql/share/man:$MANPATH
> export MANPATH
>
> Jason L. Amerson
>
>
> -Original Message-
> From: Adrian Klaver
> Sent: Thursday, November 21, 2019 03:17 PM
> To: Jason L. Amerson ; 'Tom Lane' <
> t...@sss.pgh.pa.us>
> Cc: 'Steve Crawford' ; 'Po
"Jason L. Amerson" writes:
> pg_settings show localhost.
What I asked you about was the "source" columns.
regards, tom lane
. Amerson
>
>
> -Original Message-
> From: Tom Lane
> Sent: Thursday, November 21, 2019 02:42 PM
> To: Jason L. Amerson
> Cc: 'Steve Crawford' ; 'Adrian Klaver'
> ; 'PostgreSQL'
>
> Subject: Re: Remote Connection Help
>
> "Jason L. Amerson" writes:
> >
: Tom Lane
Sent: Thursday, November 21, 2019 02:42 PM
To: Jason L. Amerson
Cc: 'Steve Crawford' ; 'Adrian Klaver'
; 'PostgreSQL'
Subject: Re: Remote Connection Help
"Jason L. Amerson" writes:
Yes "listen_addresses" is not commented. I did notice when I did the
netstat,
pg_settings show localhost.
Jason L. Amerson
-Original Message-
From: Tom Lane
Sent: Thursday, November 21, 2019 02:42 PM
To: Jason L. Amerson
Cc: 'Steve Crawford' ; 'Adrian Klaver'
; 'PostgreSQL'
Subject: Re: Remote Connection Help
"Jason L. Amerson" wri
. Amerson
-Original Message-
From: Tom Lane
Sent: Thursday, November 21, 2019 02:53 PM
To: Mark Johnson
Cc: Jason L. Amerson ; Steve Crawford
; Adrian Klaver ;
PostgreSQL
Subject: Re: Remote Connection Help
Mark Johnson writes:
> As I recall, if the listening address is set to '*'
Mark Johnson writes:
> As I recall, if the listening address is set to '*' but is showing
> localhost, then the problem you describe is likely due to missing an IPv6
> address in pg_hba.conf.
No, the contents of pg_hba.conf don't directly impact the listen_addresses
setting. Also, if that's
merson
Cc: Tom Lane ; Steve Crawford
; Adrian Klaver ;
PostgreSQL
Subject: Re: Remote Connection Help
As I recall, if the listening address is set to '*' but is showing localhost,
then the problem you describe is likely due to missing an IPv6 address in
pg_hba.conf. For me, I just ad
"Jason L. Amerson" 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,
sage-
> From: Tom Lane
> Sent: Thursday, November 21, 2019 01:18 PM
> To: Jason L. Amerson
> Cc: 'Steve Crawford' ; 'Adrian Klaver' <
> adrian.kla...@aklaver.com>; 'PostgreSQL' <
> pgsql-general@lists.postgresql.org>
> Subject: Re: Remote Connection Help
>
al Message-
From: Tom Lane
Sent: Thursday, November 21, 2019 01:18 PM
To: Jason L. Amerson
Cc: 'Steve Crawford' ; 'Adrian Klaver'
; 'PostgreSQL'
Subject: Re: Remote Connection Help
"Jason L. Amerson" writes:
> I connected to PostgreSQL locally. I ran “show listen_addresses;”
"Jason L. Amerson" writes:
> I connected to PostgreSQL locally. I ran “show listen_addresses;” and it
> returned “localhost.” I ran “show port;” and it returned “5432.” I am now
> confused. I edited the “postgresql.conf” file and change the setting to ‘*’.
> Then I restarted the server with
.”
Jason L. Amerson
From: Steve Crawford
Sent: Thursday, November 21, 2019 12:05 PM
To: Jason L. Amerson
Cc: Adrian Klaver ; PostgreSQL
Subject: Re: Remote Connection Help
On Thu, Nov 21, 2019 at 8:48 AM Jason L. Amerson mailto:drja...@alphagenius.org> > wrote:
1
On Thu, Nov 21, 2019 at 8:48 AM Jason L. Amerson
wrote:
> 1) I am not sure if Postgres server is listening on port 5432. How do I
> check?
>
> 2) I have tried "psql -h xx.xx.xx.xx" and "psql -h xx.xx.xx.xx -U
> postgres."
> I even tried to telnet to it using the static IP and port 5432 but it
using the static IP with SSH.
3) It is my own physical machine. It is running Ubuntu and has a static IP.
Jason L. Amerson
-Original Message-
From: Adrian Klaver
Sent: Thursday, November 21, 2019 11:11 AM
To: Jason L. Amerson ; 'PostgreSQL'
Subject: Re: Remote Connection Help
On 11/21
On 11/21/19 7:15 AM, Jason L. Amerson wrote:
Steve,
I cannot connect to the server by “psql -h xx.xx.xx.xx.” I can connect
to my Ubuntu machine from other computers using SSH and I can connect to
PostgreSQL if I SSH first. But I cannot connect directly to PostgreSQL
either through a client
Ubuntu machine.
Jason L. Amerson
From: Steve Atkins
Sent: Thursday, November 21, 2019 09:49 AM
To: pgsql-general@lists.postgresql.org
Subject: Re: Remote Connection Help
On 21/11/2019 14:30, Ekaterina Amez wrote:
El 21/11/19 a las 15:21, Jason L. Amerson escribió:
I am
Steve,
I cannot connect to the server by "psql -h xx.xx.xx.xx." I can connect to my
Ubuntu machine from other computers using SSH and I can connect to
PostgreSQL if I SSH first. But I cannot connect directly to PostgreSQL
either through a client machine or if I run "psql -h xx.xx.xx.xx"
On 21/11/2019 14:30, Ekaterina Amez wrote:
El 21/11/19 a las 15:21, Jason L. Amerson escribió:
I am at a loss for what to do. I have read article after article
about how to allow remote connections on my PostgreSQL server and
none of what the articles say do, worked for me. I have edited
El 21/11/19 a las 15:21, Jason L. Amerson escribió:
I am at a loss for what to do. I have read article after article about
how to allow remote connections on my PostgreSQL server and none of
what the articles say do, worked for me. I have edited the
“postgresql.conf” file and changed
30 matches
Mail list logo