PostgreSQL 12 High Availability Cookbook - Third Edition

How it works...

The first thing we need is a user that we know exists on both servers. While we can link a local user with any remote user, this is easiest when they have the same name. This prevents confusion or connection problems in the future. If we are linking to a remote server that we don't administer, then this may not be possible. For now, however, we have control over both systems, so we can create the bench_user safely with a simple password for testing purposes.

Next, we create the user mapping itself. As with the server, we need to fill in three sections: a local user name, the server to use, and options for the mapping. We just created bench_user, so this will be our local user that we will associate with the mapping. Then we ...