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