Migrating from Neon project into another

I'm seeing an error like this:

ALTER DEFAULT PRIVILEGES FOR ROLE cloud_admin IN SCHEMA public GRANT SELECT,INSERT,REFERENCES,DELETE,TRIGGER,TRUNCATE,UPDATE ON TABLES TO neon_superuser WITH GRANT OPTION;

ALTER DEFAULT PRIVILEGES FOR ROLE cloud_admin IN SCHEMA public GRANT SELECT,INSERT,REFERENCES,DELETE,TRIGGER,TRUNCATE,UPDATE ON TABLES TO neon_superuser WITH GRANT OPTION;

This part seems like a something I don't necessarily want/need to migrate over. How do I work around this issue?

2 Replies

ratty-blushOP•13mo ago

For details on this, see https://neon.tech/docs/import/migrate-from-postgres#database-object-ownership-considerations.

Neon

Migrate data from Postgres with pg_dump and pg_restore - Neon Docs

This topic describes migrating data from one Postgres database to another using the pg_dump and pg_restore. Avoid using pg_dump over a pooled connection string (see PgBouncer issues 452 & 976 for deta...

ratty-blushOP•13mo ago

The non-fatal error still exists with --no-owner being set

Gaming

Programming

Migrating from Neon project into another

Did you find this page helpful?