On 04/19/2017 11:24 PM, Ron Ben wrote:
OK. I think I found a bug in PostgreSQL (9.3).
When I do:
CREATE ROLE ronb
SUPERUSER INHERIT CREATEDB CREATEROLE NOREPLICATION;
Everything works. I can create the schemas and upload the backup correclty.
But if I do:
CREATE ROLE "ronb" LOGIN
NOSUPER
OK. I think I found a bug in PostgreSQL (9.3).
When I do:
CREATE ROLE ronb SUPERUSER INHERIT CREATEDB CREATEROLE NOREPLICATION;
Everything works. I can create the schemas and upload the backup correclty.
But if I do:
CREATE ROLE "ronb" LOGIN NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE N
Hi,
Seems to me your role "ronb" doesn't have the rights to create schema on your
database.
Please refer to the GRANT command in the documentation.
https://www.postgresql.org/docs/9.0/static/sql-grant.html
Sent from [ProtonMail](https://protonmail.ch), encrypted email based in
Switzerland.
-
On 04/19/2017 07:16 AM, Ron Ben wrote:
Here :)
Thanks.
See my previous response. Basically we need more information before this
can be solved.
I think I may have found the problem.
The role defined as:
CREATE ROLE "ronb" LOGIN
NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;
Here :)
I think I may have found the problem.
The role defined as:
CREATE ROLE "ronb" LOGIN NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;GRANT users TO "ronb";
GRANT users2 TO "ronb";
users is a group role:
CREATE ROLE users SUPERUSER INHERIT CREATEDB CREATEROLE NOREPLICAT
On 04/19/2017 06:49 AM, Ron Ben wrote:
Is it possible to get your email program to left justify text on
sending? I can figure out the right justified text, it just takes me longer.
I think I may have found the problem.
The role defined as:
CREATE ROLE "ronb" LOGIN
NOSUPERUSER INHERIT NOCR
I think I may have found the problem.
The role defined as:
CREATE ROLE "ronb" LOGIN NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION;GRANT users TO "ronb";
GRANT users2 TO "ronb";
users is a group role:
CREATE ROLE users SUPERUSER INHERIT CREATEDB CREATEROLE NOREPLICATION;
On 04/19/2017 03:56 AM, Ron Ben wrote:
Hi,
I'm using PostgreSQL 9.3.2
I'm running the command:
psql -h testserver -U ronb -f backup.sql -q -d foldertest 2>error.txt
output.txt
What was the command that created backup.sql?
This should generate my database in foldertest
However this does
