Using your suggested command I get sudo: pg_ctl: command not foundīut running without sudo I got the following promising message (which is weird given that that's essentially what I was using before but with no response): pg_ctl start -l /tmp/pglog.txt Make sure the postgres user account has full access to /usr/local/pgsql/data "Permission denied" is usually a problem with the access rights on the data directory. Did you check if the postgres (operating system) user has full access to /usr/local/pgsql/data and all sub-directories?* Sounds like a permission problem on the data directory. I feel sure that I have some permissions incorrect? Other suggested topics on StackOverflow have not been sufficient to allow me to resolve this. I've not been able to find out how it would have started previously. That is, I can now no longer connect with either PGAdminIII or psql. Having changed a few permissions, then, as far as I can tell, changed them back again, the server no longer runs on bootup. I think I installed postgresql with this command: sudo apt-get install postgresql postgresql-contrib I have changed authentication for local users in pg_hba.conf to md5 rather than peer. There are postmaster.pid and nf files in the data directory. (I'm sure I have the pw correct, but is there some way to check/change/confirm that.bearing in mind that I now can't get the server running.) If I run the same command as the postgres user (su -c 'pg_ctl start -l ~/pglog' postgres), after entering the password, the error message is: su: Authentication failure (PGDATA is set to /var/lib/postgresql/9.5/main)įolder main has user/group of postgres/postgres as does it's parent, postgresql. "/var/lib/postgresql/9.5/main/postmaster.pid": Permission denied* Now (ubuntu 16.04), this same command gives me this error: pg_ctl: could not open PID file Previously when I've used Postgres (Windows 10) I could start the server with pg_ctl start -l ~/pglog.txt I think my difficulties are with Postgres. Although I could access a localhost database either with PGAdminIII or psql (eg sudo -u postgres psql mydb), I've not been able to connect from Dart.
0 Comments
Leave a Reply. |