Skip site navigation (1) Skip section navigation (2)

Re: How to run PostgreSQL?

From: Jan Muhammad <janmuhd(at)yahoo(dot)com>
To: Andy Shellam <andy-lists(at)networkmail(dot)eu>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to run PostgreSQL?
Date: 2009-05-07 16:44:18
Message-ID: 899617.38010.qm@web38706.mail.mud.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-admin
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-lists(at)networkmail(dot)eu>
To: Jan Muhammad <janmuhd(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org; stellr(at)cns(dot)vt(dot)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



      

In response to

pgsql-admin by date

Next:From: Joshua D. DrakeDate: 2009-05-07 16:58:04
Subject: Re: How to run PostgreSQL?
Previous:From: Tom LaneDate: 2009-05-07 16:42:56
Subject: Re: How to run PostgreSQL?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group