Re: Problem with pg_dump

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.5to see if that would fix the problem, but it didn't

Alex

On 11/10/06, Joshua D. Drake <jd(at)commandprompt(dot)com> wrote:
>
> On Fri, 2006-11-10 at 11:23 -0500, Tom Lane wrote:
> > "Alex Turner" <armtuk(at)gmail(dot)com> writes:
> > > Well yes - thats what I mean, the definition for the index. It's not
> > > dumping the index defs. It also looks like it's not dumping roles
> fully
> > > either. I was missing grants from the dump too.
> >
> > [ raised eyebrow... ] Let's see a test case.
>
> Alex, what Tom is saying here is... this is likely user error :). Can
> you provide the exact pg_dump command you are using?
>
> Sincerely,
>
> Joshua D. Drake
>
>
>
> >
> > regards, tom lane
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: Don't 'kill -9' the postmaster
> >
> --
>
> === The PostgreSQL Company: Command Prompt, Inc. ===
> Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
> Providing the most comprehensive PostgreSQL solutions since 1997
> http://www.commandprompt.com/
>
> Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
>
>
>
>