public inbox for [email protected]  

help / color / mirror / Atom feed

From: [email protected]
To: [email protected]
Cc: [email protected]
Subject: can't create table on new db/schema/user
Date: Fri, 28 Aug 2020 12:32:02 +0200
Message-ID: <[email protected]> (raw)

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

view thread (6+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: can't create table on new db/schema/user
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox