On Sep 29, 2004, at 4:55 PM, Richard Huxton wrote:
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" ?
And how exactly does one accomplish this? pg_users is a view so you can't insert into it.
Vivek Khera, Ph.D. +1-301-869-4449 x806
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
