Re: [GENERAL] Index corruption & broken clog

I seem that a failed vmotion occured in the same time frame.

Re: [GENERAL] Index corruption & broken clog

Thanks for the help. > Shut down the corrupted database and make a physical backup of it. > I did it before trying anything. > Check the disks and memory on the machine where the problem occurred. > We are using virtual machines (VMWare). I will ask then to investigate anyway. > You can t

[GENERAL] Index corruption & broken clog

Hi, One of my PostgreSQL server crashed badly yesterday. A process was killed (see dmesg below) and postgres was stuck with theses process: postgres 2083 1 0 Oct08 ?00:19:02 /usr/lib/postgresql/9.5/bin/postgres -D /home/postgres/data/i090/systeme postgres 2221 2083 0 Oct08 ?

[GENERAL] Explain analyse and toasted data.

Hi, In this video (PostgreSQL at 10 TB and beyond: https://youtu.be/8mKpfutwD0U at 6mn05), the speaker says that on very big databases explain analyse can give unrealistic results because it doesn't read toasted data. I suppose it's because of this: "The big values of TOASTed attributes will only

Re: [GENERAL] NOTIFY command impact

Hi ! Indeed :) Thanks for taking the time to explain ! Benoit.

Re: [GENERAL] NOTIFY command impact

Hi, I might have missed something. This should be enough to solve the problem no ? SELECT CASE WHEN pg_last_xlog_receive_location() = pg_last_xlog_replay_location() THEN 0 ELSE EXTRACT (EPOCH FROM now() - pg_last_xact_replay_timestamp())::INTEGER END AS replication_lag; Benoit.

Re: [GENERAL] clarification about standby promotion

hi, Tank you for the confirmation ! For the second part, I understand your explanation but I fail to see how checking what we have replayed against what we have received will confirm we have received everything (unless we are in sync replication). Have a good day ! Benoit.

[GENERAL] clarification about standby promotion

Hi, I would like to clarify something about standby promotion. From the sentence below. I understand that, during the promotion process, postgres will replay all the available wals (from the archive or pg_xlog). https://www.postgresql.org/docs/9.5/static/warm-standby.html#STREAMING-REPLICATION

[GENERAL] Re: [GENERAL] [GENERAL] Replication between différent versions of the same OS.

Thanks a lot. That s what I was looking for ;) Yes, I was trying to avoid logical replication. I guess it s time for me to delve into it...

[GENERAL] [GENERAL] Replication between différent versions of the same OS.

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 since PostgreSQL uses the OS libraries for encoding. It could cause silent c

[GENERAL] PGDATA / data_directory

Hi, My company is using PGDATA to store configuration files and the guc data_directory to give the path to the instance directory. They would use it like this: pg_ctl start -D -w with this directory setup: /CONFDIR => postgresql.conf pg_hba.conf pg_ident.conf /SYSTEM => All the normal stuff i