RE: initlocation and createdb
От | Barnes |
---|---|
Тема | RE: initlocation and createdb |
Дата | |
Msg-id | 004101bfd57e$b9a495b0$0a64a8c0@fries обсуждение исходный текст |
Ответ на | Re: initlocation and createdb (Ed Loehr <eloehr@austin.rr.com>) |
Список | pgsql-general |
Hi, Ed. When I try it with the $, I get: [postgres@whopper /home]$ createdb optodb -D $PGDATA2 ERROR: The database path '/home/pgdata' is invalid. This may be due to a character that is not allowed or because the chosen path isn't permitted for databases createdb: database creation failed which looks like a variation on the same problem?? Thanks again. -----Original Message----- From: ed [mailto:ed]On Behalf Of Ed Loehr Sent: Tuesday, June 13, 2000 5:27 PM To: Barnes; pgsql-general@postgresql.org Subject: Re: [GENERAL] initlocation and createdb Ed Loehr wrote: > > Ed Loehr wrote: > > > > Barnes wrote: > > > > > > I'm having trouble setting up databases in a new location. In particular, I > > > do the following: > > > > > > [postgres@whopper pgdata]$ export PGDATA2=/home/pgdata > > > [postgres@whopper pgdata]$ initlocation PGDATA2 > > > [postgres@whopper pgdata]$ createdb optodb -D 'PGDATA2' > > > ERROR: The database path 'PGDATA2' is invalid. This may be due to a > > > character that is not allowed or because the chosen path isn't permitted for > > > databases > > > createdb: database creation failed > > > [postgres@whopper pgdata]$ > > > > > > What am I doing wrong? Is /home not permitted for databases? If so, why > > > not, and what is permitted? > > Looking at the documentation, David is apparently following this one, > which seems wrong... > > http://www.postgresql.org/docs/postgres/app-initlocation.htm > > Seems like it should be updated to the following: > > $ export PGDATA2=/opt/postgres/data > $ initlocation $PGDATA2 > $ createdb testdb -D $PGDATA2 From the same page: "If the argument does not contain a slash and is not valid as a path, it is assumed to be an environment variable, which is referenced." Ya know, sometimes I just can't help but embarrass myself. I think the problem is that, while initlocation does accept the name of an environment variable, createdb may not, and needs the $. I'll sit down now. Regards, Ed Loehr
В списке pgsql-general по дате отправления: