From: | "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> |
---|---|
To: | Ron Watkins <rwatki(at)gmail(dot)com> |
Cc: | "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Slowly making progress |
Date: | 2018-02-23 18:02:57 |
Message-ID: | CAKFQuwZhwgi6-RX=Mgh=UGCQTap9zfvZ1N=HKH1yij2-5ZNrcA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Was the lack of knowledge do to a failure to read or a failure to
understand chapter 22 in the docs? It's been a while since I've read it
but it covers all of this material seemingly quite well.
https://www.postgresql.org/docs/10/static/managing-databases.html
David J.
On Friday, February 23, 2018, Ron Watkins <rwatki(at)gmail(dot)com> wrote:
> Thanks, got it working now. As I am a newbie, I didn’t know about the
> tablespace requirement.
>
> You guys are very helpful. Thanks
>
>
>
>
>
> *From:* David G. Johnston [mailto:david(dot)g(dot)johnston(at)gmail(dot)com]
> *Sent:* Friday, February 23, 2018 10:06 AM
> *To:* Ron Watkins
> *Cc:* pgsql-novice(at)lists(dot)postgresql(dot)org
> *Subject:* Re: Slowly making progress
>
>
>
> On Fri, Feb 23, 2018 at 9:51 AM, Ron Watkins <rwatki(at)gmail(dot)com> wrote:
>
> Ok, got the default database (postgres) running.
>
> Trying to create a “user” database for the application…
>
> Can anyone spot what im doing wrong here?
>
>
>
> createdb -e -D /pgsql/DEV -E UTF8 -l en_US.UTF-8 -O postgres DEV
>
> CREATE DATABASE "DEV" OWNER postgres TABLESPACE "/pgsql/DEV" ENCODING
> 'UTF8' LC_COLLATE 'en_US.UTF-8' LC_CTYPE 'en_US.UTF-8';
>
> createdb: database creation failed: ERROR: tablespace "/pgsql/DEV" does
> not exist
>
>
>
> The TABLESPACE clause wants the name of an existing tablespace - not a
> non-existence path. Tablespaces are objects in their own right.
>
>
>
> https://www.postgresql.org/docs/9.6/static/sql-createtablespace.html
>
>
>
> https://www.postgresql.org/docs/9.6/static/sql-createdatabase.html
>
>
>
> David J.
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ron Watkins | 2018-02-23 18:06:23 | RE: Slowly making progress |
Previous Message | Ron Watkins | 2018-02-23 17:48:23 | RE: Slowly making progress |