I recently recompiled our Postgres extension functions and re-encountered a
problem that I thought was solved. When I call our function, the code just
hangs ... it sit there not executing, not using any CPU cycles. Forever.
The process is still running, but seems to be waiting for ... what?
I or
On Fri, May 04, 2012 at 08:57:08AM -0500, Kevin Grittner wrote:
> "k...@rice.edu" wrote:
>
> > You may also want to consider setting a statement_timeout to
> > prevent this until you can find the problem with the application.
>
> How would a statement timeout help close a transaction on an idl
"k...@rice.edu" wrote:
> You may also want to consider setting a statement_timeout to
> prevent this until you can find the problem with the application.
How would a statement timeout help close a transaction on an idle
connection? It's idle because no statements are being run.
-Kevin
--
Magnus Hagander, 04.05.2012 15:22:
I'm trying to enable "ident" authentication on my Windows machine using
PostgreSQL 9.1
However as soon as I add the following line to pg_hba.conf
hostall all ::1/128ident sameuser
"sameuser" was removed in PostgreSQ
On Fri, May 04, 2012 at 03:22:47PM +0530, Gnanakumar wrote:
> > SELECT application_name, client_addr, client_hostname, client_port
> > FROM pg_stat_activity
> > WHERE procpid = 14740;
>
> > (Replace 14740 of the process ID of the "idle in transaction" backend).
>
> > Look on the client machine an
On Fri, May 4, 2012 at 3:33 PM, k...@rice.edu wrote:
> On Fri, May 04, 2012 at 01:57:47PM +0200, Thomas Kellerer wrote:
>> Hi,
>>
>> I'm trying to enable "ident" authentication on my Windows machine using
>> PostgreSQL 9.1
>>
>> However as soon as I add the following line to pg_hba.conf
>>
>>
On Fri, May 04, 2012 at 01:57:47PM +0200, Thomas Kellerer wrote:
> Hi,
>
> I'm trying to enable "ident" authentication on my Windows machine using
> PostgreSQL 9.1
>
> However as soon as I add the following line to pg_hba.conf
>
>hostall all ::1/128id
On Fri, May 4, 2012 at 1:57 PM, Thomas Kellerer wrote:
> Hi,
>
> I'm trying to enable "ident" authentication on my Windows machine using
> PostgreSQL 9.1
>
> However as soon as I add the following line to pg_hba.conf
>
> host all all ::1/128 ident sameuser
Hi,
I'm trying to enable "ident" authentication on my Windows machine using
PostgreSQL 9.1
However as soon as I add the following line to pg_hba.conf
hostall all ::1/128ident sameuser
I get an error message when trying to login (after a server reload
Thank you sir.
--- 12年5月3日，周四, Devrim GÜNDÜZ 写道：
发件人: Devrim GÜNDÜZ
主题: Re: [ADMIN] postgresql stream replication question
收件人: "sgm"
抄送: pgsql-admin@postgresql.org
日期: 2012年5月3日,周四,下午3:34
On Thu, 2012-05-03 at 13:47 +0800, sgm wrote:
> I have successfully set up the stream replication M1--IP
> Then you need to identify the web server process/thread that has
> client_port open and fix the problem there. If you get that process
> to close the transaction or terminate, your problem is solved.
> You can also terminate a database session from the server with
> the pg_terminate_backend func
Gnanakumar wrote:
>> SELECT application_name, client_addr, client_hostname, client_port
>> FROM pg_stat_activity
>> WHERE procpid = 14740;
>> (Replace 14740 of the process ID of the "idle in transaction"
backend).
>> Look on the client machine and find the process that holds TCP port
>> "client_p
> SELECT application_name, client_addr, client_hostname, client_port
> FROM pg_stat_activity
> WHERE procpid = 14740;
> (Replace 14740 of the process ID of the "idle in transaction" backend).
> Look on the client machine and find the process that holds TCP port
> "client_port" open (on Linux you
13 matches
Mail list logo
