Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf' - Mailing list pgsql-general

From David G. Johnston
Subject Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf'
Date
Msg-id CAKFQuwbHKszDcz+Pcfmirvq+LuTfEQrHPnGDGxnPHq1a8MEazw@mail.gmail.com
Whole thread Raw
In response to Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf'  (Harry Green <harrygreen91@yahoo.com>)
Responses Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf'  (Harry Green <harrygreen91@yahoo.com>)
List pgsql-general
On Wed, Sep 20, 2023 at 2:06 PM Harry Green <harrygreen91@yahoo.com> wrote:
I attach the text of the entire create function instruction, and also of the create table instruction. 


The restore is not going to execute functions on its own and you've only shown two create statements.  Somewhere else in your dump file the function check_account_from_bill_items must be referenced in order for it to be called.  You need to show that.  It is not the function creation that is going to be illegal, it will be, like Adrian said, something like using a volatile function in a check constraint that is going to be illegal.

We are working with version 10.23, and I cannot send you the entire output of the pg_dump file because it is 3.3 GB, but am happy to send you any parts that might help. 


I doubt a schema-only dump is going to be that large...but you are right that you should be trying harder to isolate this down to a reproducible test case and thus be able to provide more information without it being too much.

David J.

pgsql-general by date:

Previous
From: veem v
Date:
Subject: Re: Database selection
Next
From: Christophe Pettus
Date:
Subject: Re: Database selection