Vivek Khera wrote:
>
> there is no user with ID 102 in the pg_user view. pg_restore complains
> about the missing user "102". And no, the user was not "102" it was the
> name of a (former) employee.
> The gross hack is to pg_restore to an ascii file and delete those GRANT
> lines, but the compressed dump is over 2Gb for this database.
Am I missing something Vivek, or should the gross hack be "creating a
user with id=102" ?
--
Richard Huxton
Archonet Ltd