I'm seeing long-running transactions (pg_dump) canceled on the standby when
there are a lot of inserts happening on the master. This despite my having
set max_standby_streaming_delay to -1 on the standby.
Why might that happen?
This is pg 9.3.12. When it happens I see:
pg_dump: Dumping the
Hi,
I was trying to clean a database by deleting records of some of its tables.
But in our model we have a table that is heavily referenced, that is, many
tables reference this particular table by foreign key constraints. We don't
have foreign key indexes, so executing a delete from mytable takes
On 13-05-2016 19:04, Alvaro Herrera wrote:
I happened to notice this report from 15 months ago, which didn't get
any response. Did you find a solution to this problem? I would first
blame btrfs, mostly because I've never heard of anyone with this problem
on more mainstream filesystems. As I
Alvaro Herrera writes:
> Gustavo Lopes wrote:
>> ... Why wouldn't postgres retry on EINTR or even
>> allow return values of write() lower than nbytes (and then continue in a
>> loop).
> I happened to notice this report from 15 months ago, which didn't get
> any
On Tue, 10 May 2016 11:20:05 -0400
"D'Arcy J.M. Cain" wrote:
> On Tue, 10 May 2016 10:46:39 -0400
> George Neuner wrote:
> > On Linux (or Unix) you'd set up a forwarding record in iptables that
> > redirects a second port to Postgresql.
>
> Forwarding to
Gustavo Lopes wrote:
> Every few weeks, I'm getting a error like this:
>
> > 2015-02-11 15:31:00 CET PANIC: could not write to log file
> > 00010007007D at offset 1335296, length 8192: Interrupted system
> > call
> > 2015-02-11 15:31:00 CET STATEMENT: COMMIT
> > 2015-02-11 15:31:17
Hi,
Thank you for the explanation.
The slave queries are mostly reporting queries,which sometimes would take
30+ running time due to complex joins and criteria. We haven't tried running
these queries on master before splitting, and it is possible that there will
be heavy updates and deletes on
Hello,
I think that you can safely add the PostgreSQL repository to your system, so
that you can get the latest packages for your Debian.
See there how to do it:
https://wiki.postgresql.org/wiki/Apt
Regards,
Pierre
Le 13 mai 2016 09:14:28 GMT+02:00, JingYuan Chen a
I use Debian Wheezy and PostgreSQL 9.1 is the default package.
On Fri, May 13, 2016 at 3:13 PM, JingYuan Chen wrote:
> I use Debian Wheezy and PostgreSQL 9.1 is the default package.
>
> On Fri, May 13, 2016 at 3:06 PM, Arthur Silva wrote:
>
>> Any
Any specific reason for choosing this old version of postgres?
On May 13, 2016 8:46 AM, "JingYuan Chen" wrote:
> Hello,
>
> I want to share my experience about one of my projects and say thank you
> to the community.
>
> Scenario :
> My company's ERP system is SAP and rent a
On Fri, 13 May 2016 08:45:46 +0530, Sridhar N Bamandlapally
wrote:
>we need simple concatenation of all variables(which values may come NULL or
>valid-values based on functional process),
>
>coalesce is different functionality
As Pavel suggested, concat will work, but it
Hello,
I want to share my experience about one of my projects and say thank you to
the community.
Scenario :
My company's ERP system is SAP and rent a procurement system for bid. It's
architecture bases on Webshpere5 and Oracle and IBM Java 1.4. The provider
informed us that they decide to close
12 matches
Mail list logo