RE: PostgreSQL database migration issues

> -----Original Message-----
> From: support-list <[email protected]> On Behalf Of
> Thorsten Schöning
> Sent: Wednesday, January 11, 2023 7:57 PM
> To: [email protected]
> Subject: Re: PostgreSQL database migration issues
> 
> Guten Tag Ali Alnubani,
> am Mittwoch, 11. Januar 2023 um 18:27 schrieben Sie:
> 
> > $ sudo -u postgres -- dropdb bugzilla
> > $ sudo -u postgres -- createdb bugzilla --encoding='UTF-8'
> > --locale=en_US.UTF-8 --owner=bugzilla
> > $ sudo -u postgres -- psql --single-transaction -d bugzilla -f bugzilla.sql -v
> ON_ERROR_STOP=1
> 
> Check the ownership of the created tables, they might not be owned by
> the user bugzilla and postgres instead. I think I had similar issues
> some time ago when Postgres didn't apply expected ownership depending
> on the version used or stuff... Can't find it right now, though.
> 
> > pg_restore -p 5433 --no-owner --role=owner2 -d db_name
> db_name.dump
> 

Hello Thorsten,

Restoring with pg_restore --owner=role doesn't reproduce the issue.

Thanks for the help,
Ali
_______________________________________________
support-list mailing list
[email protected]
https://lists.bugzilla.org/listinfo/support-list