Dump and restore postgresql users (roles)

  • dump on source database: pg_dumpall -r > sourceroles.backup
  • restore on target database:
    • if postgresql is freshly installed you will have to switch to postgres user: sudo su postgres
    • restore under postgres user: psql < sourceroles.backup

 

Submit a Comment

Your email address will not be published. Required fields are marked *