Re: Problem with pg_dump

I would be happy to point someone to the dump file, it's about 500Meg though

Alex

On 11/10/06, Alex Turner <armtuk(at)gmail(dot)com> wrote:
>
> 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
> >
> >
> >
> >
>