Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
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.g.johnston@gmail.com] Sent: Friday, February 23, 2018 10:06 AMTo: Ron WatkinsCc: pgsql-novice@lists.postgresql.orgSubject: Re: Slowly making progress On Fri, Feb 23, 2018 at 9:51 AM, Ron Watkins <rwatki@gmail.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 DEVCREATE 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.htmlDavid J.
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.g.johnston@gmail.com] Sent: Friday, February 23, 2018 10:06 AMTo: Ron WatkinsCc: pgsql-novice@lists.postgresql.orgSubject: Re: Slowly making progress
On Fri, Feb 23, 2018 at 9:51 AM, Ron Watkins <rwatki@gmail.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 DEVCREATE 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
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.
В списке pgsql-novice по дате отправления: