I've used this command to dump just the table concerned, and I get a zero length file!?! No errors or anything, just a silent exit.
pg_dump -U xx-S xx -F t -a -t tablename mydatabase > ~/backup/mytable
Any ideas? I'm thinking the zero-sized file could be what was causing the read()s to fail, but as to why it's happening in the first place I can't think..
Cheers
Shane
On 11 Nov 2003, at 19:52, Jeff wrote:
read(0, "", 4096) = 0 read(0, "", 4096) = 0 read(0, "", 4096) = 0 read(0, "", 4096) = 0 read(0, "", 4096) = 0 read(0, "", 4096) = 0 read(0, "", 4096) = 0 read(0, "", 4096) = 0
fd 0 is usually stdin, unless the program disconnects stdin. Maybe pg_restore is waiting for input, perhaps a password?
-- Jeff Trout <[EMAIL PROTECTED]> http://www.jefftrout.com/ http://www.stuarthamm.net/
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
