On Tue, Oct 25, 2011 at 2:41 AM, Raghavendra
wrote:
> On Tue, Oct 25, 2011 at 11:40 AM, Manoj K P wrote:
>>
>> Server log Oct 1 00:06:59 server_host_name postgres[1453]: [5-1]
>> 2011-10-01 00:06:59.831 EDT 1453 4e869041.5ad postgres [local] postgres LOG:
>> duration: 418583.238 ms statement: sel
On Tue, Oct 25, 2011 at 11:40 AM, Manoj K P wrote:
> *Server log* Oct 1 00:06:59 server_host_name postgres[1453]: [5-1]
> 2011-10-01 00:06:59.831 EDT 1453 4e869041.5ad postgres [local] postgres LOG:
> duration: 418583.238 ms statement: select pg_start_backup('fortnightly');
> Oct 2 03:03:18 serve
*Server log*
Oct 1 00:06:59 server_host_name postgres[1453]: [5-1] 2011-10-01
00:06:59.831 EDT 1453 4e869041.5ad postgres [local] postgres LOG: duration:
418583.238 ms statement: select pg_start_backup('fortnightly');
Oct 2 03:03:18 server_host_name postgres[1453]: [6-1] 2011-10-02
03:03:18.2
On Mon, Oct 24, 2011 at 3:22 AM, Manoj K P wrote:
> Postgres recovered from data folder , after that some queries shows error
>
>
> select * from table2 order by app_id ; - its work ( 5000 data)
> select * from table2 order by app_id desc ; - its work
>
> Here app_id contains binary index
On Mon, Oct 24, 2011 at 8:32 AM, manoj wrote:
> On 10/24/2011 06:38 PM, Merlin Moncure wrote:
>
> On Mon, Oct 24, 2011 at 3:22 AM, Manoj K P wrote:
>
> Postgres recovered from data folder , after that some queries shows error
>
>
> select * from table2 order by app_id ; - its work ( 5000 dat
On 10/24/2011 06:38 PM, Merlin Moncure wrote:
On Mon, Oct 24, 2011 at 3:22 AM, Manoj K P wrote:
Postgres recovered from data folder , after that some queries shows error
select * from table2 order by app_id ; - its work ( 5000 data)
select * from table2 order by app_id desc ; - its wor
Postgres recovered from data folder , after that some queries shows error
select * from table2 order by app_id ; - its work ( 5000 data)
select * from table2 order by app_id desc ; - its work
Here app_id contains binary index
select * from table2 order by id ; - its work ( 5000
