Обсуждение: PSQL Tool start issue

Поиск
Список
Период
Сортировка

PSQL Tool start issue

От
深石 康昭
Дата:
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!



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 深石 康昭 <fukaishi-y_ncontr@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

От
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 <aditya.toshniwal@enterprisedb.com>
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 深石 康昭 <fukaishi-y_ncontr@outlook.jp<mailto:fukaishi-y_ncontr@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<http://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_ncontr@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 <aditya.toshniwal@enterprisedb.com>
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 深石 康昭 <fukaishi-y_ncontr@outlook.jp<mailto:fukaishi-y_ncontr@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<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"

Re: PSQL Tool start issue

От
YASUAKI FUKAISHI
Дата:
Hi,

I create the bug report.
#7503

Thanks,
Yasuaki Fukaishi

________________________________________
From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Sent: Friday, June 24, 2022 14:15
To: YASUAKI FUKAISHI
Cc: pgadmin-support@lists.postgresql.org
Subject: Re: PSQL Tool start issue

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_ncontr@outlook.jp<mailto:fukaishi-y_ncontr@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 <aditya.toshniwal@enterprisedb.com<mailto:aditya.toshniwal@enterprisedb.com>>
Sent: Thursday, June 23, 2022 18:40
To: 深石 康昭
Cc: pgadmin-support@lists.postgresql.org<mailto: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 深石 康昭
<fukaishi-y_ncontr@outlook.jp<mailto:fukaishi-y_ncontr@outlook.jp><mailto:fukaishi-y_ncontr@outlook.jp<mailto:fukaishi-y_ncontr@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<http://edbpostgres.com><http://edbpostgres.com>
"Don't Complain about Heat, Plant a TREE"


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