Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf'

2023-10-03 Thread Harry Green
2 BST, David G. Johnston wrote: On Wed, Sep 20, 2023 at 2:06 PM Harry Green 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

Re: [EXT]Re: Connection not allowed because of an error 'Not in pg_hba.conf'

2023-09-20 Thread Harry Green
Thanks for your  answer,I have done a complete pg_dump and complete restore, and tried all forms of complete pg_dumps and restores (i.e. the different formats). There is no partial or tables only or data only dumping or restoring. Further, you refer to a 'check constraint' but this is just a fu

Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order

2023-09-20 Thread Harry Green
would be great! On Monday, 18 September 2023 at 20:29:19 BST, Laurenz Albe wrote: On Mon, 2023-09-18 at 15:08 +, Harry Green wrote: > I am having trouble restoring a database backed up with pg_dump/pg_dump_all. > The error messages I get are below and appear to suggest that cer

trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order

2023-09-18 Thread Harry Green
Hello, I am having trouble restoring a database backed up with pg_dump/pg_dump_all. The error messages I get are below and appear to suggest that certain sql-language or pl/pgsql-language functions which include an sql statement referencing a table are trying to be executed before the table whic