Re: Problem with pg_dumpall

Ryan Bradetich <ryan_bradetich(at)hp(dot)com> writes:
> That was the problem. Good job at spotting that Tom. I just successfully
> completed a backup without using the -o
> option to pg_dumpall.

OK, if you need it with -o try the following patch against 7.0.2.

regards, tom lane

*** src/backend/commands/copy.c.orig Wed Jun 28 02:07:58 2000
--- src/backend/commands/copy.c Wed Jun 28 02:13:01 2000
***************
*** 484,491 ****

if (oids && !binary)
{
! CopySendString(oidout(tuple->t_data->t_oid), fp);
CopySendChar(delim[0], fp);
}

for (i = 0; i < attr_count; i++)
--- 484,493 ----

if (oids && !binary)
{
! string = oidout(tuple->t_data->t_oid);
! CopySendString(string, fp);
CopySendChar(delim[0], fp);
+ pfree(string);
}

for (i = 0; i < attr_count; i++)