![]() "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. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |