Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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@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@elfero:~# su postgres
postgres@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@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








[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux