Re: Problem with pg_dump
| От | Alex Turner |
|---|---|
| Тема | Re: Problem with pg_dump |
| Дата | |
| Msg-id | 33c6269f0611100837i3f76ba44y4ac2e82d5c792d59@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Problem with pg_dump ("Joshua D. Drake" <jd@commandprompt.com>) |
| Ответы |
Re: Problem with pg_dump
Re: Problem with pg_dump Re: Problem with pg_dump |
| Список | pgsql-general |
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
#!/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
В списке pgsql-general по дате отправления: