Re: Timeouts after upgrade from 9.0 to 9.3

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Timeouts after upgrade from 9.0 to 9.3
Дата
Msg-id 5363F5BC.5050406@aklaver.com
обсуждение исходный текст
Ответ на Timeouts after upgrade from 9.0 to 9.3  (gvim <gvimrc@gmail.com>)
Список pgsql-general
On 05/02/2014 10:46 AM, gvim wrote:
> I've just upgraded a server from 9.0 to 9.3 using the pgupgrade.sh
> script and setup the same config but now,  when I connect with the
> latest pgAdmin III I get a timeout after leaving the connection open for
> a few minutes. Where can I diagnose this fault?

A lot of information missing, so flying sort of blind here. To help fill
in the blanks:

1) What OS/distribution are you running?

2) I am not familiar with pgupgrade.sh. What does it do?

3) You say latest PgAdmin3, does that mean you upgraded it at the same
time and if so to what version?

As to how to troubleshoot:

1) Look in the Postgres log and see if there is anything informative. If
you have not already, in postgresql.conf enable connection/disconnection
logging.

2) Are connecting locally or remotely?

>
> gvim
>
>


--
Adrian Klaver
adrian.klaver@aklaver.com


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

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Vacuuming strategy
Следующее
От: Tim van der Linden
Дата:
Сообщение: Re: Full text: Ispell dictionary