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

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?

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.

>
> 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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com