Thread: 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!
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"
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"
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"
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"