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
