Partitioned table with fillfactor

2022-08-01 Thread endre_pekarik
Hello, 'PostgreSQL 11.13 on x86_64-pc-linux-gnu, compiled by x86_64-pc-linux-gnu-gcc (GCC) 7.4.0, 64-bit' I created a partitioned table. I didn't load any data into it. When I try to ALTER TABLE tablename SET (fillfactor = 80); , I get an Unrecognized parameter "fillfactor"

Re: Upgradede Pgadmin4 to v6.12 - new startup error

2022-08-01 Thread Dave Page
Hi On Mon, 1 Aug 2022 at 16:46, Cherio wrote: > Thanks Dave! The application started after I added the line you suggested > . Although in my opinion, trying to work around a new feature in order > to start pgadmin feels wrong. > I agree. The difficulty is though that we either fail early,

Re: Upgradede Pgadmin4 to v6.12 - new startup error

2022-08-01 Thread Cherio
Thanks Dave! The application started after I added the line you suggested . Although in my opinion, trying to work around a new feature in order to start pgadmin feels wrong. I have 2 follow-up questions. 1. Presently I have to redefine paths for several files and directories (see below). Is

Re: Upgradede Pgadmin4 to v6.12 - new startup error

2022-08-01 Thread Dave Page
Hi On Mon, 1 Aug 2022 at 16:01, Cherio wrote: > I grepped the sources for 'azurecredentialcache': > > user@HOST:~/opt/pgadmin4$ grep -R azurecredentialcache . > ./lib/python3.8/site-packages/pgadmin4/config.py:AZURE_CREDENTIAL_CACHE_DIR > = os.path.join(DATA_DIR, 'azurecredentialcache') > > I

Re: Upgradede Pgadmin4 to v6.12 - new startup error

2022-08-01 Thread Cherio
I grepped the sources for 'azurecredentialcache': user@HOST:~/opt/pgadmin4$ grep -R azurecredentialcache . ./lib/python3.8/site-packages/pgadmin4/config.py:AZURE_CREDENTIAL_CACHE_DIR = os.path.join(DATA_DIR, 'azurecredentialcache') I do re-define DATA_DIR in my configuration file (see below) so

Upgradede Pgadmin4 to v6.12 - new startup error

2022-08-01 Thread Cherio
This was just a regular upgrade (I went through dozens of these). The new 6.12 version fails to start with the following error message: File "lib/python3.8/site-packages/pgadmin4/pgAdmin4.py", line 93, in app = create_app() File

Re: Bug Report: pgAdmin 6.12 doesn't show contents of information_schema and pg_catalog

2022-08-01 Thread Akshay Joshi
Hi Nicolas Can you please log the issue https://redmine.postgresql.org/projects/pgadmin4/issues/new On Mon, Aug 1, 2022 at 5:42 PM Nicolas Dechamps wrote: > Hello! > > > > I noticed that with pgAdmin 6.12, the contents of information_schema and > pg_catalog in the Browser cannot be displayed.

Bug Report: pgAdmin 6.12 doesn't show contents of information_schema and pg_catalog

2022-08-01 Thread Nicolas Dechamps
Hello! I noticed that with pgAdmin 6.12, the contents of information_schema and pg_catalog in the Browser cannot be displayed. Clicking on the arrows to unfold these schemas, flips the arrow downwards, but yields no results. I downgraded to 6.11 and it still works with that version. Kind

auto-connect to database with docker-deployment of pgadmin

2022-08-01 Thread Daniel Kaupp
Hi all, I'm working on a setup in MS Azure with Terraform. Postgresql is already in place and pgadmin is deployed via Docker image from dpage. I was wondering if there is a automatic way to tell pgadmin to which DB-Server it should connect to, at deploy time (or short after)? This way, i could