pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
backup script error with could not connect to database
6+ messages / 4 participants
[nested] [flat]

* backup script error with could not connect to database
@ 2019-12-18 18:55 Pepe TD Vo <pepevo@yahoo.com>
  2019-12-19 12:12 ` Re: backup script error with could not connect to database bw <bwakkie@gmail.com>
  2019-12-19 16:52 ` Re: backup script error with could not connect to database mallikarjun t <mallit333@gmail.com>
  0 siblings, 2 replies; 6+ messages in thread

From: Pepe TD Vo @ 2019-12-18 18:55 UTC (permalink / raw)
  To: pgsql-admin; PgAdmin Support List <pgadmin-support@lists.postgresql.org>

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 onlylocal   all   all                                                     peerhost   all    all                     192.168.2.0/24        trust# IPv4 local connections:host   all   all                       127.0.0.1/32           indentlocal  all   postgres                                            trusthost   all   power_user         0.0.0.0/0               md5host   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 priviledgelocal   replication   all                                        trusthost   replication   all         127.0.0.1/32           trusthost   replicaiton   all         ::1/128                    trusthost   replication   replicauser     masterIP/32  trusthost   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 backuppg_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

Attachments:

  pg_backup_config-pg_backup.docx (application/vnd.openxmlformats-officedocument.wordprocessingml.document, 22.3K) download

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: backup script error with could not connect to database
  2019-12-18 18:55 backup script error with could not connect to database Pepe TD Vo <pepevo@yahoo.com>
@ 2019-12-19 12:12 ` bw <bwakkie@gmail.com>
  2019-12-19 16:44   ` Re: backup script error with could not connect to database Pepe TD Vo <pepevo@yahoo.com>
  1 sibling, 1 reply; 6+ messages in thread

From: bw @ 2019-12-19 12:12 UTC (permalink / raw)
  To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: pgsql-admin; PgAdmin Support List <pgadmin-support@lists.postgresql.org>

Did you try

root su -c postgres pg_dumpall > postgresdump.sql

On Wed, 18 Dec 2019 at 19:55, Pepe TD Vo <pepevo@yahoo.com> 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





^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: backup script error with could not connect to database
  2019-12-18 18:55 backup script error with could not connect to database Pepe TD Vo <pepevo@yahoo.com>
  2019-12-19 12:12 ` Re: backup script error with could not connect to database bw <bwakkie@gmail.com>
@ 2019-12-19 16:44   ` Pepe TD Vo <pepevo@yahoo.com>
  2019-12-20 09:59     ` Re: backup script error with could not connect to database Ekaterina Amez <ekaterina.amez@zunibal.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Pepe TD Vo @ 2019-12-19 16:44 UTC (permalink / raw)
  To: bw <bwakkie@gmail.com>; +Cc: pgsql-admin; PgAdmin Support List <pgadmin-support@lists.postgresql.org>

I made it work.  I changed all in pg_hba.conf to trust and backup scripts run fine.

thank you so much.
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 

    On Thursday, December 19, 2019, 07:12:54 AM EST, bw <bwakkie@gmail.com> wrote:  
 
 Did you try

root su -c postgres pg_dumpall > postgresdump.sql

On Wed, 18 Dec 2019 at 19:55, Pepe TD Vo <pepevo@yahoo.com> 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

  

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: backup script error with could not connect to database
  2019-12-18 18:55 backup script error with could not connect to database Pepe TD Vo <pepevo@yahoo.com>
  2019-12-19 12:12 ` Re: backup script error with could not connect to database bw <bwakkie@gmail.com>
  2019-12-19 16:44   ` Re: backup script error with could not connect to database Pepe TD Vo <pepevo@yahoo.com>
@ 2019-12-20 09:59     ` Ekaterina Amez <ekaterina.amez@zunibal.com>
  2019-12-20 13:13       ` Re: backup script error with could not connect to database Pepe TD Vo <pepevo@yahoo.com>
  0 siblings, 1 reply; 6+ messages in thread

From: Ekaterina Amez @ 2019-12-20 09:59 UTC (permalink / raw)
  To: pgsql-admin@lists.postgresql.org


El 19/12/19 a las 17:44, Pepe TD Vo escribió:
> I made it work.  I changed all in pg_hba.conf to trust and backup 
> scripts run fine.

When Postgres searches for the matching line in pg_hba.conf, the first 
line that matches current connection wins. This means that if you have:

     host  all  all                      127.0.0.1/32 indent

     host  replication  all        127.0.0.1/32          trust

The first line wins and indent is applied instead of trust.


> thank you so much.
>
> **
> *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
>
>
> On Thursday, December 19, 2019, 07:12:54 AM EST, bw 
> <bwakkie@gmail.com> wrote:
>
>
> Did you try
>
> root su -c postgres pg_dumpall > postgresdump.sql
>
> On Wed, 18 Dec 2019 at 19:55, Pepe TD Vo <pepevo@yahoo.com 
> <mailto:pepevo@yahoo.com>> 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
>

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: backup script error with could not connect to database
  2019-12-18 18:55 backup script error with could not connect to database Pepe TD Vo <pepevo@yahoo.com>
  2019-12-19 12:12 ` Re: backup script error with could not connect to database bw <bwakkie@gmail.com>
  2019-12-19 16:44   ` Re: backup script error with could not connect to database Pepe TD Vo <pepevo@yahoo.com>
  2019-12-20 09:59     ` Re: backup script error with could not connect to database Ekaterina Amez <ekaterina.amez@zunibal.com>
@ 2019-12-20 13:13       ` Pepe TD Vo <pepevo@yahoo.com>
  0 siblings, 0 replies; 6+ messages in thread

From: Pepe TD Vo @ 2019-12-20 13:13 UTC (permalink / raw)
  To: Ekaterina Amez <ekaterina.amez@zunibal.com>; pgsql-admin

the script worked for my single node postgres database server with the first line in pg_hba.conf host  all  all                      127.0.0.1/32          indent

not work at all on the replication servers.  I tried to resolve it for two days and finally, I put "trust" on the 1st line, the script works.

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 

    On Friday, December 20, 2019, 04:59:27 AM EST, Ekaterina Amez <ekaterina.amez@zunibal.com> wrote:  
 
  

 
 El 19/12/19 a las 17:44, Pepe TD Vo escribió:
  
 
  I made it work.  I changed all in pg_hba.conf to trust and backup scripts run fine.
    
When Postgres searches for the matching line in pg_hba.conf, the first line that matches current connection wins. This means that if you have:
 
    host  all  all                      127.0.0.1/32          indent
 
    host  replication  all        127.0.0.1/32          trust
 
The first line wins and indent is applied instead of trust.

  

 
 
   thank you so much. 
    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   
  
      On Thursday, December 19, 2019, 07:12:54 AM EST, bw <bwakkie@gmail.com> wrote:  
  
   Did you try
 
 root su -c postgres pg_dumpall > postgresdump.sql
 
 On Wed, 18 Dec 2019 at 19:55, Pepe TD Vo <pepevo@yahoo.com> 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
 
      
   

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: backup script error with could not connect to database
  2019-12-18 18:55 backup script error with could not connect to database Pepe TD Vo <pepevo@yahoo.com>
@ 2019-12-19 16:52 ` mallikarjun t <mallit333@gmail.com>
  1 sibling, 0 replies; 6+ messages in thread

From: mallikarjun t @ 2019-12-19 16:52 UTC (permalink / raw)
  To: Pepe TD Vo <pepevo@yahoo.com>; +Cc: pgsql-admin; PgAdmin Support List <pgadmin-support@lists.postgresql.org>

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 <pepevo@yahoo.com> 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
>

^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2019-12-20 13:13 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2019-12-18 18:55 backup script error with could not connect to database Pepe TD Vo <pepevo@yahoo.com>
2019-12-19 12:12 ` bw <bwakkie@gmail.com>
2019-12-19 16:44   ` Pepe TD Vo <pepevo@yahoo.com>
2019-12-20 09:59     ` Ekaterina Amez <ekaterina.amez@zunibal.com>
2019-12-20 13:13       ` Pepe TD Vo <pepevo@yahoo.com>
2019-12-19 16:52 ` mallikarjun t <mallit333@gmail.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