Re: Problem with pg_dump

["Alex Turner" <armtuk@xxxxxxxxx>]

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

Alex

On 11/10/06, Alex Turner < armtuk@xxxxxxxxx> 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.5 to see if that would fix the problem, but it didn't

Alex

On 11/10/06, Joshua D. Drake <jd@xxxxxxxxxxxxxxxxx > wrote:

On Fri, 2006-11-10 at 11:23 -0500, Tom Lane wrote:
> "Alex Turner" < armtuk@xxxxxxxxx> 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