All Questions
Tagged with postgresql permissions
11 questions
1
vote
0
answers
72
views
Docker how to overcome "change of ownership" error of a folder from an external mounted SSD drive
I have a question regarding ownership mapping of folders via the Docker-Compose file.
Shortly to my problem:
I'm using Docker on my RaspiPi 4 and wanted to enter the world of paperless office (...
- 11
1
vote
1
answer
341
views
Issue when creating a new user and group on macOS
I need to create a user and a group called postgres on my mac but I seem to have issues with that. The reason for needing this user is because I've installed postgresql@15 via brew and it created a ...
- 113
0
votes
0
answers
46
views
granting privileges to user in postgresql
I'm trying to setup a new project with a Postgresql 15.5 database.
I have a running instance. If I create a new database
psql --command "create database \"tagger-db\""
create a ...
- 101
4
votes
2
answers
15k
views
Postgres docker error "data directory "/var/lib/postgresql/data" has wrong ownership"
I am trying to start a postgres container using docker
I have tried using multiple versions of postgres docker images
I have tried using volumes as mentioned here
tried setting POSTGRES_USER ...
- 80
3
votes
0
answers
737
views
Azure database for postgresql: change the owner of a table without using the super user
I'm working on a PostgreSQL v10 Database created in Azure. This database has several users including:
myuser: user used by a web application. Has limited powers;
myadmin: admin user created by azure ...
- 395
-1
votes
3
answers
8k
views
running into permission issues when using the COPY command with postgresql 14.6-1 on linux 6.0.12-arch1-1
Hello everyone :) noob here,
trying to learn sql with postgresql 14.6-1 on arch linux kernel: 6.0.12-arch1-1 ,
the current topic of the book i'm reading, has me doing this command
COPY char_data_types ...
2
votes
0
answers
931
views
Installing postgres on windows with locale
Disclaimer: as this should be a standard operation, i feel something on my side must have gone terribly wrong.
I am trying to use postgresql on windows 71. The installer from edb works fine, apart ...
- 121
3
votes
2
answers
46k
views
Grant function execute to user in Postgres
In documentation on https://www.postgresql.org/docs/9.1/sql-grant.html theres a syntax to GRANT command.
GRANT { EXECUTE | ALL [ PRIVILEGES ] }
ON { FUNCTION function_name ( [ [ argmode ] [ ...
- 387
1
vote
0
answers
214
views
Permission denied trying to setup postgres sql
I'm trying to setup Dspace for a uni job here, but this Protgres SQL is asking for a password (For the postgres user) but it's supposed to be indent, I have no idea what's going on.
So, When I try to ...
- 111
0
votes
1
answer
349
views
CentOS6 Backup fails; "permission denied"
I am currently trying to do a backup of a server and am getting an error message when running my script. The script runs correctly on certain directories, but for the directory I am attempting to use ...
- 101
2
votes
3
answers
3k
views
Superuser rights on postgres
How do I get superuser rights on postgres. I am among sudoers in Linux, but I don't have rights to create users in postgres. How can I gain superuser rights in postgres?
This is my pg_hba.conf:
# ...
- 113