how to best remove version 10 (and keep version 9.5)

2021-03-13 Thread robert rottermann
Hi folks I am running an Ubuntu 18.04 lts remote box. For some (complicated) reasons I did install PostgreSQL 9.5 alongside the already installed V10 instance. I did set the data_directory to point some disk  “outside” the standard /etc/postgresql/9.5/main structure. Now, what I would like

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

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

solved (was plain stupidity) Re: ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it

2021-01-23 Thread robert rottermann
thanks a lot. why dos such stupidity not hurt. ? have a nice weekend robert On 24.01.21 08:04, Julien Rouhaud wrote: On Sun, Jan 24, 2021 at 2:58 PM rob...@redo2oo.ch wrote: root@elfero-test:~/scripts# pg_lsclusters Ver Cluster Port Status OwnerData directory Log file 10

ubuntu 18: PostgreSQL does not start. how can I totally remove and reinstall it

2021-01-23 Thread robert rottermann
Hi there I made somehow a mess with my PostgreSQL installation an an ubuntu 18.4 with PostgreSQL 10.0 service postgresql status ● postgresql.service - PostgreSQL RDBMS    Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)    Active: active (exited) since

pgadmin4: not possible to create server

2018-02-06 Thread robert rottermann
Hi there, I have installed pgadmin4 locally using its docker image. this i did running the following command: docker run -p 80:80 -e "PGADMIN_DEFAULT_EMAIL=admin" -e "PGADMIN_DEFAULT_PASSWORD=admin" -d dpage/pgadmin4 I then could access it and log into it. However all my attempts end in: U