Re: [GENERAL] Remote connection to PostgreSQL

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

Re: [GENERAL] Remote connection to PostgreSQL

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

Re: [GENERAL] Remote connection to PostgreSQL

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

[GENERAL] Remote connection to PostgreSQL

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. Thank you. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

[GENERAL] remote connection error:could not connect to server: Connection refused

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: > *listen_addresses =

Re: [GENERAL] remote connection error:could not connect to server: Connection refused

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

[GENERAL] remote connection refused

I'd like to have a checklist upon what to do, what to investigate, when an external connection is refused. if i connect by : psql -h localhost -p 5432 -U yt mydb it works as usual however even locally but using the LAN address : psql -h 192.168.0.20 -p 5432 -U yt mydb i got a : psql: could

Re: [GENERAL] remote connection refused

From: Yvon Thoraval yvon.thora...@gmail.com To: pgsql-general@postgresql.org pgsql-general@postgresql.org, Date: 19/11/2012 12:14 Subject:[GENERAL] remote connection refused Sent by:pgsql-general-ow...@postgresql.org I'd like to have a checklist upon what to do, what

Re: [GENERAL] remote connection refused

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.

Re: [GENERAL] remote connection refused

YES fine, thanks a lot ! it was left to default 'locahost'... 2012/11/19 Devrim GÜNDÜZ dev...@gunduz.org 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

Re: [GENERAL] Remote connection shows localhost databases

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 \\server\ip_address into the host name field. The host field should contain

Re: [GENERAL] Remote connection shows localhost databases

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

Re: [GENERAL] Remote connection shows localhost databases

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 \\server\ip_address into the host name field. The host field should contain the socket complete path, or the host name, or the ip address.

Re: [GENERAL] Remote connection shows localhost databases

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. When

[GENERAL] Remote connection shows localhost databases

I am trying to connect to a workstation running postgres from another computer on the network. I have postgres installed on both machines. When I go to connect to the workstation, everything appears to happen correctly, however, the server connection shows the databases on the localhost, not the

Re: [GENERAL] Remote connection shows localhost databases

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? --

Re: [GENERAL] Remote connection shows localhost databases

) 713-0376 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

Re: [GENERAL] Remote connection shows localhost databases

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 \\server\ip_address into the host name field. What I found was it didn't matter

Re: [GENERAL] Remote connection issues

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 postgresql.conf

[GENERAL] Remote connection issues

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 192.168.2.122. The port 5432 is open,

Re: [GENERAL] Remote connection issues

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

Re: [GENERAL] Remote connection issues

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

Re: [GENERAL] Remote connection issues

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. The

Re: [GENERAL] Remote connection issues

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 server, I

Re: [GENERAL] Remote Connection

In response to Bob Pawley rjpaw...@shaw.ca: 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

Re: [GENERAL] Remote Connection

] Remote Connection In response to Bob Pawley rjpaw...@shaw.ca: 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

[GENERAL] Remote Connection

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 Delphi it just hangs, until timeout, without

[GENERAL] Remote connection timed out

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? -- Regards, Barbara Stephenson /EDI Specialist/Programmer/ *Turbo, division

Re: [GENERAL] Remote connection timed out

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

Re: [GENERAL] Remote Connection

, 2009 3:26 PM Subject: Re: [GENERAL] Remote Connection 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

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 this instance it means that any host in the address range 192.168.1.1 - 192.168.1.254

Re: [GENERAL] Remote Connection

@postgresql.org Sent: Friday, 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

Re: [GENERAL] Remote Connection

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

Re: [GENERAL] Remote Connection

On Fri, Feb 13, 2009 at 3:43 PM, Bob Pawley rjpaw...@shaw.ca 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.

[GENERAL] Remote Connection

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 to the IP address of

Re: [GENERAL] Remote Connection

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

Re: [GENERAL] Remote Connection

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 have

Re: [GENERAL] Remote Connection

On Thursday 12 February 2009, Bob Pawley rjpaw...@shaw.ca 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

Re: [GENERAL] Remote Connection

On Thu, Feb 12, 2009 at 5:04 PM, Bob Pawley rjpaw...@shaw.ca 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

Re: [GENERAL] Remote Connection

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

[GENERAL] REMOTE CONNECTION

Hi, I have installed postgre 8.2.4. I tried to modify the pg_hba.conf and .conf file for allowing remote connection but it did not work. The server is a linux machine. I am trying to connect with my laptop by ssh client. Please may I know what other parameters need to be tweaked. I get an

Re: [GENERAL] REMOTE CONNECTION

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

Re: [GENERAL] remote connection, web hosting, IP adress

ok, thanks - Original Message - From: A. Kretschmer [EMAIL PROTECTED] To: pgsql-general@postgresql.org 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

[GENERAL] remote connection, web hosting, IP adress

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 from my personal computer, in order to do some maintenance job on the

Re: [GENERAL] remote connection, web hosting, IP adress

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

Re: [GENERAL] remote connection, web hosting, IP adress

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 from