Re: Newbie [CentOS 5.2] service postgresql initdb

On Thu, Aug 14, 2008 at 4:18 AM, Daneel <daneel-usenet(at)owoce(dot)cz> wrote:
> Martin Marques wrote:
>>
>> Daneel escribió:
>>>
>>> Daneel wrote:
>>>>
>>>> While going through
>>>> http://wiki.postgresql.org/wiki/Detailed_installation_guides
>>>> and typing
>>>> service postgresql start
>>>> as root I got
>>>> "/var/lib/pgsql/data is missing. Use "service postgresql initdb" to
>>>> initialize the cluster first."
>>>>
>>>> When I run
>>>> service postgresql initdb
>>>> I get
>>>> "se: [FAILED]".
>>>> However, /var/lib/pqsql/data is created and user postgres owns it.
>>>>
>>>> But then I run
>>>> service postgresql start
>>>> and the very same error occurs..
>>>>
>>>> Daneel
>>>
>>> Shoud add that version is 8.3.1 and I've installed it using RPM
>>> packages... Thanks in advance for any tip...
>>
>> Where did you get the rpm packages?
>>
>
> I downloaded them from rpmfind.net They were Fedora 9 i386 version.

You need to use the version for RHEL, not fedora. There are versions
of 8.3 for RHEL3,4 and 5 on the postgresql ftp sites and that's what I
use.

> I reinstalled CentOS yesterday and during installation I checked to include
> PostgreSQL 8.1.11. Now it seems to work properly.

You should really explore running 8.3.3. It's much faster than 8.1
and has a few features that are really nice to have.