Philipp Kraus wrote:
>> Do you want to implement something like a queue?
>
> Yes
>> You get a few rows by
>> UPDATE table SET status = processing WHERE id IN
>>(SELECT id FROM table WHERE status = waiting
>>ORDER BY id LIMIT 5) RETURNING *;
>> Then process and update the rows.
>>
>> T
Forgot to include the list! Sorry!
If you have a non-standard socket file location pg_upgrade will not work
for this upgrade.
On Fri, Apr 5, 2013 at 9:37 AM, Leonardo Carneiro wrote:
> Beside all notes, i recommend you to use pg_upgrade, to avoid a complete
> backup/restore in your transition.
