"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. Tha
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
'
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 decided to do it from source. I do have two
postgresql.conf files and two pg_hba.conf files in
Well from your prev
: 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 i
eSQL'
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 alr
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 output of "ps ax | grep post" on the
Ubuntu machine.
What program are you using t
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:
&g
.
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 s
Il 21/11/19 22:40, Peter J. Holzer ha scritto:
On 2019-11-21 17:27:04 +0100, Moreno Andreo wrote:
Connection refused means somthing has blocked it. If it was all OK and simply
Postgres was not listening, you should've received a "connection timed out"
(10060) message.
Almost exactly the other w
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
Post
On 2019-11-21 17:27:04 +0100, Moreno Andreo wrote:
> Connection refused means somthing has blocked it. If it was all OK and simply
> Postgres was not listening, you should've received a "connection timed out"
> (10060) message.
Almost exactly the other way around. If you try to connect to a port
w
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 is
NPATH=/usr/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: &#
"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. Am
: 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 n
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
&qu
. 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 wher
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
"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, *someth
iginal Message-
> 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>
> S
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
"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 “se
.”
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) I
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 wou
and got nothing.
> iptables is turned off and still nothing.
>
>
>
> Jason L. Amerson
>
>
>
> *From:* Moreno Andreo
> *Sent:* Thursday, November 21, 2019 11:27 AM
> *To:* pgsql-general@lists.postgresql.org
> *Subject:* ***SPAM*** Re: [SPAM] Remote Connection
I have removed the rules in the iptables and restarted it and got nothing.
iptables is turned off and still nothing.
Jason L. Amerson
From: Moreno Andreo
Sent: Thursday, November 21, 2019 11:27 AM
To: pgsql-general@lists.postgresql.org
Subject: ***SPAM*** Re: [SPAM] Remote Connection
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
Il 21/11/19 15:21, Jason L. Amerson ha
scritto:
could not
connect to server: Connection refused (Ox274D/10061) Is
the server running on host " xx.xx.xx.xx" and accepting
TCP/IP
co
*From:*Jason L. Amerson
*Sent:* Thursday, November 21, 2019 09:22 AM
*To:* PostgreSQL
*Subject:* Remote Connection Help
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
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 at a
-h xx.xx.xx.xx" while
using my Ubuntu machine.
Jason L. Amerson
From: Jason L. Amerson
Sent: Thursday, November 21, 2019 09:22 AM
To: PostgreSQL
Subject: Remote Connection Help
I am at a loss for what to do. I have read article after article about how
to allow remote connecti
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 the
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 “listen_
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 "listen_address = 'localhost' to listen_address = '*'. I have ev
36 matches
Mail list logo
