Thread: pg_dump problem.

pg_dump problem.

From
"Michael"
Date:
Hi, all,
 
I run pg_dump -s to back up my database and get this error message:
 
pg_dump: could not parse ACL list ([0:1]={pgsql=UC/pgsql,=UC/pgsql}) for
object "public" (SCHEMA) 
 
Can someone tell me why?
pgsql is the username.
postgresql version:pre-release version of postgresql 7.5 windows edition.
os: win xp pro.
 
Thanks in advance.
Best regrads,
Michael

Re: pg_dump problem.

From
Tom Lane
Date:
"Michael" <cutemic@hotmail.com> writes:
> I run pg_dump -s to back up my database and get this error message:

> pg_dump: could not parse ACL list =
> ([0:1]=3D{pgsql=3DUC/pgsql,=3DUC/pgsql}) for=20
> object "public" (SCHEMA)=20

> Can someone tell me why?

You're using a buggy beta version.

            regards, tom lane

Re: pg_dump problem.

From
"Michael"
Date:
Hi,

I download the latest version of postgresql (8.0 for windows) and fix the
problem.
But here comes another one.
The sql script I dump from v8.0 seems to be not full compatible with v7.4
used on the server. So I'm unable to update the database on the server to
the local one.
What can I do?

Regards,
Michael

----- Original Message -----
From: "Tom Lane" <tgl@sss.pgh.pa.us>
To: "Michael" <cutemic@hotmail.com>
Cc: <pgsql-admin@postgresql.org>
Sent: 2005年3月21日 星期一 10:57
Subject: Re: [ADMIN] pg_dump problem.


| "Michael" <cutemic@hotmail.com> writes:
| > I run pg_dump -s to back up my database and get this error message:
|
| > pg_dump: could not parse ACL list =
| > ([0:1]=3D{pgsql=3DUC/pgsql,=3DUC/pgsql}) for=20
| > object "public" (SCHEMA)=20
|
| > Can someone tell me why?
|
| You're using a buggy beta version.
|
| regards, tom lane
|
| ---------------------------(end of broadcast)---------------------------
| TIP 4: Don't 'kill -9' the postmaster
|