New answers tagged postgresql
0
votes
Accepted
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 ...
- 293
0
votes
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 ...
- 472
0
votes
Accepted
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 ...
- 186
0
votes
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 ...
- 101
1
vote
Accepted
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
...
- 2,915
1
vote
Accepted
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 ...
- 9,493
Top 50 recent answers are included