[WBEL-users] ctl script for postgresql -- Part II
Graham Purcocks
grahamp@wsieurope.com
Tue, 14 Sep 2004 11:05:40 +0100
This is a multi-part message in MIME format.
--------------000905060009070100040007
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Whats actually in /var/lib/pgsql? Is this where you have your database?
Mário Gamito wrote:
> Hi,
>
> If i run as postgres the command:
>
> # /usr/bin/postmaster -D /var/lib/pgsql/data
>
> i get:
>
> "[postgres@nau ]$ /usr/bin/postmaster -D /usr/bin/postmaster -D
> /var/lib/pgsql
> FATAL: "/var/lib/pgsql" is not a valid data directory
> DETAIL: File "/var/lib/pgsql/PG_VERSION" is missing.
> [postgres@nau ]$ /usr/bin/postmaster -D /usr/bin/postmaster -D
> /var/lib/pgsql/data
> LOG: could not create IPv6 socket: Address family not supported by
> protocol
> LOG: database system was shut down at 2004-09-08 16:09:16 WEST
> LOG: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"
> (log file 0, segment 1): No such file or directory
> LOG: invalid primary checkpoint record
> LOG: could not open file "/var/lib/pgsql/data/pg_xlog/0000000000000001"
> (log file 0, segment 1): No such file or directory
> LOG: invalid secondary checkpoint record
> PANIC: could not locate a valid checkpoint record
> LOG: startup process (PID 15063) was terminated by signal 6
> LOG: aborting startup due to startup process failure
> [postgres@nau ]$"
>
>
> Is this not recoverable ?
>
> Thank you for your answer.
>
> Warm Regards,
> Mário Gamito
>
> Graham Purcocks wrote:
>
>> I see 2 possibilities.
>>
>> Either you've upgraded to a newer version of postgres which has a
>> different database format and so you need to convert it. The
>> instructions on how to do this, will be in the place it says.
>>
>> or
>>
>> The database is trashed and so you need to recover from a backup.
>>
>> You should know better which it is. Maybe someone else has a better idea.
>>
>> Mário Gamito wrote:
>>
>>> Ok,
>>>
>>> I've found the script, but when i try to start postgresql i get the
>>> message:
>>>
>>> "An old version of the database format was found.\nYou need to
>>> upgrade the data format before using PostgreSQL.\nSee
>>> $SYSDOCDIR/rh-postgresql-$PGVERSION/README.rpm-dist for more
>>> information."
>>>
>>>
>>> What is going on ?
>>> I'm completely lost :(
>>>
>>> Any help would be appreciated.
>>>
>>> Warm Regards,
>>> Mário Gamito
>>>
>>> Mário Gamito wrote:
>>>
>>>> Hi,
>>>>
>>>> I had a problem with postgresql.
>>>> it just stoped working.
>>>> I've reinstaled it, but in the end i, have no ctl scrip for it in
>>>> /etc/init.d
>>>>
>>>> I've already searched in initscripts-7.31.13.EL.src.rpm, but nothing :(
>>>>
>>>> Does anyone knows where can i find the script ?
>>>>
>>>> Any help would be appreciated.
>>>>
>>>> Warm regards,
>>>> Mário Gamito
>>>> _______________________________________________
>>>> Whitebox-users mailing list
>>>> Whitebox-users@beau.org
>>>> http://beau.org/mailman/listinfo/whitebox-users
>>>
>>>
>>>
>>> _______________________________________________
>>> Whitebox-users mailing list
>>> Whitebox-users@beau.org
>>> http://beau.org/mailman/listinfo/whitebox-users
--------------000905060009070100040007
Content-Type: text/x-vcard; charset=utf-8;
name="grahamp.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="grahamp.vcf"
begin:vcard
fn:Graham Purcocks
n:Purcocks;Graham
org:WSI Ltd;Engineering
adr:Hockley;;22-24 Vittoria Street;Birmingham;W.Midlands;B1 3PE;U.K.
email;internet:grahamp@wsieurope.com
title:Consultant Engineer
tel;work:+44 121 233 7600
tel;fax:+44 121 233 7666
x-mozilla-html:FALSE
url:http://www.wsieurope.com
version:2.1
end:vcard
--------------000905060009070100040007--