Alex Turner <[EMAIL PROTECTED]> schrieb: > Sure thing, I hope it's as simple as user error! > > #!/bin/sh > export DATE=`date +%Y%m%d` > > /usr/local/pgsql/bin/pg_dump -Upostgres -hlocalhost trend > /backup/ > trend.dump.$DATE > > Thats pretty much it repeated for each database. I just upgraded to 8.1.5 to > see if that would fix the problem, but it didn't
I can't believe that. Please, create a new, simple database, create a table with a index in this db, make a dump and paste this on http://rafb.net/paste/ and tell us the link. Something like this: http://rafb.net/paste/results/8NHxOb70.html Line 62 creates the INDEX. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889° ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
