PostgreSQL Cascade streaming replication problem

2018-04-02 Thread Jakub Janeček
Hi everyone, i have one master and two slaves - cascading replication. Master -> Slave1 -> Slave2 Slave2 crashed two days ago. Problem is on Slave1, where are comulating WAL files. Archive mode is turn off. There is about 6.000 WAL Files, but in folder archive_status are files with .done name. H

Re: Please suggest the best suited unit test frame work for postgresql database.

2018-04-02 Thread Steven Lembark
On Sun, 1 Apr 2018 10:26:32 +0530 Raghavendra Rao J S V wrote: > Good morning. > > Please suggest the best suited unit test frame work for postgresql > database and also shared the related documents to understand the > framework. If anyone there knows Perl (if not I'll be happy to teach it) you

Re: Please suggest the best suited unit test frame work for postgresql database.

2018-04-02 Thread Rob Sargent
On 04/02/2018 10:58 AM, Steven Lembark wrote: On Sun, 1 Apr 2018 10:26:32 +0530 Raghavendra Rao J S V wrote: Good morning. Please suggest the best suited unit test frame work for postgresql database and also shared the related documents to understand the framework. If anyone there knows Pe

How to get an inclusive interval when using daterange

2018-04-02 Thread hmidi slim
Hi, I have a table* availability* which contains 3 columns: * id, product_id and period_availability(type daterange).* When I insert a data into this table I use this query: insert into availability values ('product x', daterange('2018-02-02', '2018-03-01', '[]') So I get a period like this: [201

Re: How to get an inclusive interval when using daterange

2018-04-02 Thread Tom Lane
hmidi slim writes: > When I insert a data into this table I use this query: > insert into availability values ('product x', daterange('2018-02-02', > '2018-03-01', '[]') > So I get a period like this: [2018-02-02, 2018-03-02) Yup. > In my app I tried to subtract a day from the period when I got

Re: PostgreSQL Cascade streaming replication problem

2018-04-02 Thread Michael Paquier
On Sun, Apr 01, 2018 at 06:26:51PM +, Jakub Janeček wrote: > What did i do wrong? I need stop comulating WAL files and remove old WAL > files, which are processed and are only "waiting".. Perhaps wal_keep_segments is set and you forgot about it or you used a replication slot that you forgot to

Re: PostgreSQL Cascade streaming replication problem

2018-04-02 Thread Jakub Janeček
I have set up wal_keep_segments = 100 on Slave1, but no effect. I tried comment wal_keep_segments, no effect too... Actually i have 8.500 WAL Files, disk space is low. I tried drop replication slot on Slave1, no effect. Is possible to manually remove WAL files? Thanks *Jakub* 2018-04-03 4:43 GMT

Re: PostgreSQL Cascade streaming replication problem

2018-04-02 Thread Jakub Janeček
Hi everyone, problem is solved. There was a delay between setup (drop replication slot) and execution. Jakub 2018-04-03 4:43 GMT+02:00 Michael Paquier : > On Sun, Apr 01, 2018 at 06:26:51PM +, Jakub Janeček wrote: > > What did i do wrong? I need stop comulating WAL files and remove old WAL

Autovacuum Problem

2018-04-02 Thread Kein Name
Hello List, I inherited a machine with an Postgres Database, which I am fighting with right now. It seems as if the Database is growing bigger and bigger over time. Once in a while I have to run a VACUUM FULL statement on a few tables, which then releases a lot of space to the OS. By reading the

Re: Autovacuum Problem

2018-04-02 Thread Achilleas Mantzios
On 03/04/2018 09:36, Kein Name wrote: However no space seems to be freed to the system. Is there any way a bloody newbie can debug this behaviour? VACUUM <> VACUUM FULL Normally running VACUUM via autovacuum should help reuse free space but not actually return it to the filesystem / OS (unles