Choosing Linux Distro for PostgreSQL
Your reason for Debian is a good one. But in the future your should stay on that choice. Another idea might be using … Read more
postgresql
How to install pgAdmin 4 on Linux Mint
The following worked for me in Linux Mint 19.1 modified from docs because my machine had $(lsb_release -cs) returning tessa which was not … Read more
Why is Postgres sending network traffic on OSx
The Activity Monitor captures local network traffic as well and it seems like Postgres has some statistic collection that runs locally.
postgres ident authentication failed
This article and its comments might help: “FATAL: Ident authentication failed”, or how cool ideas get bad usage schemas
how to split long psql command in bash script over several lines
Apologies, I just tried using the standard backslash character and it worked, so: sudo -u postgres /opt/puppet/bin/psql puppetdb -t \ -c “select certname, … Read more
What does exit code 130 mean for postgres command?
What does exit code 130 mean for postgres command?
Why can’t I connect to Postgres in Docker?
Just add the ports parameters to the docker-compose.yml. Example: # Use postgres/example user/password credentials version: ‘3.1’ services: db: image: postgres restart: always environment: … Read more
pgAdmin list of keyboard shortcuts
I didn’t find a list, but I’m using the following shortcuts often: Ctrl+D – Show table data Ctrl+G – Filter Anyway there are … Read more
install postgresql-12 in CentOS-8 got No match for argument: postgresql12
You need to disable the postgresql stream module in AppStream, unblocking the postgres packages in the pgdg repos: dnf module disable postgresql For … Read more
Default password for postgreSQL
There is no default password on Windows – the install will ask you during the wizard to create one. If you forgot or … Read more
