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

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   all     all  peer
>>>
>>> before the lines you show above?
>>
>> no
>>
>> I added the whol pg_conf at the end.
>>
>> There is one thing particulare with the installation.
>>
>> I have postgresql 9.5 and 10.0 on the box.
>>
>> now when I check
>>
>> pg_dump -V
>> pg_dump (PostgreSQL) 9.5.24
>>
>> root(at)elfero:~# ll /usr/bin/pg_dump
>> lrwxrwxrwx 1 root root 37 Nov 13  2019 /usr/bin/pg_dump ->
>> ../share/postgresql-common/pg_wrapper*
>>
>> when I switch to user postgres, and the us psql, I get the following:
>>
>> root(at)elfero:~# su postgres
>> postgres(at)elfero:/root$ psql -d  elfero
>> could not change directory to "/root": Permission denied
>> psql (10.16 (Ubuntu 10.16-0ubuntu0.18.04.1), server 9.5.24)
>> Type "help" for help.
>>
>> looks, as if I have a mess with this two instances.
>>
>>
>> How can I best clean that up.
>>
>> I need only PostgreSQL 10
>
> From command line what does pg_lsclusters show?
root(at)elfero:~# pg_lsclusters
Ver Cluster Port Status Owner    Data directory                             Log file
9.5 main    5432 online postgres /mnt/HC_Volume_8755337/postgresql/9.5/main
/var/log/postgresql/postgresql-9.5-main.log
10  main    5433 down   postgres /var/lib/postgresql/10/main
/var/log/postgresql/postgresql-10-main.log

>
> Which pg_hba.conf file did you change?  The one in:
>
> /etc/postgresql/9.5/main
>
> or
>
> /etc/postgresql/10/main
>
>
> To specify a version of pg_dump to use do something like:
>
> pg_dump --cluster 10/main -d some_db -U some_user -p some_port
>
> The important part is the some_port. You will need to use the one specified
> for the instance(cluster) as returned by the pg_lscluster command.

I did in deed change the wrong file

now, I need remove one of the two postgresql versions, but for this I will open
a new question

thanks and have a nice weekend

Robert

>
>>
>> thanks again
>>
>> robert
>>
>>
>
>> # Database administrative login by Unix domain socket
>> #local all postgres peer
>> # TYPE DATABASE USER ADDRESS METHOD
>> # "local" is for Unix domain socket connections only
>> local all all trust
>> # IPv4 local connections:
>> host all all 127.0.0.1/32 trust
>> q# IPv6 local connections:
>> host all all ::1/128 md5
>> # Allow replication connections from localhost, by a user with the
>> # replication privilege.
>> local replication all peer
>> host replication all 127.0.0.1/32 md5
>> host replication all ::1/128 md5
>
>