What am I suppose to change in pg_hba.conf file?
Regards,
Anuj Pankaj
From: Igor Neyman [mailto:iney...@perceptron.com]
Sent: Thursday, September 30, 2010 6:49 PM
To: Anuj Pankaj; pgsql-admin@postgresql.org
Subject: RE: could not connect to server: Connection refused
(0x274D/10061)
Anuj Pankaj an...@cybage.com writes:
What am I suppose to change in pg_hba.conf file?
If you're getting Connection refused, no amount of changing
pg_hba.conf will change the result, because that's not where your
problem is. This error implies the postmaster isn't listening at all on
the
Hi,
We have a number of long running java/jdbc applications that wait for events
and then extract data from PG.
During the time the apps are running, The app is maintaining active
connections to PG.
Is there a way that we can close/terminate the pg session so that the
connections don't
Little, Douglas douglas.lit...@orbitz.com wrote:
We have a number of long running java/jdbc applications that wait
for events and then extract data from PG.
During the time the apps are running, The app is maintaining
active connections to PG.
Is there a way that we can close/terminate
Hey Kevin,
Thanks for the response.
Currently it's keeping 16 open connections and it isn't even running. I
believe that they(finance) can run 5 concurrent java apps and each opens a
number of sessions. Currently all 16 sessions are owned by 1 datid. So
potentially it's 80 connections,
Little, Douglas douglas.lit...@orbitz.com wrote:
Kevin Grittner [mailto:kevin.gritt...@wicourts.gov] wrote:
Little, Douglas douglas.lit...@orbitz.com wrote:
We have a number of long running java/jdbc applications that
wait for events and then extract data from PG.
During the time the apps
Hello
If your listen_addresses is wrong,the same error can occur.
example)
$ cat postgresql.conf |grep listen_addresses
#listen_addresses = '*' # what IP address(es) to listen on;
$ psql -h 192.168.23.133
psql: could not connect to server: Connection refused
Is the server
Thanks
The only admin function that look close is
pg_terminate_backend(pid int) boolean Terminate a backend
I tried it and it couldn't be found. It is newist. We're running
PG8.2.13/GP3.3.7
Oh, these connections aren't waiting for *database* events? Then
you should either restructure
Hi Devrim,
Hi Kenichiro,
Thank you!
Did you change the port number in postgresql.conf? Specifying
--with-pgport only embeds port number to binaries, not to
postgresql.conf.
In my postgresql.conf there was a line
port = 6543
But it was commented out. I took the # out.
If your
Little, Douglas wrote:
The only admin function that look close is
pg_terminate_backend(pid int) boolean Terminate a backend
I tried it and it couldn't be found. It is newist. We're running
PG8.2.13/GP3.3.7
Yes, that's an 8.4 function.
We tried pgpool for awhile, but I think I'll
Hi all,
I've been tasked with getting postgresql 8.3 set up on a Windows 7
box. I have zero experience with Windows 7, and very little with Windows
in general so I'm having some trouble.
I installed postgres 8.3 using EnterpriseDB's one click installer. I
need to import a sql file I
I've installed postgresql 8.4.4.
Hi,
Usually you need a ...-dev package if you want to compile anything against it.
But i can't find a postgresql-8.4-dev in my ubuntu lucid (10.04).
That might mean that you have to compile postgres also, or find a
repository for the -dev package.
hth
WBL
--
On Fri, Oct 1, 2010 at 1:48 PM, Willy-Bas Loos willy...@gmail.com wrote:
I've installed postgresql 8.4.4.
Hi,
Usually you need a ...-dev package if you want to compile anything against it.
But i can't find a postgresql-8.4-dev in my ubuntu lucid (10.04).
That might mean that you have to
2010/9/30 Victor Hugo vh.cleme...@gmail.com:
Hi !
I am compiling the pgpool-II and the following error below happens:
configure: error: libpq is not installed or libpq is old
I ran the following command : ./configure
--prefix=/opt/PostgreSQL/pgpoolII --with-pgsql=/opt/PostgreSQL/8.4
postgresql-server-dev-8.4?
ah, the other way around :P
i would think
libpqxx3-dev
or libpqxx-dev, which is probably a meta-package (independent of version nr)
it seems from the error that you don't need the server files, only
libpg, which is a client library
--
Patriotism is the conviction
Is it possible to have clients authenticate via Kerberos to a PG 8.4 server
running on linux from both linux and windows hosts? I have authentication
working (using GSSAPI) between the linux clients and the server. I'd like to
use the Windows binary install (which already has GSSAPI compiled
* Brian Fehrle wrote:
CREATE LANGUAGE plperl;
ERROR: could not load library C:/Program Files
(x86)/PostgreSQL/8.3/lib/plperl.dll: The specified module could not be
found.
I looked in that location and the plperl.dll does exist. I checked
permissions, both the user account postgres and the user
17 matches
Mail list logo