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