solved: Re: how to set permission, so I can run pg_dumd in a cron job

2021-03-13 Thread robert rottermann
Thanks again Adrian On 13.03.21 18:37, Adrian Klaver wrote: On 3/13/21 9:25 AM, robert rottermann wrote: Adrin, thanks can you please give me a hand 1) Did you have the server reload the conf files after making the changes? yes I did 2) Is there an entry for something like: local 

Re: how to set permission, so I can run pg_dumd in a cron job

2021-03-13 Thread Adrian Klaver
On 3/13/21 9:25 AM, robert rottermann wrote: Adrin, thanks can you please give me a hand 1) Did you have the server reload the conf files after making the changes? yes I did 2) Is there an entry for something like: local   all all  peer before the lines you show above? no I ad

Re: how to set permission, so I can run pg_dumd in a cron job

2021-03-13 Thread robert rottermann
Adrin, thanks On 13.03.21 17:23, Adrian Klaver wrote: On 3/13/21 8:16 AM, robert rottermann wrote: Hi Friends I would like to have a cronjob creating a dump of a db. I am on a ubuntu 18 lts, potgres v10. I have a user robert with superuser db permission. a database "mydb" of which I would

Re: how to set permission, so I can run pg_dumd in a cron job

2021-03-13 Thread Adrian Klaver
On 3/13/21 8:16 AM, robert rottermann wrote: Hi Friends I would like to have a cronjob creating a dump of a db. I am on a ubuntu 18 lts, potgres v10. I have a user robert with superuser db permission. a database "mydb" of which I would like to to a nightly dump. I tried to set thing in hba_

how to set permission, so I can run pg_dumd in a cron job

2021-03-13 Thread robert rottermann
Hi Friends I would like to have a cronjob creating a dump of a db. I am on a ubuntu 18 lts, potgres v10. I have a user robert with superuser db permission. a database "mydb" of which I would like to to a nightly dump. I tried to set thing in hba_conf like this: # Database administrative log