pg_dump problem

From: Kees Leune <C(dot)J(dot)Leune(at)kub(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_dump problem
Date: 1998-08-24 09:25:30
Message-ID: Pine.SOL.4.00.9808241107510.3136-100000@picnix
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have a problem with the dump&restore process. When I dump my database,
the users I have are not created in the dump. I solved this process by
adding 'create user' statements to the beginning of the dump file.

I need to dump my database with all grant/revoke permissions, since I have
a lot of tables that have modified access permissions.

Dumping this isn't a problem (-z parameter with pg_dump/pg_dumpall), only
restoring the dump is. I would have expected a number of grant and revoke
statements in the dump, but instead, the script tries to run a few
update queries on pg_class directly.

During the restore process, all I get is 'permission denied'-messages when
the script tries to execute the updates on pg_class. Apparently, users do
not have direct modification rights on pg_class in version 6.3.2 and
everything has to be done with grant and revoke permissions (is this
true?).

Do you have a suggestion on how I can fix this problem? I really do
not want to go through my dump manually since it's well over 10Gb.....

Thanks in advance,

-kees
--
Kees Leune, Researcher at the Infolab | Email: kees(at)kub(dot)nl
Tilburg University, The Netherlands | Phone: +31 13 466 2688
http://infolab.kub.nl/people/kees/ | HAM: PA3HFB

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gran Sterner 1998-08-24 12:47:19 Invisible tables in pgsql
Previous Message liuye 1998-08-24 08:30:40 Initdb cannot work with postgres 6.3.2 under RH5.0