Re: backup script error with could not connect to database

mallikarjun t <[email protected]> Thu, 19 Dec 2019 22:22:27 +0530
Newsgroups gmane.comp.db.postgresql.admin,gmane.comp.db.postgresql.pgadmin
Message-ID <CAOA8XiUpYJO1qajgQ0y0w_r3_b8YQgL7CmmZ6cL82z8GnGX0mw@mail.gmail.com>
--00000000000065ef84059a116495
Content-Type: text/plain; charset="UTF-8"

Dear team,

Do onething ident authentication problem to overcome on create .pgpass file
and what username and password, port number and dbname put it on .pgpass
file. Now you never ever getting this error.

On Thu, Dec 19, 2019, 12:25 AM Pepe TD Vo <[email protected]> wrote:

> hello expert,
>
> I had to do a backup on replication master-slave servers.  I also have
> asked this question before, but  I don't understand why I followed the
> information and same scripting to run on the replication servers and didn't
> work.  I can run pg_dumpall successful but not with the script.  Would you
> please tell me what's wrong and what need to correct the error?
>
> my replication server (master) pg_hba.conf
>
> # "local" is for Unix domain socket connections only
> local   all   all                                                     peer
> host   all    all                     192.168.2.0/24        trust
> # IPv4 local connections:
> host   all   all                       127.0.0.1/32           indent
> local  all   postgres                                            trust
> host   all   power_user         0.0.0.0/0               md5
> host   all   other_user          0.0.0.0/0                md5
> host   all   storageLoader    0.0.0.0/0                md5
> # IPv6 local connections:
> host   all   all                        ::1/128                  indent
> #allow replication connections from localhost, by a user with the
> replication priviledge
> local   replication   all                                        trust
> host   replication   all         127.0.0.1/32           trust
> host   replicaiton   all         ::1/128                    trust
> host   replication   replicauser     masterIP/32  trust
> host   replicaiton   replicauser     slaveIP/32     trust
>
> from the postgres prompt I can connect to each database
>
> #psql -d template0 -U postgres
> template0-#
> #psql -d template1 -U postgres
> template1-#
>
> #psql -d pscidr -U postgres
> pscidr-#
> #psql -d postgres -U postgres
> postgres-#
>
>
> when I run the script as postgres os, I don't see the error but the only
> global.sql backup but nothing in it, 0 byte (blank) sql script.
>
> when I run as root su -c postgres /path/pg_backup.sh > pgbackup.log, I get
> below:
>
> Performing globals backup:
> Globals backup
> pg_dumpall: could not connect to database "template1":FATAL: Ident
> authentication failed for user "postgres" fro globals backup.
>
> Performing schema-only backup:
> psql:FATAL: Ident authentication failed for user "postgres"
> the following databases were matched for schema-only backup:
>
> performing full backup:
> psql:FATAL: Ident authentication failed for user "postgres"
>
>
> I can run pg_dumpall > postgresdump.sql as postgres user os fine will all
> the databases backup
>
> pg_backup.sh and pg_backup.config attachment.
>
> v/r,
>
>
>
> *Bach-Nga*No one in this world is pure and perfect.  If you avoid people
> for their 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 to 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
>

--00000000000065ef84059a116495
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Dear team,=C2=A0<div dir=3D"auto"><br></div><div dir=3D"a=
uto">Do onething ident authentication problem to overcome on create .pgpass=
 file and what username and password, port number and dbname put it on .pgp=
ass file. Now you never ever getting this error.</div></div><br><div class=
=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, Dec 19, 2019=
, 12:25 AM Pepe TD Vo &lt;<a href=3D"mailto:[email protected]">pepevo@yahoo.=
com</a>&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"marg=
in:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div style=
=3D"font-family:verdana,helvetica,sans-serif;font-size:16px"><div dir=3D"lt=
r">hello expert,</div><div dir=3D"ltr"><br></div><div dir=3D"ltr"><span><sp=
an style=3D"font-family:Helvetica Neue,Helvetica,Arial,sans-serif">I had to=
 do a backup on replication master-slave servers.=C2=A0 I also have asked t=
his question before, but=C2=A0 I don&#39;t understand why I followed the in=
formation and same scripting to run on the replication servers and didn&#39=
;t work.=C2=A0 I can run pg_dumpall successful but not with the script.=C2=
=A0 Would you please tell me what&#39;s wrong and what need to correct the =
error?</span></span></div><div dir=3D"ltr"><span><span style=3D"font-family=
:Helvetica Neue,Helvetica,Arial,sans-serif"><br></span></span></div><div di=
r=3D"ltr"><span><span style=3D"font-family:Helvetica Neue,Helvetica,Arial,s=
ans-serif">my replication server (master) pg_hba.conf</span></span></div><d=
iv dir=3D"ltr"><span><span style=3D"font-family:Helvetica Neue,Helvetica,Ar=
ial,sans-serif"><br></span></span></div><div dir=3D"ltr"><span><span style=
=3D"font-family:Helvetica Neue,Helvetica,Arial,sans-serif"># &quot;local&qu=
ot; is for Unix domain socket connections only</span></span></div><div dir=
=3D"ltr"><span><span style=3D"font-family:Helvetica Neue,Helvetica,Arial,sa=
ns-serif">local=C2=A0 =C2=A0all=C2=A0 =C2=A0all=C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0peer</span></span></div><div dir=3D"ltr"><span><span style=3D"=
font-family:Helvetica Neue,Helvetica,Arial,sans-serif">host=C2=A0 =C2=A0all=
=C2=A0 =C2=A0 all=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0<a href=3D"http://192.168.2.0/24" target=3D"_blank" rel=
=3D"noreferrer">192.168.2.0/24</a>=C2=A0 =C2=A0 =C2=A0 =C2=A0 trust</span><=
/span></div><div dir=3D"ltr"><span><span style=3D"font-family:Helvetica Neu=
e,Helvetica,Arial,sans-serif"># IPv4 local connections:</span></span></div>=
<div dir=3D"ltr"><span><span style=3D"font-family:Helvetica Neue,Helvetica,=
Arial,sans-serif">host=C2=A0 =C2=A0all=C2=A0 =C2=A0all=C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0<a href=3D"ht=
tp://127.0.0.1/32" target=3D"_blank" rel=3D"noreferrer">127.0.0.1/32</a>=C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0indent</span></span></div><div dir=3D=
"ltr"><span><span style=3D"font-family:Helvetica Neue,Helvetica,Arial,sans-=
serif">local=C2=A0 all=C2=A0 =C2=A0postgres=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 trust</span></span></div><=
div dir=3D"ltr"><span><span style=3D"font-family:Helvetica Neue,Helvetica,A=
rial,sans-serif">host=C2=A0 =C2=A0all=C2=A0 =C2=A0power_user=C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0<a href=3D"http://0.0.0.0/0" target=3D"_blank" rel=3D"n=
oreferrer">0.0.0.0/0</a>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0md5</span></span></div><div dir=3D"ltr"><span><span style=3D"font-fam=
ily:Helvetica Neue,Helvetica,Arial,sans-serif"><span><span style=3D"color:r=
gb(0,0,0);font-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:1=
6px">host=C2=A0 =C2=A0all=C2=A0 =C2=A0other_user=C2=A0 =C2=A0 =C2=A0 =C2=A0=
 =C2=A0 <a href=3D"http://0.0.0.0/0" target=3D"_blank" rel=3D"noreferrer">0=
.0.0.0/0</a>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 md5</sp=
an></span><br></span></span></div><div dir=3D"ltr"><span><span style=3D"fon=
t-family:Helvetica Neue,Helvetica,Arial,sans-serif"><span><span style=3D"co=
lor:rgb(0,0,0);font-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-s=
ize:16px"><span><span style=3D"color:rgb(0,0,0);font-family:Helvetica Neue,=
Helvetica,Arial,sans-serif;font-size:16px">host=C2=A0 =C2=A0all=C2=A0 =C2=
=A0storageLoader=C2=A0 =C2=A0 <a href=3D"http://0.0.0.0/0" target=3D"_blank=
" rel=3D"noreferrer">0.0.0.0/0</a>=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
 =C2=A0 =C2=A0 md5</span></span><br></span></span></span></span></div><div =
dir=3D"ltr"><span><span style=3D"font-family:Helvetica Neue,Helvetica,Arial=
,sans-serif"><span><span style=3D"color:rgb(0,0,0);font-family:Helvetica Ne=
ue,Helvetica,Arial,sans-serif;font-size:16px"><span><span style=3D"color:rg=
b(0,0,0);font-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:16=
px"># IPv6 local connections:</span></span></span></span></span></span></di=
v><div dir=3D"ltr"><span><span style=3D"font-family:Helvetica Neue,Helvetic=
a,Arial,sans-serif"><span><span style=3D"color:rgb(0,0,0);font-family:Helve=
tica Neue,Helvetica,Arial,sans-serif;font-size:16px"><span><span style=3D"c=
olor:rgb(0,0,0);font-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-=
size:16px">host=C2=A0 =C2=A0all=C2=A0 =C2=A0all=C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 ::1/128=C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 indent</span></span></=
span></span></span></span></div><div dir=3D"ltr"><span><span style=3D"font-=
family:Helvetica Neue,Helvetica,Arial,sans-serif"><span><span style=3D"colo=
r:rgb(0,0,0);font-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-siz=
e:16px"><span><span style=3D"color:rgb(0,0,0);font-family:Helvetica Neue,He=
lvetica,Arial,sans-serif;font-size:16px">#allow replication connections fro=
m localhost, by a user with the replication priviledge</span></span></span>=
</span></span></span></div><div dir=3D"ltr"><span><span style=3D"font-famil=
y:Helvetica Neue,Helvetica,Arial,sans-serif"><span><span style=3D"color:rgb=
(0,0,0);font-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:16p=
x"><span><span style=3D"color:rgb(0,0,0);font-family:Helvetica Neue,Helveti=
ca,Arial,sans-serif;font-size:16px">local=C2=A0 =C2=A0replication=C2=A0 =C2=
=A0all=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 trus=
t</span></span></span></span></span></span></div><div dir=3D"ltr"><span><sp=
an style=3D"font-family:Helvetica Neue,Helvetica,Arial,sans-serif"><span><s=
pan style=3D"color:rgb(0,0,0);font-family:Helvetica Neue,Helvetica,Arial,sa=
ns-serif;font-size:16px"><span><span style=3D"color:rgb(0,0,0);font-family:=
Helvetica Neue,Helvetica,Arial,sans-serif;font-size:16px">host=C2=A0 =C2=A0=
replication=C2=A0 =C2=A0all=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0<a href=3D"htt=
p://127.0.0.1/32" target=3D"_blank" rel=3D"noreferrer">127.0.0.1/32</a>=C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0trust</span></span></span></span></sp=
an></span></div><div dir=3D"ltr"><span><span style=3D"font-family:Helvetica=
 Neue,Helvetica,Arial,sans-serif"><span><span style=3D"color:rgb(0,0,0);fon=
t-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:16px"><span><s=
pan style=3D"color:rgb(0,0,0);font-family:Helvetica Neue,Helvetica,Arial,sa=
ns-serif;font-size:16px">host=C2=A0 =C2=A0replicaiton=C2=A0 =C2=A0all=C2=A0=
 =C2=A0 =C2=A0 =C2=A0 =C2=A0::1/128=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 trust</span></span></span></span></span></s=
pan></div><div dir=3D"ltr"><span><span style=3D"font-family:Helvetica Neue,=
Helvetica,Arial,sans-serif"><span><span style=3D"color:rgb(0,0,0);font-fami=
ly:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:16px"><span><span st=
yle=3D"color:rgb(0,0,0);font-family:Helvetica Neue,Helvetica,Arial,sans-ser=
if;font-size:16px">host=C2=A0 =C2=A0replication=C2=A0 =C2=A0replicauser=C2=
=A0 =C2=A0 =C2=A0masterIP/32=C2=A0 trust</span></span></span></span></span>=
</span></div><div dir=3D"ltr"><span><span style=3D"font-family:Helvetica Ne=
ue,Helvetica,Arial,sans-serif"><span><span style=3D"color:rgb(0,0,0);font-f=
amily:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:16px"><span><span=
 style=3D"color:rgb(0,0,0);font-family:Helvetica Neue,Helvetica,Arial,sans-=
serif;font-size:16px">host=C2=A0 =C2=A0replicaiton=C2=A0 =C2=A0replicauser=
=C2=A0 =C2=A0 =C2=A0slaveIP/32=C2=A0 =C2=A0 =C2=A0trust</span></span></span=
></span></span></span></div><div dir=3D"ltr"><span><span style=3D"font-fami=
ly:Helvetica Neue,Helvetica,Arial,sans-serif"><span><span style=3D"color:rg=
b(0,0,0);font-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:16=
px"><span><span style=3D"color:rgb(0,0,0);font-family:Helvetica Neue,Helvet=
ica,Arial,sans-serif;font-size:16px"><br></span></span></span></span></span=
></span></div><div dir=3D"ltr"><span><span style=3D"font-family:Helvetica N=
eue,Helvetica,Arial,sans-serif"><span><span style=3D"color:rgb(0,0,0);font-=
family:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:16px"><span><spa=
n style=3D"color:rgb(0,0,0);font-family:Helvetica Neue,Helvetica,Arial,sans=
-serif;font-size:16px">from the postgres prompt I can connect to each datab=
ase</span></span></span></span></span></span></div><div dir=3D"ltr"><span><=
span style=3D"font-family:Helvetica Neue,Helvetica,Arial,sans-serif"><span>=
<span style=3D"color:rgb(0,0,0);font-family:Helvetica Neue,Helvetica,Arial,=
sans-serif;font-size:16px"><span><span style=3D"color:rgb(0,0,0);font-famil=
y:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:16px"><br></span></sp=
an></span></span></span></span></div><div dir=3D"ltr"><span><span style=3D"=
font-family:Helvetica Neue,Helvetica,Arial,sans-serif"><span><span style=3D=
"color:rgb(0,0,0);font-family:Helvetica Neue,Helvetica,Arial,sans-serif;fon=
t-size:16px"><span><div dir=3D"ltr" style=3D"font-family:Helvetica Neue,Hel=
vetica,Arial,sans-serif">#psql -d template0 -U postgres<br></div><div dir=
=3D"ltr" style=3D"font-family:Helvetica Neue,Helvetica,Arial,sans-serif">te=
mplate0-#<br></div><div dir=3D"ltr" style=3D"font-family:Helvetica Neue,Hel=
vetica,Arial,sans-serif">#psql -d template1 -U postgres<br></div><div dir=
=3D"ltr" style=3D"font-family:Helvetica Neue,Helvetica,Arial,sans-serif">te=
mplate1-#<br></div><div dir=3D"ltr" style=3D"font-family:Helvetica Neue,Hel=
vetica,Arial,sans-serif"><br></div><div dir=3D"ltr" style=3D"font-family:He=
lvetica Neue,Helvetica,Arial,sans-serif">#psql -d pscidr -U postgres<br></d=
iv><div dir=3D"ltr" style=3D"font-family:Helvetica Neue,Helvetica,Arial,san=
s-serif">pscidr-#<br></div><div dir=3D"ltr" style=3D"font-family:Helvetica =
Neue,Helvetica,Arial,sans-serif">#psql -d postgres -U postgres<br></div><di=
v dir=3D"ltr" style=3D"font-family:Helvetica Neue,Helvetica,Arial,sans-seri=
f">postgres-#</div><div dir=3D"ltr" style=3D"font-family:Helvetica Neue,Hel=
vetica,Arial,sans-serif"><br></div><div dir=3D"ltr" style=3D"font-family:He=
lvetica Neue,Helvetica,Arial,sans-serif"><br></div><div dir=3D"ltr" style=
=3D"font-family:Helvetica Neue,Helvetica,Arial,sans-serif">when I run the s=
cript as postgres os, I don&#39;t see the error but the only global.sql bac=
kup but nothing in it, 0 byte (blank) sql script.</div><div dir=3D"ltr" sty=
le=3D"font-family:Helvetica Neue,Helvetica,Arial,sans-serif"><br></div><div=
 dir=3D"ltr" style=3D"font-family:Helvetica Neue,Helvetica,Arial,sans-serif=
">when I run as root su -c postgres /path/pg_backup.sh &gt; pgbackup.log, I=
 get below:</div><div dir=3D"ltr" style=3D"font-family:Helvetica Neue,Helve=
tica,Arial,sans-serif"><br></div><div dir=3D"ltr" style=3D"font-family:Helv=
etica Neue,Helvetica,Arial,sans-serif"><div><blockquote id=3D"m_83502538128=
39254373ydp5418157cyiv5353805347yui_3_16_0_ym19_1_1551097740995_308947" sty=
le=3D"margin:0px 0px 0px 40px;border:none;padding:0px"><div id=3D"m_8350253=
812839254373ydp5418157cyiv5353805347yui_3_16_0_ym19_1_1551097740995_64457" =
dir=3D"ltr"><span id=3D"m_8350253812839254373ydp5418157cyiv5353805347yui_3_=
16_0_ym19_1_1551097740995_308901"><font color=3D"#9d1811" size=3D"2" id=3D"=
m_8350253812839254373ydp5418157cyiv5353805347yui_3_16_0_ym19_1_155109774099=
5_312133" style=3D"background-color:inherit">Performing globals backup:</fo=
nt></span></div><div id=3D"m_8350253812839254373ydp5418157cyiv5353805347yui=
_3_16_0_ym19_1_1551097740995_64457" dir=3D"ltr"><span><font color=3D"#9d181=
1" size=3D"2" style=3D"background-color:inherit">Globals backup</font></spa=
n></div><div id=3D"m_8350253812839254373ydp5418157cyiv5353805347yui_3_16_0_=
ym19_1_1551097740995_64457" dir=3D"ltr"><span id=3D"m_8350253812839254373yd=
p5418157cyiv5353805347yui_3_16_0_ym19_1_1551097740995_64559"><font color=3D=
"#9d1811" size=3D"2" style=3D"background-color:inherit">pg_dumpall: could n=
ot connect to database &quot;template1&quot;:FATAL: Ident authentication fa=
iled for user &quot;postgres&quot; fro globals backup.=C2=A0=C2=A0</font></=
span></div><div id=3D"m_8350253812839254373ydp5418157cyiv5353805347yui_3_16=
_0_ym19_1_1551097740995_64457" dir=3D"ltr"><br></div><div id=3D"m_835025381=
2839254373ydp5418157cyiv5353805347yui_3_16_0_ym19_1_1551097740995_64457" di=
r=3D"ltr"><span id=3D"m_8350253812839254373ydp5418157cyiv5353805347yui_3_16=
_0_ym19_1_1551097740995_305914"><font color=3D"#9d1811" size=3D"2" style=3D=
"background-color:inherit">Performing schema-only backup:</font></span></di=
v><div id=3D"m_8350253812839254373ydp5418157cyiv5353805347yui_3_16_0_ym19_1=
_1551097740995_64457" dir=3D"ltr"><span id=3D"m_8350253812839254373ydp54181=
57cyiv5353805347yui_3_16_0_ym19_1_1551097740995_305912"><font color=3D"#9d1=
811" size=3D"2" style=3D"background-color:inherit">psql:FATAL: Ident authen=
tication failed for user &quot;postgres&quot;</font></span></div><div id=3D=
"m_8350253812839254373ydp5418157cyiv5353805347yui_3_16_0_ym19_1_15510977409=
95_64457" dir=3D"ltr"><span id=3D"m_8350253812839254373ydp5418157cyiv535380=
5347yui_3_16_0_ym19_1_1551097740995_305918"><font color=3D"#9d1811" id=3D"m=
_8350253812839254373ydp5418157cyiv5353805347yui_3_16_0_ym19_1_1551097740995=
_309077" size=3D"2" style=3D"background-color:inherit">the following databa=
ses were matched for schema-only backup:</font></span></div><div id=3D"m_83=
50253812839254373ydp5418157cyiv5353805347yui_3_16_0_ym19_1_1551097740995_64=
457" dir=3D"ltr"><font color=3D"#9d1811" size=3D"2" style=3D"background-col=
or:inherit"><br></font></div><div id=3D"m_8350253812839254373ydp5418157cyiv=
5353805347yui_3_16_0_ym19_1_1551097740995_64457" dir=3D"ltr"><span id=3D"m_=
8350253812839254373ydp5418157cyiv5353805347yui_3_16_0_ym19_1_1551097740995_=
308957"><font color=3D"#9d1811" id=3D"m_8350253812839254373ydp5418157cyiv53=
53805347yui_3_16_0_ym19_1_1551097740995_309079" size=3D"2" style=3D"backgro=
und-color:inherit">performing full backup:</font></span></div><div id=3D"m_=
8350253812839254373ydp5418157cyiv5353805347yui_3_16_0_ym19_1_1551097740995_=
64457" dir=3D"ltr"><font color=3D"#9d1811" id=3D"m_8350253812839254373ydp54=
18157cyiv5353805347yui_3_16_0_ym19_1_1551097740995_309081" size=3D"2">psql:=
FATAL: Ident authentication failed for user &quot;postgres&quot;</font></di=
v></blockquote><div id=3D"m_8350253812839254373ydp5418157cyiv5353805347yui_=
3_16_0_ym19_1_1551097740995_64457" dir=3D"ltr"><br></div><div id=3D"m_83502=
53812839254373ydp5418157cyiv5353805347yui_3_16_0_ym19_1_1551097740995_64457=
" dir=3D"ltr">I can run pg_dumpall &gt; postgresdump.sql as postgres user o=
s fine will all the databases backup</div></div><div id=3D"m_83502538128392=
54373ydp5418157cyiv5353805347yui_3_16_0_ym19_1_1551097740995_64457" dir=3D"=
ltr"><br></div><div id=3D"m_8350253812839254373ydp5418157cyiv5353805347yui_=
3_16_0_ym19_1_1551097740995_64457" dir=3D"ltr">pg_backup.sh and pg_backup.c=
onfig attachment.</div><br></div></span></span></span></span></span></div><=
div dir=3D"ltr">v/r,</div><div dir=3D"ltr"><br></div><div><div id=3D"m_8350=
253812839254373ydp97b5dc79yui_3_13_0_rc_1_1_1381789421038_7868"><font color=
=3D"#0000ff"><b><span><font color=3D"#8000ff" style=3D"background-color:inh=
erit"></font></span></b></font><div id=3D"m_8350253812839254373ydp97b5dc79y=
ui_3_13_0_rc_1_1_1381789421038_7874"><font id=3D"m_8350253812839254373ydp97=
b5dc79yui_3_13_0_rc_1_1_1381789421038_7873" color=3D"#0000ff"><font color=
=3D"#8000ff"></font><span id=3D"m_8350253812839254373ydp97b5dc79yui_3_13_0_=
rc_1_1_1381789421038_7871"><font id=3D"m_8350253812839254373ydp97b5dc79yui_=
3_13_0_rc_1_1_1381789421038_7870" color=3D"#8000ff" style=3D"background-col=
or:inherit"><b id=3D"m_8350253812839254373ydp97b5dc79yui_3_13_0_rc_1_16_138=
1789421038_18">Bach-Nga<br clear=3D"none"><br clear=3D"none"></b>No one in =
this world is pure and perfect.=C2=A0 If you avoid people for their mistake=
s you will be alone. So judge less, love and forgive more.</font></span></f=
ont></div><div id=3D"m_8350253812839254373ydp97b5dc79yui_3_13_0_rc_1_1_1381=
789421038_7874"><font color=3D"#0000ff"><span><font color=3D"#8000ff" style=
=3D"background-color:inherit">To call him a dog hardly seems to do him just=
ice though in as much as he had four legs, a tail, and barked, I admit he w=
as, to all outward appearances. But to those who knew him well, he was a pe=
rfect gentleman (Hermione Gingold)</font></span></font></div><br clear=3D"n=
one"><span style=3D"color:rgb(128,0,255)" id=3D"m_8350253812839254373ydp97b=
5dc79yui_3_13_0_rc_1_1_1381789421038_7867">**Live simply **Love generously =
**Care deeply **Speak kindly.</span></div><div id=3D"m_8350253812839254373y=
dp97b5dc79yui_3_13_0_rc_1_1_1381789421038_7866"><span id=3D"m_8350253812839=
254373ydp97b5dc79yui_3_13_0_rc_1_1_1381789421038_7865"><font id=3D"m_835025=
3812839254373ydp97b5dc79yui_3_13_0_rc_1_1_1381789421038_7864" color=3D"#800=
0ff" style=3D"background-color:inherit">*** Genuinely rich *** Faithful tal=
ent *** Sharing success</font></span></div></div></div></div></blockquote><=
/div>

--00000000000065ef84059a116495--