From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: Can one user login in multile machine?
Date: Wed, 3 May 2023 02:34:14 -0500
Message-ID: <7604c2bc-b914-95e4-a969-b85bbcdded0d@gmail.com> (raw)
In-Reply-To: <TYAP286MB0636188B2C1E647F423F057DA96C9@TYAP286MB0636.JPNP286.PROD.OUTLOOK.COM>
References: <TYAP286MB0636188B2C1E647F423F057DA96C9@TYAP286MB0636.JPNP286.PROD.OUTLOOK.COM>
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-general@postgresql.org
Cc: ronljohnsonjr@gmail.com
Subject: Re: Can one user login in multile machine?
In-Reply-To: <7604c2bc-b914-95e4-a969-b85bbcdded0d@gmail.com>
References: <TYAP286MB0636188B2C1E647F423F057DA96C9@TYAP286MB0636.JPNP286.PROD.OUTLOOK.COM> <7604c2bc-b914-95e4-a969-b85bbcdded0d@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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