This may be with the pg_dumpall script from 7.1.3 but the restoration
died as a result of the owner not being able to create the database it
owned...
Steps to reproduce:
create a user [testuser] with createdb privilege (to create a database
that they own)
create a database testdb using testuser's account
drop the createdb privilege from testuser (so they can't create an more
databases)
add a table to the testdb as testuser
pg_dumpall > dump.pgsql
upgrade to postgresql 7.2
psql -U postgres template1 < dump.pgsql*it dies here*
Can pg_dumpall create the script where user postgres creates the
database and the assigns the owner to another user rather than assuming
the owner can create the database?
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.