Re: pg_restore depending on user functions

2021-11-14 Thread Tom Lane
=?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= writes: > вс, 14 нояб. 2021 г. в 23:46, Tom Lane : >> This is not "details", this is an evidence-free assertion. Please show >> a concrete example of problematic functions. > Ok, I'll do it. > [ example ] This is pretty far from being a

Re: pg_restore depending on user functions

2021-11-14 Thread Дмитрий Иванов
Ok, I'll do it. > Сreating function A before function B results in a compilation error. On my part, this is an incorrect assumption. There are no compilation errors here. she just didn't recover from the first pass. вс, 14 нояб. 2021 г. в 23:46, Tom Lane : >

Re: pg_restore depending on user functions

2021-11-14 Thread Дмитрий Иванов
Ok, I'll do it. вс, 14 нояб. 2021 г. в 23:46, Tom Lane : > =?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= > writes: > > вс, 14 нояб. 2021 г. в 22:31, Tom Lane : > >> Usually this is caused by being careless about search_path assumptions > >> in your functions ... but with no details, it's

Re: Pg_hba.conf problem after unexpected IP change

2021-11-14 Thread Ray O'Donnell
On 14/11/2021 20:16, Adrian Klaver wrote: Actually that was already done: https://www.postgresql.org/message-id/CAOR%2BmccGARtFsb7c%2BF%3DRUk832%3DdaaJ8%2ByQW8eBYa1Krypr4O6Q%40mail.gmail.com The problems seems to have stemmed from this(per OP): "Well, it turns out that at one point when I

Re: Pg_hba.conf problem after unexpected IP change

2021-11-14 Thread Adrian Klaver
On 11/14/21 11:55, Ray O'Donnell wrote: On 14/11/2021 19:46, Yessica Brinkmann wrote: Hello. Thank you very much for your answer. The configuration actually works for me.After restarting my computer, I went to test again and it was already working. I assume that perhaps because they are

Re: Pg_hba.conf problem after unexpected IP change

2021-11-14 Thread Ray O'Donnell
On 14/11/2021 19:46, Yessica Brinkmann wrote: Hello. Thank you very much for your answer. The configuration actually works for me.After restarting my computer, I went to test again and it was already working. I assume that perhaps because they are virtual machines it was not only enough to

Re: Pg_hba.conf problem after unexpected IP change

2021-11-14 Thread Yessica Brinkmann
Hello. Thank you very much for your answer. The configuration actually works for me. After restarting my computer, I went to test again and it was already working. I assume that perhaps because they are virtual machines it was not only enough to restart the server, I think you also had to restart

Re: pg_restore depending on user functions

2021-11-14 Thread Tom Lane
=?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= writes: > вс, 14 нояб. 2021 г. в 22:31, Tom Lane : >> Usually this is caused by being careless about search_path assumptions >> in your functions ... but with no details, it's impossible to say >> anything with certainty. > No, in this case it is

Re: pg_restore depending on user functions

2021-11-14 Thread Дмитрий Иванов
Спасибо за ваш отзыв. вс, 14 нояб. 2021 г. в 22:31, Tom Lane : > =?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= > writes: > > 1. I can determine the dependencies of the custom functions when creating > > the pg_dump? I did not find anything suitable for SUPPORT, probably this > is > > not the

Re: pg_restore depending on user functions

2021-11-14 Thread Tom Lane
=?UTF-8?B?0JTQvNC40YLRgNC40Lkg0JjQstCw0L3QvtCy?= writes: > 1. I can determine the dependencies of the custom functions when creating > the pg_dump? I did not find anything suitable for SUPPORT, probably this is > not the case? > To recreate all of the functionality, I had to run schema recovery

Logical Replication - Source and Destination Table Name Not The Same

2021-11-14 Thread Avi Weinberg
Hi, Is it possible to define logical replication where the source and destination table names are not the same. I need to sync a table from some source, but already have a table with the same name. Thanks Avi IMPORTANT - This email and any attachments is intended for the above named

pg_restore depending on user functions

2021-11-14 Thread Дмитрий Иванов
Good day! Deploying a cluster: from PostgreSQL 12 Windows 10 (EDB) to PostgreSQL 14 Debian 11. In general, I succeeded, but there are a number of questions: 1. I can determine the dependencies of the custom functions when creating the pg_dump? I did not find anything suitable for SUPPORT, probably