Sample Header Ad - 728x90

pg_restore drops extension plpgsql

1 vote
1 answer
91 views
We face a situation where pg_restore drops extension plpgsql and then recreates it. This is done by a CI job we have but i could not reproduce it. These are the commands we use: - pg_dump -d \$DATABASE_URL -j 8 -Z 0 -Fd -f ${backupDir} - psql -d \$DATABASE_URL -c \"DROP SCHEMA IF EXISTS public CASCADE; - psql \$DATABASE_URL -c \"CREATE SCHEMA public; GRANT ALL ON SCHEMA public TO public; - pg_restore --verbose --clean --no-owner -d \$DATABASE_URL -j 8 --format=d ${backupDir} And these are the logs:
Asked by Vasileios Giannakidis (13 rep)
Sep 28, 2023, 09:48 AM
Last activity: Sep 28, 2023, 10:23 AM