pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Can one user login in multile machine?
3+ messages / 3 participants
[nested] [flat]

* Can one user login in multile machine?
@ 2023-05-03 06:23 Wen Yi <chuxuec@outlook.com>
  2023-05-03 07:34 ` Re: Can one user login in multile machine? Ron <ronljohnsonjr@gmail.com>
  2023-05-03 16:43 ` Re: Can one user login in multile machine? Israel Brewster <ijbrewster@alaska.edu>
  0 siblings, 2 replies; 3+ messages in thread

From: Wen Yi @ 2023-05-03 06:23 UTC (permalink / raw)
  To: PostgreSQL General <pgsql-general@lists.postgresql.org>

Hi team,
can I use same user's information login in multile machines when connect to the postgres?
Thanks in advance!

Yours,
Wen Yi.


^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Can one user login in multile machine?
  2023-05-03 06:23 Can one user login in multile machine? Wen Yi <chuxuec@outlook.com>
@ 2023-05-03 07:34 ` Ron <ronljohnsonjr@gmail.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Ron @ 2023-05-03 07:34 UTC (permalink / raw)
  To: pgsql-general@lists.postgresql.org

On 5/3/23 01:23, Wen Yi wrote:
> Hi team,
> can I use same user's information login in multile machines when connect 
> to the postgres?

Your question is a bit ambiguous, since:
1. "login in (to) multiple machines" typically refers logging in to the OS, 
and that has nothing to do with postgresql, and
2. a specific postgresql database can only be on one server.

Having said that... when doing streaming replication, role details 
(including authentication credentials) will be automatically replicated to 
the secondary just like every other bit of "the postgres".

-- 
Born in Arizona, moved to Babylonia.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: Can one user login in multile machine?
  2023-05-03 06:23 Can one user login in multile machine? Wen Yi <chuxuec@outlook.com>
@ 2023-05-03 16:43 ` Israel Brewster <ijbrewster@alaska.edu>
  1 sibling, 0 replies; 3+ messages in thread

From: Israel Brewster @ 2023-05-03 16:43 UTC (permalink / raw)
  To: Wen Yi <chuxuec@outlook.com>; +Cc: PostgreSQL General <pgsql-general@lists.postgresql.org>

> On May 2, 2023, at 10:23 PM, Wen Yi <chuxuec@outlook.com> wrote:
> 
> Hi team,
> can I use same user's information login in multile machines when connect to the postgres?

In short, yes. A given user can log in from any number of machines, I believe even simultaneously (though I haven’t tried that specifically).

---
Israel Brewster
Software Engineer
Alaska Volcano Observatory 
Geophysical Institute - UAF 
2156 Koyukuk Drive 
Fairbanks AK 99775-7320
Work: 907-474-5172
cell:  907-328-9145

> Thanks in advance!
> 
> Yours,
> Wen Yi.

^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2023-05-03 16:43 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-05-03 06:23 Can one user login in multile machine? Wen Yi <chuxuec@outlook.com>
2023-05-03 07:34 ` Ron <ronljohnsonjr@gmail.com>
2023-05-03 16:43 ` Israel Brewster <ijbrewster@alaska.edu>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox