Re: Issue using Python to import a server

[Yogesh Mahajan]

Hi Arne,

You are correct. You have to use setup.py located inside the app directory.
You may use other python venv but suggested would be the venv created
inside the app directory.
And yes this is CLI way to import/export the servers in addition to
functionality provided in the UI.


Thanks,
Yogesh Mahajan
EnterpriseDB


On Mon, Jan 29, 2024 at 7:30 PM Arne Brücher 
wrote:

> Hello everybody,
>
> I'm trying to import a server using the CLI/Python using the following
> docs:
>
> https://www.pgadmin.org/docs/pgadmin4/development/import_export_servers.html#importing-servers
>
> Unfortunately I don't get which path to Python and setup.py is meant.
> Do I have to activate the virtual environment in /Applications/pgAdmin\
>
> 4.app/Contents/Frameworks/Python.framework/Versions/3.11/lib/python3.11/venv
> ?
> Do I have to use the Python executable and setup.py which also can be
> found in the Application directory?
> Are the instructions linked above even meant as an addition to the
> PgAdmin GUI?
>
> Thanks in advance and with kind regards
> Arne Brücher
>
>
>
>

Issue using Python to import a server

[Arne Brücher]

Hello everybody,

I'm trying to import a server using the CLI/Python using the following docs:
https://www.pgadmin.org/docs/pgadmin4/development/import_export_servers.html#importing-servers

Unfortunately I don't get which path to Python and setup.py is meant.
Do I have to activate the virtual environment in /Applications/pgAdmin\ 
4.app/Contents/Frameworks/Python.framework/Versions/3.11/lib/python3.11/venv?
Do I have to use the Python executable and setup.py which also can be 
found in the Application directory?
Are the instructions linked above even meant as an addition to the 
PgAdmin GUI?


Thanks in advance and with kind regards
Arne Brücher

Re: Custom auto-vacuum toogle disabled on partitioned tables

[Aditya Toshniwal]

Hi Joan,

The image you shared is broken. Please share the correct one.

On Mon, Jan 29, 2024 at 4:10 PM Joan  wrote:

> Hi , I am using pgadmin4 8.2 to connecte a postgres 14 server, I wanted to
> enable the custom auto-vacuum on a partitioned table because with the
> ordinary vacuum the table gets slower over time.
> I've found that the toggle is disabled (while I can change it on the
> regular tables), I can do a manual vacuum on the maintenance menu but
> having it automated is more convenient.
> [image: ksnip_tmp_ejSoUK.png]
> On documentation I've found the vacuum process should walk on the
> partitioned tables as if they where normal tables and vacuum them when
> needed.
>
> Regards
>


-- 
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*

"Don't Complain about Heat, Plant a TREE"

Custom auto-vacuum toogle disabled on partitioned tables

[Joan]

Hi , I am using pgadmin4 8.2 to connecte a postgres 14 server, I wanted to
enable the custom auto-vacuum on a partitioned table because with the
ordinary vacuum the table gets slower over time.
I've found that the toggle is disabled (while I can change it on the
regular tables), I can do a manual vacuum on the maintenance menu but
having it automated is more convenient.
[image: ksnip_tmp_ejSoUK.png]
On documentation I've found the vacuum process should walk on the
partitioned tables as if they where normal tables and vacuum them when
needed.

Regards