pg_restore -N loses extension comment
| От | Justin Pryzby |
|---|---|
| Тема | pg_restore -N loses extension comment |
| Дата | |
| Msg-id | ZjoeirG7yxODdC4P@pryzbyj2023 обсуждение исходный текст |
| Ответы |
Re: pg_restore -N loses extension comment
|
| Список | pgsql-hackers |
pg_dump -Fc |pg_restore -l -N schema: | 2; 3079 18187 EXTENSION - pg_buffercache Without -N schema also shows: | 2562; 0 0 COMMENT - EXTENSION pg_buffercache I mean literal s-c-h-e-m-a, but I suppose anything else will work the same. BTW, I noticed that pg_restore -v shows that duplicate dependencies can be stored. We see things like this (and worse). | 4284; 1259 191439414 VIEW public wmg_server_view telsasoft | ; depends on: 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612 612612 23087 612 I see that's possible not only for views, but also tables. That's probaably wasteful of CPU, at least. -- Justin
В списке pgsql-hackers по дате отправления: