I guess I have seen all video recording from pgconf us 2015 at youtube.
Are there any recording from this year available?
Best regards Johannes
signature.asc
Description: OpenPGP digital signature
On Thu, May 26, 2016 at 11:26 PM, Andreas Joseph Krogh
wrote:
> Hi.
>
> Any news about when slides for $subject will be available?
>
I submitted slides to pgcon site, but it usually takes awhile, so you can
download our presentation directly
http://www.sai.msu.su/~megera/postgres/talks/pgcon-201
On Sat, May 28, 2016 at 02:15:07PM -0400, Tom Lane wrote:
> hubert depesz lubaczewski writes:
> > Does that help us in any way?
>
> Not terribly. That confirms that the processes are contending for a
> spinlock, but we can't tell which one. Can you collect a few stack traces
> from those proces
On Sat, May 28, 2016 at 10:32:15AM -0700, Jeff Janes wrote:
> > any clues on where to start diagnosing it?
>
> I'd start by using strace (with -y -ttt -T) on one of the processes
> and see what it is doing. A lot of IO, and one what file? A lot of
> semop's?
So, I did:
sudo strace -o bad.log -
hubert depesz lubaczewski writes:
> Does that help us in any way?
Not terribly. That confirms that the processes are contending for a
spinlock, but we can't tell which one. Can you collect a few stack traces
from those processes?
regards, tom lane
--
Sent via pgsql-g
On Sat, May 28, 2016 at 08:04:43AM +0200, Pavel Stehule wrote:
> > > you should to install debug info - or compile with dubug symbols
> > Installed debug info, and the problem stopped.
OK. ot he problem back.
Ps looked like this:
USERPID %CPU %MEMVSZ RSS TTY STAT START TIME
I still don't understand why the OP is getting into so much trouble and
doesn't upgrade to a newer version like 9.3 or 9.4 (or even 9.5).
All this hassle to stay on an unsupported postgres is just useless, IMNSHO.
Regards,
El 28/05/16 a las 12:26, Francisco Olarte escribió:
> Jeff:
>
> On Sat,
On Fri, May 27, 2016 at 10:19 PM, hubert depesz lubaczewski
wrote:
> hi,
> we have following situation:
> pg 9.3.11 on ubuntu.
> we have master and slave.
> the db is large-ish, but we're removing *most* of its data from all
> across the tables, and lots of tables too.
>
> while we're doing it, so
Jeff:
On Sat, May 28, 2016 at 12:38 AM, Jeff Baldwin wrote:
> Thank you for your time Alan.
..
> To move the DB, you are suggesting something like this:
> pg_dump -h dbms11 -U postgres -C mls11 | psql -h localhost -d mls11 -U
> postgres
I'd like to point one thing, you MAY get a little more spe
Hi Jeff,
> Thank you for the message. --- I like your idea, but one thing I
> forgot to mention is that my target postgres cluster has production
> DB's running on it already.
Oh, that's important information.
The only way to "merge" additional databases into an existing cluster
would be dum
El 28/05/16 a las 08:57, Nikhil escribió:
> Once the node which was down is brought back the replication slot is not
> turned active. The reason being replication slot is trying to create a
> partition table which already exists. Because of this error replication
> slot is stuck in inactive mode. I
El 28/05/16 a las 08:57, Nikhil escribió:
> Once the node which was down is brought back the replication slot is not
> turned active. The reason being replication slot is trying to create a
> partition table which already exists. Because of this error replication
> slot is stuck in inactive mode. I
Once the node which was down is brought back the replication slot is not
turned active. The reason being replication slot is trying to create a
partition table which already exists. Because of this error replication
slot is stuck in inactive mode. Is there any way to ignore this error?
On 28-May-20
El 27/05/16 a las 06:33, Nikhil escribió:
> Hello,
>
>
> I have a BDR setup with two nodes. If I bring one node down i am seeing that
> the replication slot is becoming inactive with below error.
If you take down one of the nodes of a BDR mesh, the replication slots
from each of the upstream nod
> or is there something built in that I have missed?
The intarray extension in the contrib provides a GiST operator class
for int[]. That can be used with exclusion constraints:
> hasegeli=# create extension intarray;
> CREATE EXTENSION
>
> hasegeli=# create type e as enum ('a', 'b');
> CREATE T
15 matches
Mail list logo
