Re: Pgbouncer discard all

2018-10-16 Thread Martin Marques
El 16/10/18 a las 12:12, Nicola Contu escribió: >  2492534808 | dev    |   7355 | 1833427130 | pgbouncer       |          >                | 10.151.2.145   |                 |       60570 | > 2018-10-16 14:13:05.151015+00 |                               | > 2018-10-16 15:10:40.309993+00 | 2018-10-1

Re: how to cleanup archive based on datetime

2018-10-10 Thread Martin Marques
El 10/10/18 a las 04:00, magodo escribió: > > Hello, > > I know there is a tool `pg_archivecleanup`, but it only accepts wal > filename. What if I want to clean up all archived wal before a > specified datetime? > > Though I could check the ctime fo each wal and figure out which to > remove, but

Re: Barman issue

2018-10-10 Thread Martin Marques
El 05/10/18 a las 06:50, Rijo Roy escribió: > Hello Experts, > > I have a server rhel 6.9 installed with barman 2.3 which is configured > to take backup from Postgresql 10 installed in a remote host and the > same is working. You should upgrade to 2.4, although I can't see anything relevant in th

Re: pgBackRest backup from standby

2018-02-19 Thread Martin Marques
El 19/02/18 a las 17:53, David Steele escribió: > On 2/19/18 3:41 PM, Don Seiler wrote: > >> I'm curious, why even copy the pg_log logs? They aren't needed for >> database restore or recovery. > > Also, relocating the log directory is easy using the log_directory > setting, so that's what I recom

Re: pg 10.1 missing libpq in postgresql-devel

2018-01-25 Thread Martin Marques
El 25/01/18 a las 17:20, support-tiger escribió: > running postgresql 10.1 on Fedora 27.  Cannot install ruby pg gem due to > missing libpq-fe.h file.  This is usually found in postgresql-devel but > it is not in fedora 27 postgresql10-devel. If install postgresql-devel > (9.6) the gem installs wit

Re: Does PostgreSQL check database integrity at startup?

2017-12-26 Thread Martin Marques
El 26/12/17 a las 14:46, Edson Carlos Ericksson Richter escribió: > > Usually, or by "pg_basebackup" or by "rsync" as described in PostgreSQL > Wiki. > Right now, I'm doing via pg_basebackup. > Nothing extraordinary. > > When using rsync: > > rsync -e "ssh -2 -C -p slave_ssh_port" --progress --p

Re: Does PostgreSQL check database integrity at startup?

2017-12-26 Thread Martin Marques
El 26/12/17 a las 09:52, Edson Carlos Ericksson Richter escribió: > 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?

Re: Stand by server (9.6.6) with corrupt file

2017-12-23 Thread Martin Marques
El 22/12/17 a las 10:29, Edson Carlos Ericksson Richter escribió: > Environment: PostgreSQL 9.6.6 installed from yum repository. Oracle > Linux 7 EL x64. Dell servers with Raid 5 (hw). > > > I was testing our database backup system (based on pgBarman), and > discovered that one base file is corru

Re: Deadlock between concurrent index builds on different tables

2017-12-23 Thread Martin Marques
El 22/12/17 a las 18:53, Jeremy Finzel escribió: > I am attempting to build several indexes in parallel, guaranteeing that > I never build one on the same table twice.  I understand I can't build > two on the same table at once or I will get a deadlock.  However, I am > also getting a deadlock when

Re: Deadlock between concurrent index builds on different tables

2017-12-23 Thread Martin Marques
El 23/12/17 a las 08:08, Alban Hertroys escribió: > >> On 22 Dec 2017, at 22:53, Jeremy Finzel wrote: >> >> 2017-12-22 15:48:07.669 CST,"CREATE INDEX",2017-12-22 15:48:02 >> CST,8/32,0,ERROR,40P01,"deadlock detected","Process 4470 waits for ShareLock >> on virtual transaction 4/262; blocked by