Tablespaces created with PGAdmin4 on any Server instance in a PostgreSQL 10 Cluster are duplicated to all other local server instances on that cluster

From: Kimball Johnson <kimball(dot)johnson(at)engagile(dot)io>
To: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Tablespaces created with PGAdmin4 on any Server instance in a PostgreSQL 10 Cluster are duplicated to all other local server instances on that cluster
Date: 2020-07-10 02:41:38
Message-ID: BYAPR15MB3063D2098B2B0FC273D18B12EB650@BYAPR15MB3063.namprd15.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,
I'm using PostgreSQL 10 on a mac pro running macOS Mojave. My version info for PGAdmin4 is provided below.
I installed EDB standard PostgreSQL version 10 on the mac pro as I have done many times before. I'm going to be using this implementation to perform ETL, List Management, GIS operations using Tiger and OSM, so I'm isolating the operations for each of those processes using Tablespaces. And I'm performing the configuration of the tablespaces using the PGAdmin4 web tool in chrome.
I added a larger group of tablespaces using the PGAdmin4 tool over a TCP connection to a Ubuntu server on my network with no problems similar to this. In that case, only the connected PostgreSQL configuration was affected. The database on the connected Ubuntu system is a separate installation of PostgreSQL, whose role is to support the Pentaho BA Server and its PostgreSQL DB repository. And the new tablespaces created in that connected system's LVM disks seem to act in a reasonable manner and do not display this duplication.
However, in addition to the connected Server on the Ubuntu machine, I have three local server instances showing in the PGAdmin interface on the mac pro. These are the main local PostgreSQL server instance, and two other local server instances (ETL and GIS) that isolate development from the Ubuntu system and the local Server. All three of these local server instances are looking at the same PostgreSQL installation and PGData folder on the Mac Pro.
When I add tablespaces to any of these three local server instances, each of the local server instances gets a copy of each of the new tablespaces. These become visible in the PGAdmin4 Tablespace folder of the server instance. This outcome is puzzling because the PostgreSQL 10 docs state that Tablespaces must be unique across the Database Cluster.
I have found no information indicating that Postgres might elect scope the Tablespace names by Server instance. But I'm not even sure whether the 'Server' concept is a PostgreSQL concept or a PGAdmin4 concept. So, at this point, I can't determine whether this is a PostgreSQL misunderstanding or a PGAdmin4 issue. My reading of PostgreSQL docs indicates that a Cluster encompasses Databases, not Servers, but maybe I haven't run across the distinguishing facts on that.
Nonetheless, this duplication is alarming. Does any of this sound familiar?
Thanks,
Kimball Johnson
Product Manager at Engagile.io

Version
3.1
Copyright
Copyright 2013 - 2018, The pgAdmin Development Team
Python Version
3.6.5 (default, Jun 15 2018, 09:47:54) [GCC 4.2.1 Compatible Apple LLVM 7.0.2 (clang-700.1.81)]
Flask Version
0.12.2
Application Mode
Desktop
Current User
pgadmin4(at)pgadmin(dot)org<mailto:pgadmin4(at)pgadmin(dot)org>

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2020-07-10 09:01:10 Re: Tablespaces created with PGAdmin4 on any Server instance in a PostgreSQL 10 Cluster are duplicated to all other local server instances on that cluster
Previous Message John Zhang 2020-07-09 13:05:15 Fwd: 'Data Output' tab has No Horizontal Scrolling