Re: Problem with pg_dump - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Problem with pg_dump
Date
Msg-id 20061110165726.GB26485@KanotixBox
Whole thread Raw
In response to Re: Problem with pg_dump  ("Alex Turner" <armtuk@gmail.com>)
Responses Re: Problem with pg_dump
List pgsql-general
Alex Turner <armtuk@gmail.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°

pgsql-general by date:

Previous
From: Enrico
Date:
Subject: Re: Datum problem
Next
From: Alan Hodgson
Date:
Subject: Re: Problem with pg_dump