CREATE ROLE and pg_dump
CREATE ROLE and pg_dump
От:
kmh496 <kmh496@kornet.net>
Дата:
I am upgrading from 8.0.3 to 8.1 and so i did a pg_dump -d dbname > dump.sql then did a "cat dump.sql | psql -d dbname" but there are errors such as this one: ERROR: role "joe" does not exist ERROR: role "joe" does not exist ERROR: role "joe" does not exist ERROR: role "joe" does not exist ERROR: role "joe" does not exist ERROR: role "joe" does not exist ERROR: role "joe" does not exist is there no flag to pg_dump to tell it to dump the create user statements as well? thanks. is there a way to get users dumped as well? -- who am I?.
Re: CREATE ROLE and pg_dump
От:
Adam Witney <awitney@sgul.ac.uk>
Дата:
kmh496 wrote: > I am upgrading from 8.0.3 to 8.1 and so i did a pg_dump -d dbname > > dump.sql then did a "cat dump.sql | psql -d dbname" > but there are errors such as this one: > ERROR: role "joe" does not exist > ERROR: role "joe" does not exist > ERROR: role "joe" does not exist > ERROR: role "joe" does not exist > ERROR: role "joe" does not exist > ERROR: role "joe" does not exist > ERROR: role "joe" does not exist > > is there no flag to pg_dump to tell it to dump the create user > statements as well? > > thanks. > > is there a way to get users dumped as well? I think you have to use pg_dumpall to dump users as well -- This message has been scanned for viruses and dangerous content by MailScanner, and is believed to be clean.
