On Thu, Aug 22, 2024 at 7:06 AM Vince McMahon <sippingonesandze...@gmail.com> wrote:
> Hi, > > I have some questions When doing pg_restore of backup of a database to a > NEW server. > > Is there a way to ensure the data integrity is in tact, and user ID and > access works liked how it was in the old server? > pg_restore is just a bunch of CREATE, COPY and ALTER statements, since pg_restore replays what was generated by pg_dump. There can be errors, of course. That's why I run "createdb $DB 2> /dev/null" to ensure that there's something for pg_restore to drop, then "pg_restore --create --clean --exit-on-error", and *most importantly*, check the return code!!! How to properly handle the materialized views when backing up and restoring? > > Thanks. > -- Death to America, and butter sauce. Iraq lobster!
