Обсуждение: Re: Newbie [CentOS 5.2] service postgresql initdb

Поиск
Список
Период
Сортировка

Re: Newbie [CentOS 5.2] service postgresql initdb

От
Daneel
Дата:
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...

Daneel

Re: Newbie [CentOS 5.2] service postgresql initdb

От
Martin Marques
Дата:
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?

Re: Newbie [CentOS 5.2] service postgresql initdb

От
Daneel
Дата:
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.

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

Daneel

Re: Newbie [CentOS 5.2] service postgresql initdb

От
"Scott Marlowe"
Дата:
On Thu, Aug 14, 2008 at 4:18 AM, Daneel <daneel-usenet@owoce.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.