0
votes
0answers
11 views

Docker: Permission denied on folders added with ADD

I'm trying to configure a postgresql installation using docker. FROM ubuntu:13.10 ADD . /db # install postgres # ... RUN chown postgres:postgres /db -R && \ chmod 700 /db -R USER ...
0
votes
1answer
41 views

What should the permissions be on for PostgreSQL /data files?

I installed Postgres 9.3 from the osX binary. When I attempted to restart using pg_ctl restart, I received the following error: $ pg_ctl restart pg_ctl: could not open PID file ...
0
votes
1answer
64 views

How can I change the Postgres data_directory folder location?

I use Ubuntu 12.04, postgresql 9,1 postgis 1.5. I want to change database location. I use instruction http://www.whiteboardcoder.com/2012/04/change-postgres-datadirectory-folder.html The only ...
0
votes
1answer
1k views

Strange permission errors in new PostgreSQL installation

A freshly installed PostgreSQL (with configuration overwritten) won't start: $ sudo service postgresql start * Starting PostgreSQL 9.1 database server * Error: could not read ...
14
votes
1answer
26k views

Postgresql: what does GRANT ALL PRIVILEGES ON DATABASE do?

I'm trying to grant all privileges on all tables of a given database to a new postgres user (not the owner). It seems that GRANT ALL PRIVILEGES ON DATABASE my_db TO new_user; does not do that. After ...
1
vote
1answer
412 views

Can't read directory owned by my group

I moved the postgres data directory to a separate partition and it works great. The directory is owned by postgres user and postgres group. d-wx------ 11 postgres postgres 4.0K 2010-06-11 08:28 ...
1
vote
3answers
5k views

Proper Way to Grant Permissions in PostgreSQL

I am new to PostgreSQL and am having a bit of trouble finding any information on how to grant a user permissions on the database that they own. I have read a few sources that says the owner has all ...
2
votes
2answers
877 views

PostgreSQL User Permissions

I'm trying make a transition from MySQL to PostgreSQL, but find the user accounts/permissions system to be quite different. With mysql, all accounts are handled internally by mysql. With postgres is ...
2
votes
1answer
2k views

PostgreSQL: Permission to execute function (that inserts into a table) but no permission to insert directly

Sorry if this is the wrong place to ask this question. I have created a function that inserts values into many tables, and I want the web front-end to execute this function. I have granted execute ...
17
votes
5answers
27k views

GRANT SELECT to all tables in postgresql

Is there a one-liner that grants the SELECT permissions to a new user postgresql? Something that would implement the following pseudo-code: GRANT SELECT ON TABLE * TO my_new_user;
0
votes
1answer
622 views

To fix Postgres' login permissions for a new user

How can you enable the login for heo? I get the following The problem seems to be in permissions for the user/role "heo" and probably in pg_hba.conf. I put the following line to the file ...