From: | Arni Kromić <Arni(dot)Kromic(at)Bios-ICT(dot)hr> |
---|---|
To: | pgadmin-support(at)lists(dot)postgresql(dot)org |
Subject: | Schema backup failure |
Date: | 2019-08-09 09:56:49 |
Message-ID: | f7ab2d76-8747-be45-dd54-472add5703c4@Bios-ICT.hr |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
We've found a problem backing up some of our schemas from pgAdmin4.
After some investigation, we've found the problem being the schema names
need ident quoting - apparently because they contain capital letters.
For example, pgAdmin generated this code which fails:
> $ /usr/bin/pg_dump --file "testera" --host "/var/run/postgresql"
> --port "5432" --username "postgres" --no-password --verbose --format=c
> --blobs --schema "HR00000000001-2019" "nubes"
> pg_dump: last built-in OID is 16383
> pg_dump: no matching schemas were found
However, if I quote the schema name by adding a pair of single quotes...
> $ /usr/bin/pg_dump --file "testera" --host "/var/run/postgresql"
> --port "5432" --username "postgres" --no-password --verbose --format=c
> --blobs --schema '"HR00000000001-2019"' "nubes"
> pg_dump: last built-in OID is 16383
> pg_dump: reading extensions
> pg_dump: identifying extension members
> pg_dump: reading schemas
> pg_dump: reading user-defined tables
> pg_dump: reading user-defined functions
> pg_dump: reading user-defined types
> ...
...it works fine. So it seems schema names should be automatically
quoted (similar to quote_ident()) for backup to work properly. I guess
this is a bug in pgAdmin4 (version I have is 4.11).
--
Srdačan pozdrav / Kind regards
-----------------------------------------------
Arni Kromić
[ IT system engineer ]
arni(dot)kromic(at)bios-ict(dot)hr
Tel: +385 21 490 599
Mob: +385 95 659 5 659
----------------------------------------------
Mažuranićevo šet. 14
21000 Split, Croatia
Tel: +385 21 344 349
Fax: +358 21 490 599
http://podrska.bios-ict.hr
http://www.bios-ict.hr
----------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Aditya Toshniwal | 2019-08-09 10:00:28 | Re: Schema backup failure |
Previous Message | Aditya Toshniwal | 2019-08-09 09:54:53 | Re: Visual clutter in default view when viewing table data |