pg.ddx.io pgsql-general@postgresql.org mailing list archivehelp / color / mirror / Atom feed
issue with remote backup 3+ messages / 3 participants [nested] [flat]
* issue with remote backup @ 2023-10-26 16:51 Atul Kumar <akumar14871@gmail.com> 2023-10-26 17:15 ` Re: issue with remote backup Tom Lane <tgl@sss.pgh.pa.us> 2023-10-26 17:21 ` Re: issue with remote backup Adrian Klaver <adrian.klaver@aklaver.com> 0 siblings, 2 replies; 3+ messages in thread From: Atul Kumar @ 2023-10-26 16:51 UTC (permalink / raw) To: pgsql-general <pgsql-general@lists.postgresql.org> Hi, I have the postgres12 version running on centos7. In pg_hba.conf file I have an entry like below: host all all <remote server ip>/32 md5 So from the above entry, I understand that all users can connect to all databases from the remote ip. But when I use pg_basebackup from remote server using below command I get the below error: pg_basebackup -h DB_server_hostname -p 5444 -U postgres -D /var/lib/edb/backups/10262023_1 -Fp -Xs -c fast -P Error that I got: pg_basebackup: error: FATAL: no pg_hba.conf entry for replication connection from host "remote_ip", user "postgres", SSL off So please help me understand why I am getting this error even after having a related entry in the pg_hba.conf file. Regards. ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: issue with remote backup 2023-10-26 16:51 issue with remote backup Atul Kumar <akumar14871@gmail.com> @ 2023-10-26 17:15 ` Tom Lane <tgl@sss.pgh.pa.us> 1 sibling, 0 replies; 3+ messages in thread From: Tom Lane @ 2023-10-26 17:15 UTC (permalink / raw) To: Atul Kumar <akumar14871@gmail.com>; +Cc: pgsql-general <pgsql-general@lists.postgresql.org> Atul Kumar <akumar14871@gmail.com> writes: > In pg_hba.conf file I have an entry like below: > host all all <remote server ip>/32 md5 That is an entry governing ordinary session connections ... > Error that I got: > pg_basebackup: error: FATAL: no pg_hba.conf entry for replication > connection from host "remote_ip", user "postgres", SSL off ... and that is complaining about the lack of an entry for replication connections. They are handled by different pg_hba.conf entries. regards, tom lane ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: issue with remote backup 2023-10-26 16:51 issue with remote backup Atul Kumar <akumar14871@gmail.com> @ 2023-10-26 17:21 ` Adrian Klaver <adrian.klaver@aklaver.com> 1 sibling, 0 replies; 3+ messages in thread From: Adrian Klaver @ 2023-10-26 17:21 UTC (permalink / raw) To: Atul Kumar <akumar14871@gmail.com>; pgsql-general <pgsql-general@lists.postgresql.org> On 10/26/23 09:51, Atul Kumar wrote: > Hi, > > I have the postgres12 version running on centos7. > > In pg_hba.conf file I have an entry like below: > > host all all <remote server ip>/32 md5 > > So from the above entry, I understand that all users can connect to all > databases from the remote ip. > > > But when I use pg_basebackup from remote server using below command I > get the below error: > > pg_basebackup -h DB_server_hostname -p 5444 -U postgres -D > /var/lib/edb/backups/10262023_1 -Fp -Xs -c fast -P > > Error that I got: > > pg_basebackup: error: FATAL: no pg_hba.conf entry for replication > connection from host "remote_ip", user "postgres", SSL off > > So please help me understand why I am getting this error even after > having a related entry in the pg_hba.conf file. https://www.postgresql.org/docs/current/auth-pg-hba-conf.html " database Specifies which database name(s) this record matches. The value all specifies that it matches all databases. The value sameuser specifies that the record matches if the requested database has the same name as the requested user. The value samerole specifies that the requested user must be a member of the role with the same name as the requested database. (samegroup is an obsolete but still accepted spelling of samerole.) Superusers are not considered to be members of a role for the purposes of samerole unless they are explicitly members of the role, directly or indirectly, and not just by virtue of being a superuser. The value replication specifies that the record matches if a physical replication connection is requested, however, it doesn't match with logical replication connections. Note that physical replication connections do not specify any particular database whereas logical replication connections do specify it. Otherwise, this is the name of a specific PostgreSQL database or a regular expression. Multiple database names and/or regular expressions can be supplied by separating them with commas. If the database name starts with a slash (/), the remainder of the name is treated as a regular expression. (See Section 9.7.3.1 for details of PostgreSQL's regular expression syntax.) A separate file containing database names and/or regular expressions can be specified by preceding the file name with @. " > > > > > Regards. -- Adrian Klaver adrian.klaver@aklaver.com ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-10-26 17:21 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-10-26 16:51 issue with remote backup Atul Kumar <akumar14871@gmail.com> 2023-10-26 17:15 ` Tom Lane <tgl@sss.pgh.pa.us> 2023-10-26 17:21 ` Adrian Klaver <adrian.klaver@aklaver.com>
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