problem after an hd failure

Поиск
Список
Период
Сортировка
От JEANARTHUR@EUROVOX.FR
Тема problem after an hd failure
Дата
Msg-id 3EB25DBC.31349.8F65D6@localhost
обсуждение исходный текст
Ответ на create procedure  (sivasankaran <shankar_cva@yahoo.co.in>)
Ответы Re: problem after an hd failure  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Hi,

We just had a problem on the hard disk we resolved with fsck.

Database server runs, queries on the DB seems ok, but when we do a
vacuum (full or not), we have after some tables were vaccumed :

mai  2 11:49:34 aphrodite logger: PANIC:  XLogFlush: request
635F6373/6B636568 is not satisfied --- flushed only to 14/F9473CF4
mai  2 11:49:34 aphrodite logger: LOG:  statement: SET autocommit
TO 'on';VACUUM  VERBOSE ANALYZE
mai  2 11:49:34 aphrodite logger: LOG:  server process (pid 3673)
was terminated by signal 6
mai  2 11:49:34 aphrodite logger: LOG:  terminating any other active
server processes
mai  2 11:49:34 aphrodite logger: LOG:  all server processes
terminated; reinitializing shared memory and semaphores
mai  2 11:49:34 aphrodite logger: LOG:  database system was
interrupted at 2003-05-02 11:49:31 CEST
mai  2 11:49:34 aphrodite logger: LOG:  checkpoint record is at
14/F89F89A0
mai  2 11:49:34 aphrodite logger: LOG:  redo record is at
14/F89F89A0; undo record is at 0/0; shutdown TRUE
mai  2 11:49:34 aphrodite logger: LOG:  next transaction id:
121015461; next oid: 9816181
mai  2 11:49:34 aphrodite logger: LOG:  database system was not
properly shut down; automatic recovery in progress
mai  2 11:49:34 aphrodite logger: LOG:  redo starts at 14/F89F89E0

and the vacuum stops...

Is there a solution or can I just do a pg_dump of the DB, the re-init the
DB and resotring the db ?

thank you




On 24 Apr 2003 at 7:05, sivasankaran wrote:

>
> Hello sir,
>
> I don't see the create procedure command in PostgreSQL. Do you
> tell me how to do it? or which document do I have to read?
> Catch all the cricket action. Download Yahoo! Score tracker


Jean-Arthur Silve
EuroVox
4, Place Félix Eboué
75583 Paris Cedex 12
T : +33 1 44670505
F : +33 1 44670519


В списке pgsql-admin по дате отправления:

Предыдущее
От: "A.Bhuvaneswaran"
Дата:
Сообщение: Re: Changing colums type
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: The database system is in recovery mode