Re: [GENERAL] What is "return code" for WAL send command

2010-10-25 Thread zhong ming wu
On Mon, Oct 25, 2010 at 1:58 PM, Fredric Fredricson wrote: >  On 10/25/2010 01:19 PM, David W Noon wrote: >> > Ah, yes of course, It was a while ago I played with cron. > "man 5 crontab" is also a good command to know, or > "info crontab" if you prefer those modern inventions. > This is nothing t

Re: [GENERAL] What is "return code" for WAL send command

2010-10-25 Thread Fredric Fredricson
On 10/25/2010 01:19 PM, David W Noon wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, 25 Oct 2010 09:49:02 +0200, Fredric Fredricson wrote abour Re: [GENERAL] What is "return code" for WAL send command: On 10/23/2010 02:01 PM, zhong ming wu wrote: [snip] For some

Re: [GENERAL] What is "return code" for WAL send command

2010-10-25 Thread David W Noon
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Mon, 25 Oct 2010 09:49:02 +0200, Fredric Fredricson wrote abour Re: [GENERAL] What is "return code" for WAL send command: > On 10/23/2010 02:01 PM, zhong ming wu wrote: [snip] >> For some reason it failed recently with "r

Re: [GENERAL] What is "return code" for WAL send command

2010-10-25 Thread Fredric Fredricson
On 10/23/2010 02:01 PM, zhong ming wu wrote: Hello I have a master PG 8.1.11 sending WAL files to a cold-standby using rsync For some reason it failed recently with "return codes 32512" and I couldn't find this num. as a valid rsync exit code During the time that the error was going on I t

Re: [GENERAL] What is "return code" for WAL send command

2010-10-24 Thread Tom Lane
zhong ming wu writes: > postgres user has both rsync and ssh in its path but is it possible > that it is not using $PATH ? > One other thing is that just before the error the postgres was > restarted by other admin with rc.d/postgresql command > instead of pg_ctl which is what I normally use. Pe

Re: [GENERAL] What is "return code" for WAL send command

2010-10-24 Thread zhong ming wu
On Sat, Oct 23, 2010 at 11:48 AM, Tom Lane wrote: > > A more recent version of Postgres would break that down for you: it > means the subprocess exited with exit(127).  A look in the shell > man page suggests this is a "command not found" failure.  Maybe > there's something flaky about where you h

Re: [GENERAL] What is "return code" for WAL send command

2010-10-23 Thread Tom Lane
zhong ming wu writes: > I have a master PG 8.1.11 sending WAL files to a cold-standby using rsync > For some reason it failed recently with "return codes 32512" and I couldn't > find this num. as a valid rsync exit code > During the time that the error was going on I tried the rsync command > ma

[GENERAL] What is "return code" for WAL send command

2010-10-23 Thread zhong ming wu
Hello I have a master PG 8.1.11 sending WAL files to a cold-standby using rsync For some reason it failed recently with "return codes 32512" and I couldn't find this num. as a valid rsync exit code During the time that the error was going on I tried the rsync command manually and didn't error C