From: | psql-contact(at)citecs(dot)de |
---|---|
To: | pgsql-novice(at)lists(dot)postgresql(dot)org |
Cc: | psql-contact(at)citecs(dot)de |
Subject: | can't create table on new db/schema/user |
Date: | 2020-08-28 10:32:02 |
Message-ID: | 20200828103202.GA6864@app.citecs |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
What I have:
debian 10
postgresql 11.7-0+deb10u1
What I did:
sudo -s
mkdir /var/lib/postgresql/11/ts_chris
chown postgres: /var/lib/postgresql/11/ts_chris
chmod 700 /var/lib/postgresql/11/ts_chris
su - postgres -c psql
create user "chris" with login password '***' connection limit -1;
create tablespace "ts_chris" owner chris location '/var/lib/postgresql/11/ts_chris';
alter tablespace ts_chris owner to chris;
create database db_chris owner = automicuser template = template0 encoding = "UTF-8" tablespace = ts_chris lc_collate = "C" lc_ctype = "C" connection limit = -1 ;
create schema s_chris authorization "chris";
alter role chris in database db_chris set search_path to s_chris;
grant usage on schema s_chris to chris;
grant create on schema s_chris to chris;
What I tried:
psql -h lxc05 db_chris chris
db_chris=> create table t1 (i int);
ERROR: no schema has been selected to create in
LINE 1: create table t1 (i int);
^
Debugging attempts:
postgres=# \dn+
List of schemas
Name | Owner | Access privileges | Description
---------+-------------+----------------------------+------------------------
public | postgres | postgres=UC/postgres +| standard public schema
| | =UC/postgres |
s_chris | chris | chris=UC/chris |
(3 rows)
postgres=# \dg+
List of roles
Role name | Attributes | Member of | Description
-------------+------------------------------------------------------------+-----------+-------------
chris | | {} |
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {} |
db_chris=> create table t1 (i int);
ERROR: no schema has been selected to create in
LINE 1: create table t1 (i int);
^
db_chris=> \dn+
List of schemas
Name | Owner | Access privileges | Description
--------+----------+----------------------+------------------------
public | postgres | postgres=UC/postgres+| standard public schema
| | =UC/postgres |
(1 row)
db_chris=> \dg+
List of roles
Role name | Attributes | Member of | Description
-------------+------------------------------------------------------------+-----------+-------------
chris | | {} |
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {} |
db_chris=> show search_path;
search_path
-------------
s_chris
(1 row)
So, what did I miss?
Kind regards, Chris
From | Date | Subject | |
---|---|---|---|
Next Message | hubert depesz lubaczewski | 2020-08-28 10:56:12 | Re: can't create table on new db/schema/user |
Previous Message | Schlaffer, Sharon | 2020-08-27 16:07:16 | insert vs. copy in pgAdmin |