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]
>
> ************
************
