PostgreSQL database migration issues

Ali Alnubani alialnu at nvidia.com
Thu Jan 12 14:19:55 UTC 2023


> -----Original Message-----
> From: support-list <support-list-bounces at bugzilla.org> On Behalf Of
> Thorsten Schöning
> Sent: Wednesday, January 11, 2023 7:57 PM
> To: support-list at bugzilla.org
> 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


More information about the support-list mailing list