Hi Andy,
Thanks indeed for detailed response.
Infact, I have suffered many times due to latest versions & their
dependecy/compatibility issues (not with PostgreSQL but other softwares). Thats
why I have chosen bit older version.
Anyways, now what you suggest? Should I download/reinstall 8.3.7? I wonder if
it could run successfully.
One thing more, I'm interested to have some database table in PostgreSQL
having dummy data in the backend and I could access it via Tomcat or Globus
Container as Web/Grid Service; googling "PostgreSQL with Tomcat" or Globus"
doesn't give me any help. Any suggestion in this regard?
Cheers,
-Jan
________________________________
From: Andy Shellam <andy-li...@networkmail.eu>
To: Jan Muhammad <janm...@yahoo.com>
Cc: pgsql-admin@postgresql.org; ste...@cns.vt.edu
Sent: Thursday, May 7, 2009 5:29:11 PM
Subject: Re: [ADMIN] How to run PostgreSQL?
Hi Jan
> initdb: directory "/usr/local/pgsql/data" exists but is not empty
> If you want to create a new database system, either remove or empty
> the directory "/usr/local/pgsql/data" or run initdb
> with an argument other than "/usr/local/pgsql/data"
> --------------------------------------------------------------------------
>
> Wonder what step I have missed?
>
Exactly what it says. The directory "/usr/local/pgsql/data" exists and has
some data in it. In order to get initdb to use this directory, you need to
either delete it, rename it or give initdb a different path other than
"/usr/local/pgsql/data".
If you have run initdb before in this directory (and it succeeded) you don't
need to do it again. It's possible the package manager/RPM may have run this
for you when it installed PgSQL.
If you're setting up a new PostgreSQL server, why are you using 8.2.11? For
starters, the 8.3 branch is the most recent, with 8.3.7 being the current
release of that branch, but there's also a more recent 8.2 release than the one
you've just installed, 8.2.13.
Ray, I agee with your comment; I always prefer source compilation over package
management.
Regards,
Andy
