On Thu, 1 Feb 2024 08:28:45 -0500
Johnathan Tiamoh wrote:
> Thank you Laurenz!
>
> Is there a way of preventing this from happening ?
This could either come from a hardware issue, or easily from your own actions
or procedures.
Did you have some difficulties with your instance lately?
Hi,
On Thu, 30 Nov 2023 19:07:34 +
Vijaykumar Patil wrote:
> I have two postgres server one is primary and other one replica, I have setup
> replication and configured pacemaker and corosync.
>
> But still I'm facing issue while creating resource. It is showing invalid
> parameters.
>
>
Hi Jason,
On Tue, 17 Oct 2023 19:59:00 +
Jason Grammenos wrote:
[...]
> If you have 2 PostgreSQL nodes hooked up to a Load balancer (haproxy), and
> you move take node1 out of load balancing, you now have connections on node1
> and connections on node2, as the Load balancer drains the
On Fri, 13 Oct 2023 19:21:46 +
Laura Smith wrote:
> --- Original Message ---
> On Friday, October 13th, 2023 at 14:10, Jehan-Guillaume de Rorthais
> wrote:
>
> > But really, double check first why a simple primary-standby architecture
> > doesn't meet
On Fri, 13 Oct 2023 12:02:53 +
Jason Grammenos wrote:
> Thank you for the feedback,
>
> I have used pacemaker for other purposes previously so am a little familiar
> with it.
So you might be familiar with shared-storage cluster, that are the simpler one
you could deploy (baring you have a
On Wed, 6 Sep 2023 19:34:40 +0530
Sai Teja wrote:
> In my local it is windows OS and locale is English_united_states.1252 and
> in local it is converting as expected ( testµ into TESTµ)
I'm not familiar with PostgreSQL under Windows. Maybe collation from locale
"English_united_states.1252" is
On Tue, 16 May 2023 23:30:42 +0200
Marcello Lorenzi wrote:
> Hi everyone,
> we're looking for the best solution for a 2-nodes cluster in HA with
> Postegresql 15. after some checks we are noticed about pgpool for the
> management of balancing and automatic failover. Can it be considered a
>
On Fri, 07 Apr 2023 21:16:04 +0900 (JST)
Tatsuo Ishii wrote:
> >> If node 1 hangs and once it is recognized as "down" by other nodes, it will
> >> not be used without manual intervention. Thus the disaster described above
> >> will not happen in pgpool.
> >
> > Ok, so I suppose **all**
On Fri, 07 Apr 2023 18:04:05 +0900 (JST)
Tatsuo Ishii wrote:
> > And I believe that's part of what Cen was complaining about:
> >
> > «
> > It is basically a daemon glued together with scripts for which you are
> > entirely responsible for. Any small mistake in failover scripts and
> >
On Fri, 07 Apr 2023 13:16:59 +0900 (JST)
Tatsuo Ishii wrote:
> >> > But, I heard PgPool is still affected by Split brain syndrome.
> >>
> >> Can you elaborate more? If more than 3 pgpool watchdog nodes (the
> >> number of nodes must be odd) are configured, a split brain can be
> >> avoided.
On Wed, 05 Apr 2023 16:50:15 +0900 (JST)
Tatsuo Ishii wrote:
> > But, I heard PgPool is still affected by Split brain syndrome.
>
> Can you elaborate more? If more than 3 pgpool watchdog nodes (the
> number of nodes must be odd) are configured, a split brain can be
> avoided.
Split brain is
On Mon, 3 Apr 2023 06:33:46 +
Inzamam Shafiq wrote:
[...]
> Can someone please suggest what is one (Patroni vs PGPool II) is best for
> achieving HA/Auto failover, Load balancing for DB servers. Along with this,
> can you please share the company/client names using these tools for large PG
>
On Sun, 5 Feb 2023 17:14:44 -0800
Peter Geoghegan wrote:
...
> The OP should see the Postgres ICU docs for hints on how to use these
> facilities to make a custom collation that matches whatever their
> requirements are:
>
>
Le 8 septembre 2021 06:07:15 GMT+02:00, Ninad Shah a
écrit :
>These suggestions are appropriate. However, if you are ready to lose your
>replica to keep production running, there are a couple of methods.
>
>1) Set archive_command to "/bin/true"
>2) rename .ready files in archive_status to
On Tue, 31 Aug 2021 10:53:45 +0200
Laurenz Albe wrote:
> On Tue, 2021-08-31 at 10:36 +0200, basti wrote:
> > have a old PG 9.6 with WAL replication.
> > for some reason the rsync was failed and the filesystem was filled by
> > pg_xlog files.
> > As result PG stops working.
> >
> > Is there a
On Mon, 16 Aug 2021 11:31:23 +0100
Vikas Sharma wrote:
> Hi,
>
> I am planning for an enterprise grade PostgreSQL cluster and so looking for
> the tool/softwares which will do the cluster management or fencing to avoid
> split brain.
Look at Pacemaker, pro support and devel by both RedHat and
On Sat, 7 Aug 2021 20:44:41 +0200
Matthias Apitz wrote:
> El día sábado, agosto 07, 2021 a las 08:06:14p. m. +0200, Karsten Hilbert
> escribió:
>
> > Am Fri, Aug 06, 2021 at 08:09:03PM +0200 schrieb Matthias Apitz:
> >
> > > The prototype is ready.
> >
> > Nice. Now the elephant needs to
On Tue, 15 Jun 2021 19:16:41 +0530
Atul Kumar wrote:
> hi,
>
> I have an RDS instance with 2GB of RAM, 1 CPU, instance class - t2.small.
>
> If you need any more info please let me know.
>
> and as you shared I need to tweak
> random_page_cost/seq_page_cost/effective_cache_size So please
On Tue, 15 Jun 2021 16:12:11 +0530
Atul Kumar wrote:
> Hi,
>
> I have postgres 10 running on RDS instance.
>
> I have query below:
[...]
>
> So my doubt is initially when I run this query it takes around 42
> seconds to complete but later after few minutes it completes in 2-3
> seconds.
>
>
Le 11 juin 2021 19:47:09 GMT+02:00, Nikolay Samokhvalov
a écrit :
>My thoughts:
>https://twitter.com/samokhvalov/status/1403408281389789189.
>Apologies for top-posting.
So now, we can have a thread split over two different places and tools...
On Wed, 9 Jun 2021 14:51:46 -0500
Hassan Camacho Cadre wrote:
> Hello
>
>
> I recently installed a postgreSQL v12, in previous version 8.3 in all my
> queries I pass parameters using the character :
>
> SELECT
>
> public.tabla.id
>
> FROM
>
> public.tabla
>
> WHERE
>
>
On Fri, 4 Jun 2021 15:39:30 +0530
Atul Kumar wrote:
> HI,
>
> We have a centos 6 enviornment where postgres 9.6 is running on it.
>
> We have strange behavior of WAL files of pg_xlog directory
>
> As we have set archive_command to archive WAL files at different
> location and the
Hello,
On Tue, 13 Apr 2021 08:10:06 +
"LE MENTEC, SANDRINE" wrote:
> Dear postgres community,
>
> I am currently working on Postgres 12.5 on a windows server 2016. I need to
> use Kerberos token for the authentication on the database.
>
> To do so, I am looking for an installation
On Mon, 5 Apr 2021 17:28:06 -0400
Michael Schanne wrote:
> After a closer reading of the documentation, it appears the database should
> stop accepting new transactions before a wraparound would ever occur. If
> so, then the only possible explanations for this multixactid wraparound
> error
On Tue, 06 Apr 2021 10:46:08 +0200
Laurenz Albe wrote:
> On Sat, 2021-04-03 at 15:22 +0200, Luca Ferrari wrote:
> > why having a TransactionId that is 32 bits
> > in depth while it is exposed (thru txid_current()) as a 64 bits value?
> > I mean, having 64 bits would reduce the need for anti-wrap
On Thu, 18 Mar 2021 09:56:16 +0100
Luca Ferrari wrote:
[...]
> Therefore my question is: shouldn't autovacuum be able to freeze other
> tables/databases? I mean, the wraparound problem in this scenario will
> cause problems, but I was expecting different numbers for different
> tables/databases.
Hi Luca,
On Mon, 22 Mar 2021 08:56:46 +0100
Luca Ferrari wrote:
> I can confirm that freezing a template database is done by means of setting
> it age to zero.
[...]
> and here it is the situation after a restart:
>
> testdb=> select datname, age( datfrozenxid ) from pg_database;
> datname
On Fri, 19 Mar 2021 14:28:27 +0200
Frank Millman wrote:
> [...]
> Execution of my main query has improved from 50ms to 33ms. Sql Server
> takes 25ms, but this is much better than it was.
>
> [...]
>
> Here is the new EXPLAIN ANALYSE -
>
>QUERY PLAN
>
On Tue, 16 Feb 2021 13:10:54 +0100
Paolo Saudin wrote:
> Il giorno mar 16 feb 2021 alle ore 10:51 Jehan-Guillaume de Rorthais <
> [...]
>
> [...]
> [...]
> [...]
> [...]
> [...]
> [...]
> [...]
>
> Thank you very much!
On Mon, 15 Feb 2021 18:55:14 +0100
Paolo Saudin wrote:
> Hi all,
> I have two servers, a primary and a secondary one with a streaming replica
> setup.
> Today I noticed that some sequences are not lined-up, the replica ones are
> well ahead, while the records number is the same. How is it
On Sat, 26 Dec 2020 05:51:22 +0530
venkata786 k wrote:
> Hi Team,
>
> Could you please share postgresql's best active(R/W)-active(R/W) (multi
> master replication) solutions.
> My Team is thinking about implementing active-active replacing master-slave.
Symmetric replication bring a lot of
On Tue, 29 Sep 2020 16:22:18 +0300
Олег Самойлов wrote:
[...]
> > In regards with keepalive parameters, I am a bit surprised. According to the
> > source code, parameters defaults are:
> >
> > keepalives=1
> > keepalives_idle=1
> > keepalives_interval=1
> > keepalives_count=1
> >
> > But I
On Thu, 24 Sep 2020 15:22:46 +0300
Олег Самойлов wrote:
> Hi, Jehan.
>
> > On 9 Sep 2020, at 18:19, Jehan-Guillaume de Rorthais
> > wrote:
> >
> > On Mon, 7 Sep 2020 23:46:17 +0300
> > Олег Самойлов wrote:
> >
> >>> [...]
> &g
On Mon, 7 Sep 2020 23:46:17 +0300
Олег Самойлов wrote:
> [...]
> >>> why did you add "monitor interval=15"? No harm, but it is redundant with
> >>> "monitor interval=16 role=Master" and "monitor interval=17
> >>> role=Slave".
> >>
> >> I can't remember clearly. :) Look what happens
On Wed, 2 Sep 2020 20:33:09 +0300
Олег Самойлов wrote:
> The software is rather outdated. It works with PostgreSQL 11 and CentOS 7.
> The next step will be upgrading to CentOS 8 and PostgreSQL 12. Please tell
> me, is it useful and worth to continue? Where is better announce it? May be
>
On Thu, 20 Aug 2020 15:16:10 +0300
Олег Самойлов wrote:
[...]
> >> Almost works fine, but sometimes, rather rare, I detected that a slave
> >> don't reconnect to the new master after a failure. First case is
> >> PostgreSQL-STOP, when I `kill` by STOP signal postgres on the master to
> >>
On Tue, 18 Aug 2020 13:48:41 +0300
Олег Самойлов wrote:
> Hi all.
>
> I found some strange behaviour of postgres, which I recognise as a bug. First
> of all, let me explain situation.
>
> I created a "test bed" (not sure how to call it right), to test high
> availability clusters based on
ten
requires some changes on application side...or even dealing with it on
application side all together.
I've seen too many complex architectures, with too many layers, hard to
administer...for nothing. Keep it simple as long as you can.
Good luck.
Regards,
--
Jehan-Guillaume de Rorthais
Dalibo
On Thu, 9 Jul 2020 13:53:46 + (UTC)
Laurent FAILLIE wrote:
> Hello,
> I've been asked by one of my customer to know which are the possible
> clustering solution for PostgreSQL ? Active/passive ?Active/active ?
> if possible free or not too expensive.
Start first by setting up safe and
On Fri, 10 Jul 2020 10:05:52 +1000
James Sewell wrote:
> Hi all,
>
> I’m trying to work out a procedure for a safe zero data loss switchover
> under (high) load, which allows the old master to be reconnected without
> the use of pgrewind.
>
> Would the following be sane?
>
> - open connection
On Sat, 22 Feb 2020 19:23:05 +
Edson Richter wrote:
[...]
> Actually, standby server is sending wals to a backup (barman) server:
>
> archive_mode = always # enables archiving; off, on, or always
> (change requires restart) archive_command = 'rsync -e "ssh -2 -C -p 2022" -az
> %p
On Thu, 9 Jan 2020 06:55:18 -0500
Rita wrote:
> Thanks for the response.
> I am using Postgresql 11.
> I want something simple and I have a strong preference toward using stock
> tools. After the promotion and the original master comes online, I was
> thinking of doing a pg_basebackup to sync.
On Sat, 9 Nov 2019 09:18:21 +0100
Peter Eisentraut wrote:
> On 2019-11-07 16:18, Jehan-Guillaume de Rorthais wrote:
> > On Thu, 7 Nov 2019 16:02:21 +0100
> > Peter Eisentraut wrote:
> >
> >> On 2019-11-05 17:05, Jehan-Guillaume de Rorthais wrote:
> >>
On Thu, 7 Nov 2019 16:02:21 +0100
Peter Eisentraut wrote:
> On 2019-11-05 17:05, Jehan-Guillaume de Rorthais wrote:
> >> I have simplified your reproduction steps from the previous message to a
> >> test case, and I can confirm that your proposed fix addresses the iss
On Tue, 5 Nov 2019 16:02:51 +0100
Peter Eisentraut wrote:
> On 2019-10-25 17:38, Jehan-Guillaume de Rorthais wrote:
> > On Thu, 10 Oct 2019 15:15:46 +0200
> > Jehan-Guillaume de Rorthais wrote:
> >
> > [...]
> >> Here is a script to reproduce it und
On Thu, 10 Oct 2019 15:15:46 +0200
Jehan-Guillaume de Rorthais wrote:
[...]
> Here is a script to reproduce it under version 10, 11 and 12:
I investigated on this bug while coming back from pgconf.eu. Bellow what I found
so far.
The message "negative bitmapset member not allowed&quo
Hello,
On Thu, 4 Apr 2019 23:37:04 +0200
Peter Eisentraut wrote:
> On 2019-04-01 23:43, Alvaro Herrera wrote:
> > Maybe the replica identity of a table got set to a unique index on oid?
> > Or something else involving system columns? (If replication is
> > otherwise working, the I suppose
47 matches
Mail list logo