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

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: 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

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 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: 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

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: 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

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

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