Le 14 septembre 2017 19:11:19 GMT+02:00, Rafal Pietrak a
écrit :
>
>
>W dniu 14.09.2017 o 15:54, Merlin Moncure pisze:
>> On Thu, Sep 14, 2017 at 2:45 AM, Rafal Pietrak
>wrote:
>>> Hello everybody,
>>>
>>> Can anybody help me find a way to implement an ID which:
>>>
>>> 1. guarantees being uni
On Wed, 22 Feb 2017 22:58:10 +
Dylan Luong wrote:
> Hi
>
> I am a DBA at the University of South Australia. For PostgreSQL High
> Availability, we currently have setup a Master/Slave across two datacenters
> using PostgreSQL (WAL) streaming replication. We use an LTM (load balancer)
> server
On Thu, 9 Feb 2017 18:27:30 +
Rakesh Kumar wrote:
> >Sure, but when you are doing a switchover, the standby is supposed to be
> >connected to the master when you shutdown the master. So based on the doc,
> >the standby should receive **everything** from the master before the master
> >actuall
F[1], this check is:
* shut down the master
* use pg_controldata to find its shutdown checkpoint
* force a checkpoint on the standby (which in theory received everything
from the master by streaming)
* using pg_dumpxlog, check you received the shutdown checkpoint
[1] https://github.c
On Thu, 2 Feb 2017 16:12:06 -0800
Adrian Klaver wrote:
> On 02/02/2017 03:27 AM, alexanderfelipewo wrote:
> > hello!
> >
> > i have a question for pgbouncer in case someone has faced this and there is
> > a solution available.
> >
> > i have a db with pgbouncer where the pool_size is set to 50 (i
On Thu, 2 Feb 2017 04:27:45 -0700 (MST)
alexanderfelipewo wrote:
> hello!
>
> i have a question for pgbouncer in case someone has faced this and there is
> a solution available.
>
> i have a db with pgbouncer where the pool_size is set to 50 (i ve noticed
> this using both session/transaction m
On Thu, 1 Dec 2016 20:11:06 +0100
Benoit Lobréau wrote:
> Hi,
>
> Is it possible to use the built in replication to replicate between two
> PostgreSQL in the same version but in different version of the same OS (Say
> Pg 9.1 Ubuntu 12 to Pg 9.1 Ubuntu 14)
>
> I think I read in Hackers that sinc
On Wed, 30 Nov 2016 08:58:13 -0800
"Joshua D. Drake" wrote:
> On 11/30/2016 06:00 AM, Marcin Giedz wrote:
> > Hello,
> >
> > Does anyone know any reliable open source HA solution with stream
> > replication and IP live migration in case of master node failure?
> > Recently I've been attending Fuj
On Wed, 30 Nov 2016 15:00:16 +0100 (CET)
Marcin Giedz wrote:
> Hello,
>
> Does anyone know any reliable open source HA solution with stream replication
> and IP live migration in case of master node failure? Recently I've been
> attending Fujitsu PostgreSQL webinar and they presented so called
I can restart A as a slave. Is
> >> the observed behavior then just a "lucky fluke" that I shouldn't rely
> >
> > You don't say how active the database is, but I going to say it is not
> > active enough for the WAL files on B to go out for scope for
On Wed, 16 Nov 2016 15:51:26 -0900
Israel Brewster wrote:
> I've been playing around with streaming replication, and discovered that the
> following series of steps *appears* to work without complaint:
>
> - Start with master on server A, slave on server B, replicating via streaming
> replicatio
Le 28 octobre 2016 12:40:24 GMT+02:00, Michael Banck
a écrit :
>Hi,
>
>I'm doing some failover tests on a 2-node streaming replication cluster
>and shutting down the primary with 'pg_ctl -m fast' results in a
>timeout
>of 50-60 seconds, pg_ctl returns only after the latter message:
>
><71804---
On Thu, 22 Sep 2016 14:23:20 +0200
Sylvain Marechal wrote:
> Hello all,
>
> is there a way to monitor the size of the pg_xlog directory in SQL? The
> goal is to monitor the pg_xlog file without ressorting to a 'du' like
> solution that needs a direct access to the machine.
You might be inspired
noticed data_directory was set in postgresql.conf file...
But then, why starting PostgreSQL with the following command ?
/usr/lib/postgresql/9.4/bin/postgres -D /var/lib/postgresql/9.4/main \
-c config_file=/etc/postgresql/9.4/main/postgresql.conf
It seems the following one work as expecte
On Mon, 29 Aug 2016 13:13:17 -0300
Alvaro Herrera wrote:
> Jehan-Guillaume de Rorthais wrote:
> > On Mon, 29 Aug 2016 13:38:03 +0200
> > hubert depesz lubaczewski wrote:
> >
> > > Hi,
> > > we have rather uncommon case - DB with ~ 50GB of data, but thi
On Mon, 29 Aug 2016 13:38:03 +0200
hubert depesz lubaczewski wrote:
> Hi,
> we have rather uncommon case - DB with ~ 50GB of data, but this is
> spread across ~ 8 tables.
>
> Running pg_dump -Fd -jxx dumps in parallel, but only data, and MOST of
> the time is spent on queries that run sequen
Le Wed, 22 Jun 2016 18:07:46 +0800,
Vlad Arkhipov a écrit :
> I am running PostgreSQL 9.5.
>
> CREATE TABLE t (id BIGINT NOT NULL PRIMARY KEY, name TEXT);
I guess this is not your definitive definition of the table and you might
have some other fields isn't it ?
I can see multiple way to chan
Le Wed, 22 Jun 2016 10:49:13 +,
Albe Laurenz a écrit :
> Sameer Kumar wrote:
> > On Wed, Jun 22, 2016 at 6:08 PM Vlad Arkhipov wrote:
> >> I am running PostgreSQL 9.5.
> >>
> >> CREATE TABLE t (id BIGINT NOT NULL PRIMARY KEY, name TEXT);
> >>
> >> The constraint that the data must satisfy
Le Mon, 28 Mar 2016 12:44:51 +0200,
Emre Hasegeli a écrit :
> > Could I use lock tables to fix this? Is postgres automaticaly locking a
> > table while running a trigger on that table?
>
> You can use LOCK TABLE. See the documentation:
>
> http://www.postgresql.org/docs/current/static/explicit-
Le Fri, 4 Mar 2016 19:35:16 +,
Ashish Chauhan a écrit :
> Hi,
>
> We are running Streaming replication with Hot standby in our current
> production. I do have below script to check replication status and
> replication lag. Does anyone have script which runs every 15 mins to check
> replicati
/master/multistate/docs/Quick_Start.md
> repmgr is a tool you could use in conjunction with a generic cluster
> management system like linuxha/heartbeat, vcs, etc.
>
> the most difficult part is reliably determining that A) the master has
> crashed, and B) fencing the failed old ma
On Mon, 10 Nov 2014 09:39:23 -0500
Tom Lane wrote:
> Jehan-Guillaume de Rorthais writes:
> > While investigating about a wrong result with my btree bloat estimation
> > query, I found a strange stat deviation between the average size of a value
> > in its table and its aver
On Mon, 10 Nov 2014 11:52:54 +0100
Jehan-Guillaume de Rorthais wrote:
> Hello,
>
> I'm not sure if I should post here or on pgsql-hackers.
>
> While investigating about a wrong result with my btree bloat estimation query,
> I found a strange stat deviation between the
Hello,
I'm not sure if I should post here or on pgsql-hackers.
While investigating about a wrong result with my btree bloat estimation query,
I found a strange stat deviation between the average size of a value in its
table and its average size in one index on the "lower" expression.
Take the fo
24 matches
Mail list logo
