Tag Info

Hot answers tagged


I highly recommend that you do not run GRANT ALL PRIVILEGES ON *.* TO 'username'@'%'; This user has the SHUTDOWN privilege, which can allow the user shutdown mysql remotely with mysqladmin -hIP_of_DB Server -uusername -p shutdown You also do not want the SUPER privilege given remotely to just anyone. Why ? The SUPER privilege enables an account to ...


It turns out that I was putting my pidfile in /var/run which is fine for running it but when server is rebooted the file is deleted and pgbouncer can't find the file and it gives the this error FATAL @src/main.c:553 in function write_pidfile(): /var/run/pgbouncer/pgbouncer.pid: No such file or directory So simply moving the file to another location and ...


I ran into the same problem. To clarify what Nyxynyx hints towards in his comment, the resolution was to give permissions to access the db cluster dir (the path that follows -D in the error): chown -R postgres:postgres /var/lib/postgresql/9.1/main

Only top voted, non community-wiki answers of a minimum length are eligible