Re: [ADMIN] pg_upgrade 8.3 to 9.0, shutdown is to slow

2011-01-27 Thread Bernhard Schrader
it's the same behaviour, it doesnt stop. what maybe is also interesting, if i start the database manually i have a huge waiting IO of 23% for a time of maybe 2-5 minutes, i think it is because of the fragmentation of the tables. is the shutdown so slow because of the waiting io? but why can i st

Re: [ADMIN] pg_upgrade 8.3 to 9.0, shutdown is to slow

2011-01-27 Thread Kevin Grittner
Bernhard Schrader wrote: > what maybe is also interesting, if i start the database manually i > have a huge waiting IO of 23% for a time of maybe 2-5 minutes, i > think it is because of the fragmentation of the tables. > > is the shutdown so slow because of the waiting io? but why can i > stop

Re: [ADMIN] pg_upgrade 8.3 to 9.0, shutdown is to slow

2011-01-27 Thread Bernhard Schrader
Am Donnerstag, den 27.01.2011, 09:18 -0600 schrieb Kevin Grittner: > Bernhard Schrader wrote: > > > what maybe is also interesting, if i start the database manually i > > have a huge waiting IO of 23% for a time of maybe 2-5 minutes, i > > think it is because of the fragmentation of the tables.

Re: [ADMIN] pg_upgrade 8.3 to 9.0, shutdown is to slow

2011-01-27 Thread Bruce Momjian
Bernhard Schrader wrote: > Am Donnerstag, den 27.01.2011, 09:18 -0600 schrieb Kevin Grittner: > > Bernhard Schrader wrote: > > > > > what maybe is also interesting, if i start the database manually i > > > have a huge waiting IO of 23% for a time of maybe 2-5 minutes, i > > > think it is because

Re: [ADMIN] pg_upgrade 8.3 to 9.0, shutdown is to slow

2011-01-27 Thread Scott Marlowe
On Thu, Jan 27, 2011 at 9:12 AM, Bruce Momjian wrote: > Bernhard Schrader wrote: >> Am Donnerstag, den 27.01.2011, 09:18 -0600 schrieb Kevin Grittner: >> > Bernhard Schrader wrote: >> > >> > > what maybe is also interesting, if i start the database manually i >> > > have a huge waiting IO of 23%

Re: [ADMIN] pg_upgrade 8.3 to 9.0, shutdown is to slow

2011-01-27 Thread Bruce Momjian
Scott Marlowe wrote: > > My initial reaction is that something is wrong with your system, either > > the I/O or the way it is being shutdown by the script. ?I would start to > > look in the script and do some pg_ctl tests starting/stopping the > > server. > > It could be that his application or wh

[ADMIN] asm/ia64regs.h not found on FreeBSD 8.1 IA64

2011-01-27 Thread Frank Brendel
Hi list, I can't compile PostgreSQL 9.0.2 on FreeBSD 8.1 for IA64. The error message is postgres.c:2998:26: error: asm/ia64regs.h: No such file or directory There is no ia64regs.h in the file system. I guess this is a Linux header file. Do I have to install some additional ports? Many t

Re: [ADMIN] asm/ia64regs.h not found on FreeBSD 8.1 IA64

2011-01-27 Thread Tom Lane
"Frank Brendel" writes: > I can't compile PostgreSQL 9.0.2 on FreeBSD 8.1 for IA64. > The error message is > postgres.c:2998:26: error: asm/ia64regs.h: No such file or directory Hmm, the need for that header file is a very recent addition. I'm not very surprised to hear of portability issues

Re: [ADMIN] asm/ia64regs.h not found on FreeBSD 8.1 IA64

2011-01-27 Thread ๏̯͡๏ Guido Barosio
FYI the url returned 404 "404 - No such project " gb.- On Thu, Jan 27, 2011 at 2:25 PM, Tom Lane wrote: > "Frank Brendel" writes: >> I can't compile PostgreSQL 9.0.2 on FreeBSD 8.1 for IA64. >> The error message is >>     postgres.c:2998:26: error: asm/ia64regs.h: No such file or directory > >

Re: [ADMIN] pg_upgrade 8.3 to 9.0, shutdown is to slow

2011-01-27 Thread Bernhard Schrader
Am Donnerstag, den 27.01.2011, 12:09 -0500 schrieb Bruce Momjian: > Scott Marlowe wrote: > > > My initial reaction is that something is wrong with your system, either > > > the I/O or the way it is being shutdown by the script. ?I would start to > > > look in the script and do some pg_ctl tests sta

Re: [ADMIN] asm/ia64regs.h not found on FreeBSD 8.1 IA64

2011-01-27 Thread Tom Lane
=?UTF-8?B?4LmPzK/NoeC5jyBHdWlkbyBCYXJvc2lv?= writes: > FYI the url returned 404 > "404 - No such project " Really? Works for me. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgre

Re: [ADMIN] pg_upgrade 8.3 to 9.0, shutdown is to slow

2011-01-27 Thread Bruce Momjian
Bernhard Schrader wrote: > Am Donnerstag, den 27.01.2011, 12:09 -0500 schrieb Bruce Momjian: > > Scott Marlowe wrote: > > > > My initial reaction is that something is wrong with your system, either > > > > the I/O or the way it is being shutdown by the script. ?I would start to > > > > look in the

[ADMIN] Clarification of pg_cotroldata output

2011-01-27 Thread Melvin Davidson
*Can someone please clarify? When I execute pg_control on a warm standby cluster, I notice that often, "Time of latest checkpoint:" lags behind "pg_control last modified:". Is it documented anywhere the difference between "pg_control last modified:" and "Time of latest checkpoint:" ? Thanks in

Re: [ADMIN] asm/ia64regs.h not found on FreeBSD 8.1 IA64

2011-01-27 Thread ๏̯͡๏ Guido Barosio
This one works fine: http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff; gb.- On Thu, Jan 27, 2011 at 2:52 PM, Tom Lane wrote: > =?UTF-8?B?4LmPzK/NoeC5jyBHdWlkbyBCYXJvc2lv?= writes: >> FYI the url returned 404 >> "404 - No such project " > > Really?  Works for me. > >