Re: PSQL Tool start issue

[Aditya Toshniwal]

Hi,

psqlrc is not shared among users and each user will use psqlrc from the
pgAdmin user storage directory.


On Thu, Jun 23, 2022 at 12:05 PM 深石 康昭  wrote:

> Hi,
>
> I am using the pgAdmin4 ver.6.10 container in server mode.
>
> If different users start PSQL Tool at the same time,
> the user who started it first will run psqlrc of the user who started it
> later.
>
> I think that each user's psqlrc needs to work even if they are started at
> the same time.
>
> Thanks!
>
>
>

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

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

Installation on Linux with Docker

[Qua qua]

Dear developers,

I'm struggling to install and configure the application on docker, where 
I'm also moving my first steps.


The container was started with: docker run -p 7990:80 -e 
'PGADMIN_DEFAULT_EMAIL=t...@test.com' -e 'PGADMIN_DEFAULT_PASSWORD=test' 
-d dpage/pgadmin4. I'd expect then I'll be able to connect to 
localhost:7990, but when trying to open this address, the browser hangs 
indefinitely.


I do not spots any hints in the log:

#] docker logs pgadmin4
NOTE: Configuring authentication for SERVER mode.

[2022-06-23 10:33:39 +] [1] [INFO] Starting gunicorn 20.1.0
[2022-06-23 10:33:39 +] [1] [INFO] Listening at: http://[::]:80 (1)
[2022-06-23 10:33:39 +] [1] [INFO] Using worker: gthread
[2022-06-23 10:33:39 +] [89] [INFO] Booting worker with pid: 89
[2022-06-23 10:54:23 +] [1] [INFO] Handling signal: winch
[2022-06-23 11:00:09 +] [1] [INFO] Handling signal: winch
[2022-06-23 11:12:09 +] [1] [INFO] Handling signal: winch
[2022-06-23 11:18:13 +] [1] [INFO] Handling signal: winch
[2022-06-23 11:39:08 +] [1] [INFO] Handling signal: winch
[2022-06-23 11:57:50 +] [1] [INFO] Handling signal: winch

Is this a problem of permissions? The documentation mentions that should 
be set for the pgadmin user/group, but I don't know how to do it on Docker.



Linux 5.18.5-arch1-1, Docker v20.10.17, image dpage/pgadmin4:latest 
2d7539c5a1338b9b063c60aa25e2f8ae948ba717c0c0c7ca91fbea7e9733d434



Yours,

Quack

RE: Installer for PgAdmin4, v6.10

[Ken Benson]

Hi Ken,

Windows 7 reached EOL a long time ago. Please check 
https://www.pgadmin.org/download/pgadmin-4-windows/ for pgAdmin version support.

[[KenB]]  which says “pgAdmin is available for 64 bit Windows™ 7 SP1 (desktop) 
or 2008R2 (server) and above, up to v4.30.” – but it still worked up until 
version 6.2
[[KenB]]  I’m just asking if that change between 6.2 and 6.10 was on purpose.

On Thu, Jun 23, 2022 at 2:06 AM Ken Benson 
mailto:k...@infowerks.com>> wrote:

When I try to upgrade my local PgAdmin4 to version 6.10, I get a message: “This 
program does not support the version of Windows your computer is running.”

I am running Windows 7x64.
Version 6.2 installed on this machine.

Is this by design? Is support for Windows 7x64 being discontinued for PgAdmin4?




Ken Benson | ken @ infowerks-dot-com



--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"

Re: Installer for PgAdmin4, v6.10

[Aditya Toshniwal]

Hi Ken,

On Thu, Jun 23, 2022 at 6:22 PM Ken Benson  wrote:

>
>
>
>
>
>
> Hi Ken,
>
>
>
> Windows 7 reached EOL a long time ago. Please check
> https://www.pgadmin.org/download/pgadmin-4-windows/ for pgAdmin version
> support.
>
>
>
> *[[KenB]]  *which says “pgAdmin is available for 64 bit Windows™ 7 SP1
> (desktop) or 2008R2 (server) and above, up to v4.30.” – but it still worked
> up until version 6.2
>
> *[[KenB]]  *I’m just asking if that change between 6.2 and 6.10 was on
> purpose.
>
We have stopped testing installers on Windows 7. If it works then great.
But, if it doesn't work then unfortunately we can't do anything in this.

>
>
> On Thu, Jun 23, 2022 at 2:06 AM Ken Benson  wrote:
>
>
>
> When I try to upgrade my local PgAdmin4 to version 6.10, I get a message:
> “This program does not support the version of Windows your computer is
> running.”
>
> I am running Windows 7x64.
>
> Version 6.2 installed on this machine.
>
> Is this by design? Is support for Windows 7x64 being discontinued for
> PgAdmin4?
>
>
>
>
>
>
>
>
>
> Ken Benson | ken @ infowerks-dot-com
>
>
>
>
>
>
> --
>
> Thanks,
>
> Aditya Toshniwal
>
> pgAdmin Hacker | Software Architect | *edbpostgres.com*
> 
>
> "Don't Complain about Heat, Plant a TREE"
>


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

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

RE: Installer for PgAdmin4, v6.10

[Ken Benson]

Hi Ken,

On Thu, Jun 23, 2022 at 6:22 PM Ken Benson 
mailto:k...@infowerks.com>> wrote:



Hi Ken,

Windows 7 reached EOL a long time ago. Please check 
https://www.pgadmin.org/download/pgadmin-4-windows/ for pgAdmin version support.

[[KenB]]  which says “pgAdmin is available for 64 bit Windows™ 7 SP1 (desktop) 
or 2008R2 (server) and above, up to v4.30.” – but it still worked up until 
version 6.2
[[KenB]]  I’m just asking if that change between 6.2 and 6.10 was on purpose.
We have stopped testing installers on Windows 7. If it works then great. But, 
if it doesn't work then unfortunately we can't do anything in this.

[[KenB]] Thank you!

On Thu, Jun 23, 2022 at 2:06 AM Ken Benson 
mailto:k...@infowerks.com>> wrote:

When I try to upgrade my local PgAdmin4 to version 6.10, I get a message: “This 
program does not support the version of Windows your computer is running.”

I am running Windows 7x64.
Version 6.2 installed on this machine.

Is this by design? Is support for Windows 7x64 being discontinued for PgAdmin4?




Ken Benson | ken @ infowerks-dot-com



--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"


--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"

Re: Installer for PgAdmin4, v6.10

[Dave Caughey]

It doesn't even install, which is actually good, because in v6.3 pgAdmin
updated the dependency on python (IIRC) to a version that no longer runs on
Windows 7, whereupon pgAdmin thinks it installed correctly, but you can't
actually use it.  So in v6.4, a check was added to prevent pgAdmin from
installing and leaving you dead in the water.  I.e., it's not that
pgAdmin's refusal to install v6.4+ is an arbitrary decision, it
actually protects you from being screwed.  Luckily I was able to revert to
v6.2.

I would love for pgAdmin to support Windows 7 by possibly supporting legacy
versions of python, but as someone running a software business, I can
understand why the team doesn't want to jump through hoops to support an OS
that even Microsoft has totally abandoned. It's not the pgAdmin's team
responsibility to accommodate my choice to use obsolete (and unsafe)
technology.

Yes, I really should update to Windows 10 (I doubt Windows 11 would install
on my older hardware), but I'm lazy and I figure that if my development
system still runs fine on Windows 7 then I've got other higher-priority
work issues to deal with... so I live with being stuck at v6.2.

Cheers,
Dave


On Thu, Jun 23, 2022 at 9:00 AM Aditya Toshniwal <
aditya.toshni...@enterprisedb.com> wrote:

> Hi Ken,
>
> On Thu, Jun 23, 2022 at 6:22 PM Ken Benson  wrote:
>
>>
>>
>>
>>
>>
>>
>> Hi Ken,
>>
>>
>>
>> Windows 7 reached EOL a long time ago. Please check
>> https://www.pgadmin.org/download/pgadmin-4-windows/ for pgAdmin version
>> support.
>>
>>
>>
>> *[[KenB]]  *which says “pgAdmin is available for 64 bit Windows™ 7 SP1
>> (desktop) or 2008R2 (server) and above, up to v4.30.” – but it still worked
>> up until version 6.2
>>
>> *[[KenB]]  *I’m just asking if that change between 6.2 and 6.10 was on
>> purpose.
>>
> We have stopped testing installers on Windows 7. If it works then great.
> But, if it doesn't work then unfortunately we can't do anything in this.
>
>>
>>
>> On Thu, Jun 23, 2022 at 2:06 AM Ken Benson  wrote:
>>
>>
>>
>> When I try to upgrade my local PgAdmin4 to version 6.10, I get a message:
>> “This program does not support the version of Windows your computer is
>> running.”
>>
>> I am running Windows 7x64.
>>
>> Version 6.2 installed on this machine.
>>
>> Is this by design? Is support for Windows 7x64 being discontinued for
>> PgAdmin4?
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> Ken Benson | ken @ infowerks-dot-com
>>
>>
>>
>>
>>
>>
>> --
>>
>> Thanks,
>>
>> Aditya Toshniwal
>>
>> pgAdmin Hacker | Software Architect | *edbpostgres.com*
>> 
>>
>> "Don't Complain about Heat, Plant a TREE"
>>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Software Architect | *edbpostgres.com*
> 
> "Don't Complain about Heat, Plant a TREE"
>

Re: Installation on Linux with Docker

[Brian Wilson]

All I can think of is your browser is trying https instead of http? They do
that a lot these days. It should not be any permission issue.

On Thu, Jun 23, 2022, 5:05 AM Qua qua  wrote:

> Dear developers,
>
> I'm struggling to install and configure the application on docker, where
> I'm also moving my first steps.
>
> The container was started with: docker run -p 7990:80 -e
> 'PGADMIN_DEFAULT_EMAIL=t...@test.com' -e 'PGADMIN_DEFAULT_PASSWORD=test'
> -d dpage/pgadmin4. I'd expect then I'll be able to connect to
> localhost:7990, but when trying to open this address, the browser hangs
> indefinitely.
>
> I do not spots any hints in the log:
>
> #] docker logs pgadmin4
> NOTE: Configuring authentication for SERVER mode.
>
> [2022-06-23 10:33:39 +] [1] [INFO] Starting gunicorn 20.1.0
> [2022-06-23 10:33:39 +] [1] [INFO] Listening at: http://[::]:80 (1)
> [2022-06-23 10:33:39 +] [1] [INFO] Using worker: gthread
> [2022-06-23 10:33:39 +] [89] [INFO] Booting worker with pid: 89
> [2022-06-23 10:54:23 +] [1] [INFO] Handling signal: winch
> [2022-06-23 11:00:09 +] [1] [INFO] Handling signal: winch
> [2022-06-23 11:12:09 +] [1] [INFO] Handling signal: winch
> [2022-06-23 11:18:13 +] [1] [INFO] Handling signal: winch
> [2022-06-23 11:39:08 +] [1] [INFO] Handling signal: winch
> [2022-06-23 11:57:50 +] [1] [INFO] Handling signal: winch
>
> Is this a problem of permissions? The documentation mentions that should
> be set for the pgadmin user/group, but I don't know how to do it on Docker.
>
>
> Linux 5.18.5-arch1-1, Docker v20.10.17, image dpage/pgadmin4:latest
> 2d7539c5a1338b9b063c60aa25e2f8ae948ba717c0c0c7ca91fbea7e9733d434
>
>
> Yours,
>
> Quack
>
>
>
>

Re: PSQL Tool start issue

[YASUAKI FUKAISHI]

Hi,

> psqlrc is not shared among users and each user will use psqlrc from the 
> pgAdmin user storage directory.

I think so, too.

When only UserA begins, UserA's psqlrc work.
UserA's $PSQLRC:
  db=> \! echo $PSQLRC
  /var/lib/pgadmin/storage/usera/.psqlrc

But this case, other user's psqlrc had run.
1) UserA clicks PSQL Tool.
2) UserB clicks PSQL Tool before UserA's PSQL begins.
3) UserA's PSQL run UserB's psqlrc.

UserA's $PSQLRC:
/var/lib/pgadmin/storage/userb/.psqlrc

Thanks,
Yasuaki Fukaishi



From: Aditya Toshniwal 
Sent: Thursday, June 23, 2022 18:40
To: 深石 康昭
Cc: pgadmin-support@lists.postgresql.org
Subject: Re: PSQL Tool start issue

Hi,

psqlrc is not shared among users and each user will use psqlrc from the pgAdmin 
user storage directory.


On Thu, Jun 23, 2022 at 12:05 PM 深石 康昭 
mailto:fukaishi-y_nco...@outlook.jp>> wrote:
Hi,

I am using the pgAdmin4 ver.6.10 container in server mode.

If different users start PSQL Tool at the same time,
the user who started it first will run psqlrc of the user who started it later.

I think that each user's psqlrc needs to work even if they are started at the 
same time.

Thanks!




--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Software Architect | edbpostgres.com
"Don't Complain about Heat, Plant a TREE"

Re: PSQL Tool start issue

[Aditya Toshniwal]

Hi YASUAKI,

This looks like a bug to me. Can you please create the bug here -
https://redmine.postgresql.org/projects/pgadmin4/issues/new ?
The team will look into it.

On Fri, Jun 24, 2022 at 6:01 AM YASUAKI FUKAISHI <
fukaishi-y_nco...@outlook.jp> wrote:

> Hi,
>
> > psqlrc is not shared among users and each user will use psqlrc from the
> pgAdmin user storage directory.
>
> I think so, too.
>
> When only UserA begins, UserA's psqlrc work.
> UserA's $PSQLRC:
>   db=> \! echo $PSQLRC
>   /var/lib/pgadmin/storage/usera/.psqlrc
>
> But this case, other user's psqlrc had run.
> 1) UserA clicks PSQL Tool.
> 2) UserB clicks PSQL Tool before UserA's PSQL begins.
> 3) UserA's PSQL run UserB's psqlrc.
>
> UserA's $PSQLRC:
> /var/lib/pgadmin/storage/userb/.psqlrc
>
> Thanks,
> Yasuaki Fukaishi
>
>
> 
> From: Aditya Toshniwal 
> Sent: Thursday, June 23, 2022 18:40
> To: 深石 康昭
> Cc: pgadmin-support@lists.postgresql.org
> Subject: Re: PSQL Tool start issue
>
> Hi,
>
> psqlrc is not shared among users and each user will use psqlrc from the
> pgAdmin user storage directory.
>
>
> On Thu, Jun 23, 2022 at 12:05 PM 深石 康昭  > wrote:
> Hi,
>
> I am using the pgAdmin4 ver.6.10 container in server mode.
>
> If different users start PSQL Tool at the same time,
> the user who started it first will run psqlrc of the user who started it
> later.
>
> I think that each user's psqlrc needs to work even if they are started at
> the same time.
>
> Thanks!
>
>
>
>
> --
> Thanks,
> Aditya Toshniwal
> pgAdmin Hacker | Software Architect | edbpostgres.com<
> http://edbpostgres.com>
> "Don't Complain about Heat, Plant a TREE"
>


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

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