The new one "works for me." I have even had the opportunity to actually
use it on my test station. I was once again reminded that excercising
super user powers while tired is _not_ a good idea. I suppose that is
why most Unix admins are addicted to caffeine :).
Jason
Nico De Ranter wrote:
>
> 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]
************
