Re: [HACKERS] Urgent Help Required

yes i am executing psql to connect to this database.

su - postgres
psql patnadbold

On Tue, Oct 8, 2013 at 8:48 PM, bricklen <bricklen(at)gmail(dot)com> wrote:

>
>
>
> On Tue, Oct 8, 2013 at 8:13 AM, shailesh singh <shaileshjuly(at)gmail(dot)com>wrote:
>
>>
>> On Tue, Oct 8, 2013 at 8:36 PM, bricklen <bricklen(at)gmail(dot)com> wrote:
>>
>>>
>>> On Tue, Oct 8, 2013 at 8:03 AM, shailesh singh <shaileshjuly(at)gmail(dot)com>wrote:
>>>
>>>> HINT: To avoid a database shutdown, execute a full-database VACUUM in
>>>> "patnadbold".
>>>> ERROR: could not access status of transaction 33011
>>>> DETAIL: could not open file "pg_clog/0000": No such file or directory
>>>> exit
>>>>
>>>>
>>>> After this i am able to stop /start my db server but i am not able to
>>>> connect to my databases (it tells to run vacuum full first on patnadbold
>>>> databases)
>>>>
>>>
>>> The message does *not* say to run "VACUUM FULL", it says to run a
>>> "full-database VACUUM". Different things.
>>> Connect to "patnadbold" and issue "VACUUM;" (without double-quotes) as
>>> the others have suggested.
>>>
>>
>> When i am trying to connect "patnadbold" , it is giving error for
>> "execute a full-database VACUUM in "patnadbold" " .
>> is there any way to connect this database using backend process . pl let
>> me know the command sequnce i need to run.
>> Thanks.
>>
>
> Please keep replies CC'd to the pgsql-general list, and follow the format
> of the other messages, which is to bottom-post.
>
> You need to show (again?) exactly what you are executing. Are you
> connecting via psql or using another command? Are you connecting directly
> to that "patnadbold" database? If you are able to connect to it, are you
> able to issue just "VACUUM;" ?
>
>
>
>
>

--
With Regards,
शैलेश सिंह |Shailesh Singh
+९१-९६५०३१७५१७ | +91-9650317517