Thread: Re: createdb -- alternate locations
[ Charset ISO-8859-1 unsupported, converting... ] > On Fri, 26 May 2000, Bruce Momjian wrote: > > > OK, I have udpated initlocation manual pages to mention stop/restart of > > postmaster and that this must be defined everytime the postmaster > > starts. Do we allow absolute paths in initlocation anymore? I am not > > sure. > > Only if you compile with ALLOW_ABSOLUTE_PATHS. So should we remove any mention of that from initlocation? -- Bruce Momjian | http://www.op.net/~candle pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
Sorry for the funky quoting, I read the digest and my mailer won't burst it. J.R. writes: > ... > mkdir /home/postgres/testdata > export PGDATA2=/home/postgres/testdata > initlocation PGDATA2 > createdb testdb -D 'PGDATA2' > > the last command failed with this error: > "The database path 'PGDATA2' in invalid. This may be due to a character > that is not allowed or because the chosen path isn't permitted for > databases" > ... > Any ideas what I'm doing wrong? Yes, you need $PGDATA2 when referencing the env var for starters. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com GPG = E987 4493 C860 246C 3B1E 6477 7838 76E9 182E 8151 ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out of room o