Re: [GENERAL] Wal files - Question | Postgres 9.2

2016-11-30 Thread Patrick B
2016-12-01 14:15 GMT+13:00 David G. Johnston : > On Wed, Nov 30, 2016 at 6:05 PM, Patrick B > wrote: > >> https://www.postgresql.org/docs/9.2/static/runtime-config- >> replication.html >> >> wal_keep_segments is the parameter responsible for streaming replication >> be able to recover itself with

Re: [GENERAL] Wal files - Question | Postgres 9.2

2016-11-30 Thread David G. Johnston
On Wed, Nov 30, 2016 at 6:05 PM, Patrick B wrote: > https://www.postgresql.org/docs/9.2/static/runtime-config-replication.html > > wal_keep_segments is the parameter responsible for streaming replication > be able to recover itself without using wal_files, is that right? > [...] ​without using w

Re: [GENERAL] Wal files - Question | Postgres 9.2

2016-11-30 Thread Patrick B
2016-11-29 23:59 GMT+13:00 Patrick B : > > > 2016-11-29 16:36 GMT+13:00 David G. Johnston : > >> On Mon, Nov 28, 2016 at 8:22 PM, Patrick B >> wrote: >> >>> >>> Ho >>> ​[w] >>> is that even possible?? I don't understand! >>> >>> >> ​https://www.postgresql.org/docs/9.2/static/warm-standby.html >>

Re: [GENERAL] Wal files - Question | Postgres 9.2

2016-11-29 Thread Patrick B
2016-11-29 16:36 GMT+13:00 David G. Johnston : > On Mon, Nov 28, 2016 at 8:22 PM, Patrick B > wrote: > >> >> Ho >> ​[w] >> is that even possible?? I don't understand! >> >> > ​https://www.postgresql.org/docs/9.2/static/warm-standby.html > """​ > > If you use streaming replication without file-ba

Re: [GENERAL] Wal files - Question | Postgres 9.2

2016-11-28 Thread David G. Johnston
On Mon, Nov 28, 2016 at 8:22 PM, Patrick B wrote: > > Ho > ​[w] > is that even possible?? I don't understand! > > ​https://www.postgresql.org/docs/9.2/static/warm-standby.html """​ If you use streaming replication without file-based continuous archiving, you have to set wal_keep_segments in the

Re: [GENERAL] Wal files - Question | Postgres 9.2

2016-11-28 Thread Patrick B
2016-11-29 15:21 GMT+13:00 David Steele : > On 11/24/16 8:05 PM, Patrick B wrote: > > > hmm.. I really don't get it. > > > > > > > > If I get messages like: > > > > *cp: cannot stat '/walfiles/00021AF800A5': No such file or > > director*y > > > > In my head, it's saying that it was una

Re: [GENERAL] Wal files - Question | Postgres 9.2

2016-11-28 Thread David Steele
On 11/24/16 8:05 PM, Patrick B wrote: > hmm.. I really don't get it. > > > > If I get messages like: > > *cp: cannot stat '/walfiles/00021AF800A5': No such file or > director*y > > In my head, it's saying that it was unable to recover that file and, > because of that, there is m

Re: [GENERAL] Wal files - Question | Postgres 9.2

2016-11-24 Thread Michael Paquier
On Fri, Nov 25, 2016 at 10:05 AM, Patrick B wrote: > If I get messages like: > > cp: cannot stat '/walfiles/00021AF800A5': No such file or > directory > > In my head, it's saying that it was unable to recover that file and, because > of that, there is missing data. > Even if the server

Re: [GENERAL] Wal files - Question | Postgres 9.2

2016-11-24 Thread Patrick B
2016-11-23 16:18 GMT+13:00 Venkata B Nagothi : > > On Wed, Nov 23, 2016 at 1:59 PM, Patrick B > wrote: > >> >> >> 2016-11-23 15:55 GMT+13:00 Venkata B Nagothi : >> >>> >>> >>> On Wed, Nov 23, 2016 at 1:03 PM, Patrick B >>> wrote: >>> Hi guys, I currently have a slave02 server that

Re: [GENERAL] Wal files - Question | Postgres 9.2

2016-11-22 Thread Venkata B Nagothi
On Wed, Nov 23, 2016 at 1:59 PM, Patrick B wrote: > > > 2016-11-23 15:55 GMT+13:00 Venkata B Nagothi : > >> >> >> On Wed, Nov 23, 2016 at 1:03 PM, Patrick B >> wrote: >> >>> Hi guys, >>> >>> I currently have a slave02 server that is replicating from another >>> slave01 via Cascading replication.

Re: [GENERAL] Wal files - Question | Postgres 9.2

2016-11-22 Thread Patrick B
2016-11-23 15:55 GMT+13:00 Venkata B Nagothi : > > > On Wed, Nov 23, 2016 at 1:03 PM, Patrick B > wrote: > >> Hi guys, >> >> I currently have a slave02 server that is replicating from another >> slave01 via Cascading replication. The master01 server is shipping >> wal_files (via ssh) to both slav

Re: [GENERAL] Wal files - Question | Postgres 9.2

2016-11-22 Thread Venkata B Nagothi
On Wed, Nov 23, 2016 at 1:03 PM, Patrick B wrote: > Hi guys, > > I currently have a slave02 server that is replicating from another slave01 > via Cascading replication. The master01 server is shipping wal_files (via > ssh) to both slaves. > > > I'm doing some tests on slave02 to test the recovery

[GENERAL] Wal files - Question | Postgres 9.2

2016-11-22 Thread Patrick B
Hi guys, I currently have a slave02 server that is replicating from another slave01 via Cascading replication. The master01 server is shipping wal_files (via ssh) to both slaves. I'm doing some tests on slave02 to test the recovery via wal_files... The goal here is to stop postgres, wait few min