Unfortunately I had to many tables and permissions to set everything by hand
so I ended up editing the dump file by hand. That seems to have solved the problem.
I do hope however, that the latest version has a working pg_dumpall utility.
Anyway, thanks.
Nico
On Wed, 15 Dec 1999, Jason Earl wrote:
> It seems to me that I ran into a similiar problem recently. I also had
> trouble loading tables with their permissions. This is fixed in the
> newer versions, (if you are upgrading now make sure you get 6.5.3) but
> for now the trick is to get your table moved across.
>
> Would it be possible to do a pg_dumpall without the -z option and then
> simply set the permissions manually when you are done? That is what I
> ended up doing.
>
> Jason
>
> Nico De Ranter wrote:
> >
> > Howdy,
> >
> > I'm currently trying to move a postgres database from an old Mac running
> > MkLinux and Postgresql 6.4 to a new PC running Debian Linux and Postgresql 6.5.
> > I did a "pg_dumapll -z > dumps" on 6.4, tranfered the file to the 6.5 and then
>tried
> > "pgsl -e < dumps 2>&1 | tee error.log". Unfortunately in the error log I
> > get a lot of messages like:
> >
> > CREATE TABLE "telzone" ("destination" char(6), "rate" "int2");
> > QUERY: CREATE TABLE "telzone" ("destination" char(6), "rate" "int2");
> > REVOKE ALL on "telzone" from PUBLIC;
> > QUERY: REVOKE ALL on "telzone" from PUBLIC;
> > GRANT SELECT on "tacacs" to "tacacs";
> > QUERY: GRANT SELECT on "tacacs" to "tacacs";
> > ERROR: ChangeAcl: class "tacacs" not found
> >
> > Any idea why this would happen? Is there a better alternative for pg_dumpall?
> >
> > Nico
> >
> > --------------------------------------------------------
> > "It has been said that there are only two businesses
> > refer to customers as users: illegal drug trade and
> > the computer industry."
> > --------------------------------------------------------
> > Nico De Ranter
> > Sony Service Center (SUPC-E/NSSE)
> > Sint Stevens Woluwestraat 55 (Rue de Woluwe-Saint-Etienne)
> > 1130 Brussel (Bruxelles), Belgium, Europe, Earth
> > Telephone: +32 2 724 86 41 Telefax: +32 2 726 26 86
> > e-mail: [EMAIL PROTECTED]
> >
> > ************
>
--------------------------------------------------------
"It has been said that there are only two businesses
refer to customers as users: illegal drug trade and
the computer industry."
--------------------------------------------------------
Nico De Ranter
Sony Service Center (SUPC-E/NSSE)
Sint Stevens Woluwestraat 55 (Rue de Woluwe-Saint-Etienne)
1130 Brussel (Bruxelles), Belgium, Europe, Earth
Telephone: +32 2 724 86 41 Telefax: +32 2 726 26 86
e-mail: [EMAIL PROTECTED]
************
