New answers tagged postgresql
How to pass server configuration to postgres docker via a compose file?
It can be passed in command section. The updated docker-compose file with idle_session_timeout set to 15 mins is like below version: '3' services: # IMPORTANT NOTE: All other services will share the ...
PostgresSQL upgrade from 9.6 to 10 on Windows fails when using pg_upgrade (fe_sendauth: no password supplied)
on windows there are two things necessary to do before starting pg_upgrade enable "passwordless" authentication by editing pg_hba.conf replacing md5 or whatever other method by trust in ...
Emergency database does not shut down
There is different options you can try if the database is not shutting down properly: first identify the PID pg_ctl status then try to kill it with its PID kill [PID] then you should be able to ...
Using PGPASSWORD variable does not seem to work any more on Postgresql 9.3
Another alternative for those who do not want .pgpass file and want to execute in a single command line instance. set "PGPASSWORD=yourpass" && createdb -h localhost -p 5432 -U ...
how to operate replicated database properly
Q: What I want is to 'select' only from the repl db, and 'insert/update/delete' from the source db. In this case, should I have to connect to repl db everytime I select, and connect to source db in ...
Why it asks me to input password here to restart db
When you run sudo su - postgres It invokes a new shell, which is owned by postgres user. Then, from that shell you run another sudo: sudo service postgres restart And it, unsurprisingly, asks ...
Top 50 recent answers are included