Jong Chun Park wrote:
> > sudo mkdir /home/pgsql
> > sudo mkdir /home/pgsql/data
> > sudo chown postgres /home/pgsql/data
> > sudo mkdir /home/pgsql/ts
> > sudo chown postgres /home/pgsql/ts
> > sudo su - postgres
> > initdb -D /home/pgsql/data
> > pg_ctl -D /home/pgsql/data -l logfile start
Can you issue as a superuser in psql:
SHOW data_directory;
and check that the result is what you expect?
Also, are you using the ubuntu postgresql-8.3 package or a self-compiled
version?
Best regards,
--
Daniel
PostgreSQL-powered mail user agent and storage: http://www.manitou-mail.org