Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gyjzD-0004HY-Jl for pgsql-admin@arkaria.postgresql.org; Tue, 26 Feb 2019 21:09:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1gyjzC-0002lr-68 for pgsql-admin@arkaria.postgresql.org; Tue, 26 Feb 2019 21:09:58 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gyjzB-0002lh-MO for pgsql-admin@lists.postgresql.org; Tue, 26 Feb 2019 21:09:57 +0000 Received: from sonic301-4.consmr.mail.bf2.yahoo.com ([74.6.129.43]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1gyjz9-0006ue-1K for pgsql-admin@lists.postgresql.org; Tue, 26 Feb 2019 21:09:56 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1551215392; bh=NRDuxbybOzAE9xe6Ae+0gh+WvNm3DMvXNVAak+MSReI=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=KVTeCnQYnYxetMt/6FT8ea/a4LdzJ0btHQ5NGibeznxDaDdMw+IX+7l9DE4ummxTuEt8Zgfa2nCpfN3lFAZ7HK6+Sxyv0yhdJPLvIxNL9DEGJf2Wx5xNL7TV6XqkZz2t0ioLShwJi8wyTP5iIkrj3oVdHFbaHn2cx6emW7KNoiisE+uk3JhxfNSR8zxy27KIXMV5TJ3GWfmhk3slOlpg6qA+WHsqr9oJpOExueGHtmG1KS1FWEqQP8GJTq3zZ0Wk7XUDBYkfXtQJd8V2FNDFY7jdZ+8S/wR7WqSPw+60pl0J+43dyKpDqD5sf4bAq/+lrFPjP3pUDMQb6FeSgg/2BA== X-YMail-OSG: wZJYX_kVM1mXFmNYRakmcdxBTvODovnt_luDIj4tlBNbLq.bnlHhP_gnp3EnMev nx75DrmixhF_MO0efInTqENxHmBeGqD6lINJZ9w4K5UtvKuhJMm6bVKwhCEGtr2hTo7xNLm7WDbl 7VlFAJvvz_SeG_SOsqw.ck1TDTmIlDsyQcZJx6hdUAqZ7Jr.NKgAUoP970UYiOvMrM6ol7KsHyUX eKmPKsry_3h7pDERz4tQnXaUSKdjM40GJUWTKSPXU6GDe_FSksPSm9f8OwBpJn4.Ts5Bj.hcpztD .klU03LIpK0.pT0dkfuM4jqroBcsJu2iZiywdfWcmpIOoYIi9wfph2gKmMxJwB9Cij3Q2EidE33Q hJKcV4hW0HOjW2u.240NkZZaQaG5yOhVGxTZckiZw3szg.CRYZ_Thkdrjjpv4.x_Q.KWtVcll4n0 NtAcy.jGKK_Tn6Y1dv64Ky5WvP8nicf04WCQoBkHoDI7A4q0Yx62Y3zzAQSl8KD1kqbs45.dj9s3 A1_Oq4MqyBJ5Cw9pKk.586Ev7jomzJP6bKv8MV4McRpTXmgBPVr7KE9Nmqk.8JOb5ycjoi9qsuzH zKuMNu38gDtFwfzVZK_ZzWUkZ0kbPEdaVSra.YEfgW1ZThhXRXBZhswvX74JWlF8IcSsJ4JCIZZg N73yn9aYqmpvdDvxGAGYl5UpkXWQMLaYvtzWTqFjJ5cTdsysOErnz28dOnI8oKNl9D.swCrGlkUb unzRm6xMFV237Xv8o10nnkjVSXc3foBiEl.cJgFmq_KfcMPVzDcfaIVVpUbdkTH87kVGQh.TcGJE Z1WdQV66Vs_ATwaGV4rNA4EY8GBMMNxtk03rauOfobelHS5rHVzAxBeZEzjGMfP2owxTm7t1yXSO ZNwSpNDx.KwRVb2S0h07w1CAuotBh4ZlCojeQLBpgOjJaZBXRPaz8l4t.CcBb46mgT4sUeyWrt9. 0jC0q6oj_sRZRjz35KTlzzWcagYZdm0Txdpge2z6NDII6kn1JdTOkGzL8zGZ3epuxUBliAWDLpEb cuq9bfQjZMC0JIFBVInuusIVAKPmLn8GzdthfuEgzp2ERTo2K7g1JmnUkS1pZnew- Received: from sonic.gate.mail.ne1.yahoo.com by sonic301.consmr.mail.bf2.yahoo.com with HTTP; Tue, 26 Feb 2019 21:09:52 +0000 Date: Tue, 26 Feb 2019 21:09:49 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Steve Crawford Cc: Shreeyansh Dba , "gilberto.castillo@etecsa.cu" , Pgsql-admin Message-ID: <1259407684.5772133.1551215389418@mail.yahoo.com> In-Reply-To: References: <1766891885.5546566.1551195368839.ref@mail.yahoo.com> <1766891885.5546566.1551195368839@mail.yahoo.com> <1161831433.5624889.1551203198375@mail.yahoo.com> <713147705.5704638.1551207564863@mail.yahoo.com> Subject: Re: [MASSMAIL]Re: pg_dumpall: could not connect to database: FATAL MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_5772132_974189757.1551215389416" X-Mailer: WebService/1.1.13123 YahooMailNeo Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/72.0.3626.109 Safari/537.36 Content-Length: 9821 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_5772132_974189757.1551215389416 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable I typo PORT without =3D yes, I did reload postgres after make a configuration change. v/r, =C2=A0Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love and forgive more.To call= him a dog hardly seems to do him justice though in as much as he had four = legs, a tail, and barked, I admit he was, to all outward appearances. But t= o those who knew him well, he was a perfect gentleman (Hermione Gingold) **Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely = rich *** Faithful talent *** Sharing success=20 On Tuesday, February 26, 2019 3:55 PM, Steve Crawford wrote: =20 Some random observations that may or may not be of use. Are you making sure to reload PostgreSQL whenever you make a config change? I also found pg_hba.conf on both folders=C2=A0 /var/lib/pgsql/11/data/pg_hb= a.conf & /var/lib/pgsql/data/pg_hba.conf).=C2=A0 I modified it as above and= the script is not working even run from the command prompt. To find out which pg_hba.conf file your running database is using run: show all; Then search for hba_file or view directly by: select setting from pg_settings where name =3D 'hba_file'; You can verify your pg_hba.conf settings with (as user postgres): select * from pg_hba_file_rules ;=C2=A0 # export HOSTNAME=3Dhostname # export USERNAME=3Dpostgres# export DATABASE=3Dpostgres=C2=A0# export PORT= 5432# pg_dump -v -p $PORT -U $USERNAME -d $DATABASE -f /tmp/postgresbakup.= sql Looks like you are missing the "=3D" between PORT and 5432 Cheers,Steve=C2=A0 =20 ------=_Part_5772132_974189757.1551215389416 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I typo PORT without =3D

yes, I did reload postgres after make a configuration ch= ange.

v/r,

=

 
<= /span>
Bach-Nga

No one in = this world is pure and perfect.  If you avoid people for their mistake= s you will be alone. So judge less, love and forgive more.
To call him a dog hardly seems to do him justice though in as much as= he had four legs, a tail, and barked, I admit he was, to all outward appea= rances. But to those who knew him well, he was a perfect gentleman (Hermion= e Gingold)

**Live sim= ply **Love generously **Care deeply **Speak kindly.
<= font id=3D"yui_3_13_0_rc_1_1_1381789421038_7864" color=3D"#8000ff">*** Genu= inely rich *** Faithful talent *** Sharing success


=
On Tuesday, February 26, = 2019 3:55 PM, Steve Crawford <scrawford@pinpointresearch.com> wrote:<= br>


Some random observations that may or may not= be of use.

Are you making sure to reload PostgreS= QL whenever you make a config change?


I also found pg_hba.conf on bot= h folders  /var/lib/pgsql/11/data/pg_hba.conf & /var/lib/pgsql/dat= a/pg_hba.conf).  I modified it as above and the script is not working = even run from the command prompt.



To find out which pg_hba.conf file your runn= ing database is using run:
show all;

Then search for= hba_file or view directly by:

select setting from pg_settings where name =3D 'hba_file';

You = can verify your pg_hba.conf settings with (as user postgres):

select * from pg_hba_file_rules ;
&= nbsp;
=
# export HOSTNAME= =3Dhostname
# e= xport USERNAME=3Dpostgres
# export DATABASE=3Dpostgres 
# export PORT 5432
# pg_dump -v -p $PORT -U $US= ERNAME -d $DATABASE -f /tmp/postgresbakup.sql
=

Looks like you are missing the= "=3D" between PORT and 5432

Cheers,
Ste= ve
 


<= /div>
------=_Part_5772132_974189757.1551215389416--