Mysterious (bogus?) rsync(d) errors -- (code 23) at main.c(1045)

[Josh Berkus]

John,

> Which version of rsync are you using (on source and target)?

rsync  version 2.5.7  protocol version 26
Copyright (C) 1996-2002 by Andrew Tridgell and others
<http://rsync.samba.org/>
Capabilities: 64-bit files, socketpairs, hard links, symlinks, batchfiles,
              IPv6, 64-bit system inums, 64-bit internal inums
.... oh, yeah, the servers are 64-bit.  Opteron.

> What is the output of "ls -ld /pgdata" on both machines?  I suspect that
> on the target it was created with non-postgres userid.

[root at monica]# ls -ld /pgdata
drwxr-xr-x    3 postgres dba          4096 May  5 19:06 /pgdata
[root at phoebe]# ls -ld /pgdata
drwxr-xr-x    3 postgres dba          4096 May  5 19:06 /pgdata

However, if you're talking about created, you're correct.  /pgdata is a mount; 
It was created by root and changed to postgres.

> What is the output of "ls -l" for the two "non-regular" files?
[root at monica pgdata]# ls -l pg_xlog
lrwxrwxrwx    1 root     root           13 May 10 15:24 pg_xlog 
-> /wal/pg_xlog/
[root at monica 17521]# ls -l pgsql_tmp
lrwxrwxrwx    1 root     root           20 May 10 15:24 pgsql_tmp 
-> /pgtmp/e1/pgsql_tmp/

[root at phoebe pgdata]# ls -l pg_xlog
lrwxrwxrwx    1 root     root           12 May 16 12:00 pg_xlog 
-> /wal/pg_xlog
[root at phoebe 17521]# ls -l pgsql_tmp
lrwxrwxrwx    1 root     root           20 May 16 12:00 pgsql_tmp 
-> /pgtmp/e1/pgsql_tmp/

More information from testing:

1) The rsync of /pgdata succeeds if I run it as root.
2) The rsync of /wal fails no matter who I run it as; often I get "IO Error" 
in addition to the previous error message.

--Josh

-- 
__Aglio Database Solutions_______________
Josh Berkus		       Consultant
josh at agliodbs.com	 www.agliodbs.com
Ph: 415-752-2500	Fax: 415-752-2387
2166 Hayes Suite 200	San Francisco, CA