On Feb 18, 2008 6:15 AM, Kakoli Sen <kakolis@xxxxxxxxxxxxxx> wrote: > > > > Hi, > I install PostgreSQL 7.3.21 successfully with sudo and could start > the postmaster as sudo. The postmaster won't starte without a valid data directory. > Then I want to initialise my own db as unprivileged user. I run the > following commands: > > root# mkdir /usr/local/pgsql/data > root# chown kakolis /usr/local/pgsql/data > root# su kakolis > kakolis$ initdb -D /usr/local/pgsql/data. > > The last command gives the following output: > Fixing permissions on existing directory /usr/local/pgsql/data... ok > creating directory /usr/local/pgsql/data/base... ok > creating directory /usr/local/pgsql/data/global... ok > creating directory /usr/local/pgsql/data/pg_xlog... ok > creating directory /usr/local/pgsql/data/pg_clog... ok > creating template1 database in /usr/local/pgsql/data/base/1... > initdb failed. > > Where is the problem? The db is already initted? Just guessing. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
