On Mon, Jun 19, 2017 at 12:21 PM, Igor Korot wrote:
> Thx, David.
>
> On Mon, Jun 19, 2017 at 12:09 PM, David G. Johnston
> wrote:
> > On Mon, Jun 19, 2017 at 9:02 AM, Igor Korot wrote:
> >>
> >> Hi, ALL,
> >> Is there some magic in order to turn on remote connection to PostgreSQL?
> >>
> >> T
Thx, David.
On Mon, Jun 19, 2017 at 12:09 PM, David G. Johnston
wrote:
> On Mon, Jun 19, 2017 at 9:02 AM, Igor Korot wrote:
>>
>> Hi, ALL,
>> Is there some magic in order to turn on remote connection to PostgreSQL?
>>
>> There are some extra steps to turn it on for MS SQL and MySQL, so I
>> fig
On Mon, Jun 19, 2017 at 9:02 AM, Igor Korot wrote:
> Hi, ALL,
> Is there some magic in order to turn on remote connection to PostgreSQL?
>
> There are some extra steps to turn it on for MS SQL and MySQL, so I figured
> it should be the same for Postgre.
>
See "listen_addresses"
https://www.p
Alex Luya writes:
> My postgresql 9.4 is installed in centos 6.7,and I have followed this:
> http://www.cyberciti.biz/faq/postgresql-remote-access-or-connection/
> 1,cd /usr/pgsql-9.4/share/
> 2,cp postgresql.conf.sample postgresql.conf
> 3,sudo vi postgresql.conf and add two lines,and save it:
YES fine, thanks a lot !
it was left to default 'locahost'...
2012/11/19 Devrim GÜNDÜZ
>
> Hi,
>
> On Mon, 2012-11-19 at 13:08 +0100, Yvon Thoraval wrote:
> > in such a situation what is your checklist in order to find what I've
> > missed ?
>
> What is listen_addresses in postgresql.conf ? It
Hi,
On Mon, 2012-11-19 at 13:08 +0100, Yvon Thoraval wrote:
> in such a situation what is your checklist in order to find what I've
> missed ?
What is listen_addresses in postgresql.conf ? It should be * or so.
Also, I would make sure that there is not a firewall on the machine
itself.
Regard
Usually, after what you've already confirmed, it's likely to be one of the
following:
- check "listen_address" is set correctly in postgresql.conf. (try
"listen_address = *" and restart postgres)
- check port 5432 is open on iptables. (service iptables status, netstat
-a | grep 5432)
Cheers
Thanks Guillaume and Richard. I removed the server from the host name field and
entered only the IP address. I then edited my pg_hba.conf, adding the IP
address and it worked! I appreciate all of your help.
Jeff
>
> Thanks for the response Richard. I have tried to connect via pgAdminIII.
> Wh
On 15/09/11 22:40, Guillaume Lelarge wrote:
On Thu, 2011-09-15 at 15:30 -0400, Jeff Adams wrote:
When I try to connect to the remote machine, I enter \\\
into the host name field.
The host field should contain the
socket complete path, or the host name, or the ip address.
As Guillaume says
On 16/09/11 09:01, Guillaume Lelarge wrote:
On Fri, 2011-09-16 at 08:14 +0100, Richard Huxton wrote:
Odd that pgAdmin
doesn't give an error though.
Probably because the OP entered the Windows networking path in the Name
field, and didn't change the Host field. In which case, pgAdmin most
like
On Fri, 2011-09-16 at 08:14 +0100, Richard Huxton wrote:
> On 15/09/11 22:40, Guillaume Lelarge wrote:
> > On Thu, 2011-09-15 at 15:30 -0400, Jeff Adams wrote:
> >>
> >> When I try to connect to the remote machine, I enter
> >> \\\
> >> into the host name field.
> >
> >The host field should contai
On Thu, 2011-09-15 at 15:30 -0400, Jeff Adams wrote:
> [sorry for the duplicate Richard]
>
> Thanks for the response Richard. I have tried to connect via pgAdminIII.
> When I try to connect to the remote machine, I enter \\\
> into the host name field. What I found was it didn't matter what I ente
376
email: jeff.ad...@noaa.gov
-Original Message-
From: Richard Huxton [mailto:d...@archonet.com]
Sent: Thursday, September 15, 2011 2:50 PM
To: Jeff Adams
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Remote connection shows localhost databases
On 15/09/11 17:30, Jeff Adams w
On 15/09/11 17:30, Jeff Adams wrote:
I am trying to connect to a workstation running postgres from another
computer on the network.
How are you connecting? PgAdmin, psql, Perl script? What is the hostname
you are using on the local machine and are you sure it is for the remote
machine?
--
On Thursday, June 23, 2011 02:46:52 pm you wrote:
> On 6/23/11 3:24:12 AM, Aritz Dávila wrote:
> > Hi list,
> >
> > I have installed postgresql 8.4 on Ubuntu server 10.4. I would like to
> > have remote access to this database so after reading I found out that
> > modifying pg_hba.conf and postgre
On Thursday, June 23, 2011 12:24:12 am Aritz Dávila wrote:
> Hi list,
>
>
> Another strange thing is the following one, if I do the following on the
> database server: psql -h localhost -d database, I grant access but if I do
> the following psql -h 192.168.2.122 -d database on the database serv
On Thursday, June 23, 2011 12:24:12 am Aritz Dávila wrote:
> Hi list,
>
> I have installed postgresql 8.4 on Ubuntu server 10.4. I would like to have
> remote access to this database so after reading I found out that modifying
> pg_hba.conf and postgresql.conf will allow me to access remotely.
>
On 6/23/11 3:24:12 AM, Aritz Dávila wrote:
Hi list,
I have installed postgresql 8.4 on Ubuntu server 10.4. I would like to have
remote access to this database so after reading I found out that modifying
pg_hba.conf and postgresql.conf will allow me to access remotely.
The postgresql database is
On 23/06/2011 08:24, Aritz Dávila wrote:
Hi list,
I have installed postgresql 8.4 on Ubuntu server 10.4. I would like to have
remote access to this database so after reading I found out that modifying
pg_hba.conf and postgresql.conf will allow me to access remotely.
The postgresql database is o
Hi Bill
Thanks for answering.
The problem turned out to be the excessive permissions required in Windows 7
Firewall.
It appears to be working now.
Bob
-Original Message-
From: Bill Moran
Sent: Monday, January 10, 2011 5:55 AM
To: Bob Pawley
Cc: Postgresql
Subject: Re: [GENERAL
In response to "Bob Pawley" :
> Hi
>
> I am attempting to connect from two local interfaces to a remote database.
>
> With one interface (SharpMap developed in C#) I have no problems.
>
> With the other interface (Delphi) I have no problem connecting in design mode.
>
> However when I compile
Barbara Stephenson wrote:
Hello,
We have a website that connects remotely to our 8.3 postgres
database. I've noticed if I connect to the database and let it sit
for an hour the connection is lost. Is there a default connection
timeout?
How "remote"? Through firewalls/VPNs/etc.? My suspic
On Fri, Feb 13, 2009 at 3:43 PM, Bob Pawley wrote:
> In pg_hba there is a reference to reloading postmaster using pg_ctl.
>
> Does postmaster reload when the server is restarted??
Yep. restart shuts down pgsql, and then starts it up fresh, so it has
to read its config files etc. Reload is usefu
Bob Pawley wrote:
In pg_hba there is a reference to reloading postmaster using pg_ctl.
Does postmaster reload when the server is restarted??
depending on your OS, there's a variety of ways of forcing the
postmaster to reload or restart
some changes require a restart, like LISTEN_ADDRES
riday, February 13, 2009 10:31 AM
Subject: Re: [GENERAL] Remote Connection
On 13/02/2009 18:24, Bob Pawley wrote:
I am not sure what you mean by this IP format 192.168.1.0/24.
Hi Bob,
That's what's called a CIDR address - have a look at
http://en.wikipedia.org/wiki/CIDR - and in th
On 13/02/2009 18:24, Bob Pawley wrote:
> I am not sure what you mean by this IP format 192.168.1.0/24.
Hi Bob,
That's what's called a CIDR address - have a look at
http://en.wikipedia.org/wiki/CIDR - and in this instance it means that
any host in the address range 192.168.1.1 - 192.168.1.254 wit
I notice that the pg_hba file also includes an adress in similar format -
127.0.0.1/32.
How does this compare to my address 192.168.1.100?
Thanks in advance.
Bob
- Original Message -
From: "John R Pierce"
To: "PostgreSQL"
Sent: Thursday, February 12, 2009 3:
Bob Pawley wrote:
Hi
I've been operating on localhost successfully for some time.
I am now attempting to access a Postgresql 8.3 database installed on
one of my other computers conneted through a router.
Is this possible?
My first attempts have been with Postgresql Admin.
I changed host
On Thu, Feb 12, 2009 at 5:04 PM, Bob Pawley wrote:
> Hi
>
> I've been operating on localhost successfully for some time.
>
> I am now attempting to access a Postgresql 8.3 database installed on one of
> my other computers conneted through a router.
>
> Is this possible?
>
> My first attempts hav
On Thursday 12 February 2009, "Bob Pawley" wrote:
> I also ran - listen virtual; on the receiving server.
>
> It hasn't connected successfully. I get the message 'Server not
> listening'
>
> What else can I do??
Setup PostgreSQL on the server to listen on its external interface. Adjust
the firew
On Thursday 12 February 2009 3:04:54 pm Bob Pawley wrote:
> Hi
>
> I've been operating on localhost successfully for some time.
>
> I am now attempting to access a Postgresql 8.3 database installed on one of
> my other computers conneted through a router.
>
> Is this possible?
>
> My first attempts
Bob Pawley wrote:
Hi
I've been operating on localhost successfully for some time.
I am now attempting to access a Postgresql 8.3 database
installed on one of my other computers conneted through a router.
Is this possible?
My first attempts have been with Post
On Wed, May 30, 2007 at 06:28:17PM -0400, ABHANG RANE wrote:
> client. Please may I know what other parameters need to be tweaked. I
To begin with, please show us exactly what you're doing. I don't
know what it is yet.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
This work was visionary and imag
ok, thanks
- Original Message -
From: "A. Kretschmer" <[EMAIL PROTECTED]>
To:
Sent: Monday, September 05, 2005 6:15 PM
Subject: Re: [GENERAL] remote connection, web hosting, IP adress
am 05.09.2005, um 15:49:23 +0200 mailte Zlatko Mati? folgendes:
How can I c
On Mon, Sep 05, 2005 at 03:49:23PM +0200, Zlatko Mati? wrote:
> Hello.
>
> I will install a database on a remote server. There is pg_hba.config file
> that should be adjusted to protect from unauthorized access. It requires IP
> adresses.
> Now, I would like to be able to connect to the server f
am 05.09.2005, um 15:49:23 +0200 mailte Zlatko Mati? folgendes:
> How can I connect to remote server from a remote personal computer
> without its own IP adress ?
You can connect to the remote server via ssh. Then you are a local user.
SSH is a highly secure protocol, i suggest, use ssh with Publ
36 matches
Mail list logo
