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
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
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:
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 = "
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
stat
-a | grep 5432)
Cheers
From: Yvon Thoraval
To: "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 to
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 no
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?
--
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
wo
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 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, c
] Remote Connection
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.
Howe
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
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 ope
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
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 of
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
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 th
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
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 erro
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
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
46 matches
Mail list logo
