Re: The tragedy of SQL

Em 15/09/2021 21:55, Adrian Klaver escreveu: On 9/15/21 5:30 PM, FWS Neil wrote: On Sep 15, 2021, at 2:44 PM, Merlin Moncure > wrote: I think you ought to recognize that many people on this list make money directly from managing that complexity :-). I did

Re: Issue with PSQL JDBC Driver Null Pointer

I would do public String getTypeForAlias(String alias) { if (alias==null) return null; // this shall solve NPE on alias.toLowerCase() String type = TYPE_ALIASES.get(alias); if (type != null) { return type; } type =

Re: Database issues when adding GUI

Em 07/06/2021 13:08, Alan Hodgson escreveu: On Mon, 2021-06-07 at 09:03 -0700, Rich Shepard wrote: The problem source is postgres telling me it cannot connect to the database but I can do so directly using psql: $ psql --host salmo --user rshepard --dbname bustrac psql: error: could not

Re: Retirar e-mail da lista

Em 14/03/2019 09:05, Angélica Barcellos escreveu: Bom dia. Recebo constantemente os e-mails,tem como retirar o meu e-mail dessa lista. Não quero receber mais nada. OBRIGADO Angélica Barcelos Cardoso Hello, Angelica. I'm not the list administrator, but I believe that you will have to run

Re: POSTGRES/MYSQL

Em 11/03/2019 16:20, Gavin Flower escreveu: On 12/03/2019 05:35, Michael Nolan wrote: [...]  MySQL is better at isolating users from each other and requires less expertise to administer. [...] I keep reading that MySQL is easier to administer, but never seen any evidence of that.  And in

Re: Barman disaster recovery solution

Em 27/02/2019 12:12, Achilleas Mantzios escreveu: On 27/2/19 5:04 μ.μ., Edson Carlos Ericksson Richter wrote: Em 27/02/2019 09:31, Achilleas Mantzios escreveu: On 27/2/19 1:58 μ.μ., rich...@simkorp.com.br wrote: Just to notice, I d o use backup from standby and WAL archive from standby

Re: Barman disaster recovery solution

Em 27/02/2019 09:31, Achilleas Mantzios escreveu: On 27/2/19 1:58 μ.μ., rich...@simkorp.com.br wrote: Just to notice, I d o use backup from standby and WAL archive from standby. It is possible. But you have to configure standby with option of wal archive "always". I guess there are issues

Re: Barman disaster recovery solution

Em 21/02/2019 04:17, Julie Nishimura escreveu: Does anyone use this solution? any recommenations? Thanks! We do use it. IMHO, those are minimum recommendations: 1) start using it! It's easy and robust. 2) for minimal impact over production servers, setup replicated servers and create

Re: ORM

Em 28/09/2018 19:49, marcelo escreveu: For a new big and convoluted project I (am/was) using Devart´s LinqConnect as ORM. But today I experienced some inexplicable "object reference not set to an instance of an object" exceptions or other more specific to this libraries. I would wish to

Re: unorthodox use of PG for a customer

anks for your interest and input everyone ! On Fri, Aug 24, 2018 at 2:39 PM Edson Carlos Ericksson Richter mailto:rich...@simkorp.com.br>> wrote: Em 24/08/2018 15:18, David Gauthier escreveu: > Hi Everyone: > > I'm going to throw this internal customer request ou

Re: unorthodox use of PG for a customer

Em 24/08/2018 15:18, David Gauthier escreveu: Hi Everyone: I'm going to throw this internal customer request out for ideas, even though I think it's a bit crazy.  I'm on the brink of telling him it's impractical and/or inadvisable.  But maybe someone has a solution. He's writing a

Re: We find few queries running three times simultaneously with same parameters on postgres db

Em 26/06/2018 14:26, amandeep singh escreveu: Hi Andreas The value for $1 is same in all queries. @Edson: number of such running queries are always  3. I see. It seems a programming logic error to me. I also use JPA (Hibernate and/or EclipseLink) and I don't have such problem. But I could

Re: We find few queries running three times simultaneously with same parameters on postgres db

Em 26/06/2018 08:49, Saurabh Agrawal escreveu: Am 26.06.2018 um 12:19 schrieb amandeep singh: We have been observing our postgres database from past few days,We found few queries running three times simultaneously with same parameters.I would like to back track how

Re: Postgresql Split Brain: Which one is latest

Em 10/04/2018 12:28, Melvin Davidson escreveu: On Tue, Apr 10, 2018 at 11:04 AM, Vikas Sharma > wrote: Hi Adrian, This can be a good example: Application server e.g. tomcat having two entries to connect to databases, one for

Re: decompose big queries

Em 05/04/2018 19:39, hmidi slim escreveu: Hi, I want to know what are the best practice to use in order to decompose a big query which contains so many joins.Is it recommended to use stored procedures ? or is there any other solution? I don't know if there are best practices (each scenario

Re: execute block like Firebird does

Em 11/02/2018 03:57, PegoraroF10 escreveu: We are migrating our databases from Firebird to PostGres. A useful feature Firebird has is Execute Block. What it does is just return a record set from that dynamic SQL, just like a PostGres function, but without creating it. It sound like ... execute

Re: Does PostgreSQL check database integrity at startup?

Em 29/12/2017 22:14, Jan Wieck escreveu: On Thu, Dec 28, 2017 at 1:26 PM, Stephen Frost > wrote: Greetings Brent, * Brent Wood (pcr...@yahoo.com ) wrote: > A tool to calculate a checksum of sorts based on

Re: Does PostgreSQL check database integrity at startup?

Em 28/12/2017 10:16, Stephen Frost escreveu: Alvaro, * Alvaro Herrera (alvhe...@alvh.no-ip.org) wrote: For context: this was first reported in the Barman forum here: https://groups.google.com/forum/#!msg/pgbarman/3aXWpaKWRFI/weUIZxspDAAJ They are using Barman for the backups. A, I see. I

Re: Does PostgreSQL check database integrity at startup?

Em 27/12/2017 15:02, Stephen Frost escreveu: Alvaro, * Alvaro Herrera (alvhe...@2ndquadrant.com) wrote: Stephen Frost wrote: * Edson Carlos Ericksson Richter (rich...@simkorp.com.br) wrote: Anyway, instead digging into rsync functionality (or bugs - I doubt, but who knows?), I do prefer

Re: Does PostgreSQL check database integrity at startup?

Em 26/12/2017 20:11, rob stone escreveu: Hello, On Tue, 2017-12-26 at 18:58 -0300, Alvaro Herrera wrote:Hello, David Steele wrote: pgBackRest will validate all page checksums (including indexes, etc.) in the cluster during backup. Full backups check everything, incr/differential backups

Re: Does PostgreSQL check database integrity at startup?

Em 26/12/2017 15:13, Alvaro Herrera escreveu: Edson Carlos Ericksson Richter wrote: I'm rebuilding the standby server for two days already, with 23% of completion status... So how do you build your standbys, exactly? Maybe there's a bug in your procedure, rather than a bug in the software

Re: Does PostgreSQL check database integrity at startup?

Em 26/12/2017 13:57, Pavel Stehule escreveu: 2017-12-26 16:50 GMT+01:00 Edson Carlos Ericksson Richter <rich...@simkorp.com.br <mailto:rich...@simkorp.com.br>>: Em 26/12/2017 13:40, Pavel Stehule escreveu: 2017-12-26 16:37 GMT+01:00 Edson Carlos Ericksson Richt

Re: Does PostgreSQL check database integrity at startup?

Em 26/12/2017 13:40, Pavel Stehule escreveu: 2017-12-26 16:37 GMT+01:00 Edson Carlos Ericksson Richter <rich...@simkorp.com.br <mailto:rich...@simkorp.com.br>>: Em 26/12/2017 12:25, Pavel Stehule escreveu: 2017-12-26 14:44 GMT+01:00 Martin Marques

Re: Does PostgreSQL check database integrity at startup?

Em 26/12/2017 12:25, Pavel Stehule escreveu: 2017-12-26 14:44 GMT+01:00 Martin Marques <martin.marq...@2ndquadrant.com <mailto:martin.marq...@2ndquadrant.com>>: El 26/12/17 a las 09:52, Edson Carlos Ericksson Richter escribió: > Recently I had a problem with a base f

Does PostgreSQL check database integrity at startup?

Recently I had a problem with a base file with size 0 in a standby server. This raised one question: does PostgreSQL (9.6.6) check base integrity at startup? At least if there are 0 byte size files in base dir? Or CRC? Something? Regards, -- *Edson Carlos Ericksson Richter* /SimKorp Ltda

Re: Stand by server (9.6.6) with corrupt file

, shall not the standby start? Regards, *Edson Carlos Ericksson Richter* /SimKorp Ltda/ Fone: (51) 3366-7964 Embedded Image /"A mente que se abre a uma nova ideia jamais voltará ao seu tamanho original"/ - Albert Einstein Em 23/12/2017 09:58, Martin Marques escreveu: El 22/12/1

Stand by server (9.6.6) with corrupt file

t 30 servers with same setup, and this only has this flaw. The only difference is that this database is about 3 times larger than the others (about 90Gb in size). Server and slave have 23ms of network lag - which seems not be a problem for the other databases in the same server. Any advi

Re: PostgreSQL needs percentage function

Em 18/12/2017 15:01, David G. Johnston escreveu: On Mon, Dec 18, 2017 at 9:56 AM, Edson Carlos Ericksson Richter <rich...@simkorp.com.br <mailto:rich...@simkorp.com.br>>wrote: But, is it possible to have a aggregate function that calculates de percent from the sum (and/or

Re: How to know if a database has changed

Em 12/12/2017 10:14, marcelo escreveu: Hi Sam You are right, and here are the reason behind my question: The server where postgres will be installed is not on 24/7. It turns on in the morning and goes off at the end of the day. The idea is that, as part of the shutdown process, a local

Re: To all who wish to unsubscribe

Em 20/11/2017 18:07, Joshua D. Drake escreveu: On 11/20/2017 12:03 PM, Tom Lane wrote: Unfortunately, the removal of the footer is a feature not a bug. In order to be DKIM-compatible and thus help avoid becoming classified as spammers, we can't mangle message content anymore, just like we can't