Thread

1. Can one user login in multile machine?

   Wen Yi <chuxuec@outlook.com> — 2023-05-03T06:23:30Z

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

2. Re: Can one user login in multile machine?

   Ron <ronljohnsonjr@gmail.com> — 2023-05-03T07:34:14Z

   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.

3. Re: Can one user login in multile machine?

   Israel Brewster <ijbrewster@alaska.edu> — 2023-05-03T16:43:47Z

   > 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.