Re: Can I use .pgpass in logical replication?

"CONVERS Yann - DREAL Auvergne-Rhône-Alpes/CIDDAE/SIG" <yann.convers@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx> · Wed, 9 May 2018 16:48:34 +0200



    Hi,

    
    Have you apply  ACL for .pgpass file? if not it's aborted?

    
      Yann Convers
Gestionnaire de l'infrastructure, des référentiels et des outils
DREAL Auvergne-Rhône-Alpes
Service Connaissance, Information, Développement Durable, Autorité Environnementale - Pole Système d Information Géographique
Tél : 04 26 28 67 89
courriel : yann.convers@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
adresse de la boite d’unité : boite unité

Pour toute commande interne de prestations, merci d utilisez le formulaire suivant : http://postgis-aura.projets.appli.i2/projects/demandes-de-prestations/issues/new
Adresse postale : DREAL Auvergne-Rhône-Alpes, CIDDAE - SIG
 69453 LYON CEDEX 06
Adresse physique : 5
place Jules Ferry (immeuble Lugdunum - métro Brotteaux) -
69006 Lyon
Standard : 04 26 28 60 00
Liens :Site
Intranet  Site
Internet


    Le 09/05/2018 à 16:28, "> JaeWon Lee
      (par Internet, dépôt
      pgsql-admin-owner+m63745-56088@xxxxxxxxxxxxxxxxxxxx)" a écrit :

    
      Hi ^^ I'm using Logical replication. I made
        subscription like below.

        
        =# CREATE SUBSCRIPTION mysub CONNECTION 'host=xxx.xxx.xxx.xxx
        port=5432 

             user=postgres dbname=mydb password=<password>'
        PUBLICATION mypub;

        NOTICE:  created replication slot "mysub" on publisher

        CREATE SUBSCRIPTION

        
        But I wonder if I can use .pgpass file to provide password. Of
        course, I tried it. But it failed like below.

        
        =# CREATE SUBSCRIPTION mysub CONNECTION 'host=xxx.xxx.xxx.xxx
        port=5432 

            user=postgres dbname=mydb' PUBLICATION mypub;

        ERROR:  could not connect to the publisher: fe_sendauth: no
        password supplied

        
        [My .pgpass]

        
        localhost:5432:postgres:postgres:<password>

        localhost:5432:mydb:postgres:<password>

        xxx.xxx.xxx.xxx:5432:mydb:postgres:<password>

        
        This .pgpass file works well for pgAgent.

        
        Can I use .pgpass file for logical replication? or Should I
        write my password in CREATE statement? If writing password in
        CREATE command is the only answer, is it secure?