Re: Problem with pg_dump

Alex Turner <armtuk(at)gmail(dot)com> 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°