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

2011-01-28 Thread Frank Brendel
Hi Tom, thanks for this really fast reply. I've removed the line #include asm/ia64regs.h and it compiles now. The function __getReg(_IA64_REG_AR_BSP) In postgres.c seems to be called only on Intel compilers. And I see in asm/ia64regs.h (found on a Linux box) #define _IA64_REG_AR_BSP

[ADMIN] WARNING: transaction log file ..... could not be archived: too many failures

2011-01-28 Thread Joby Joba
Hello. The following message appears continuously in the log file of postgresql : Jan 28 11:35:01 abcd postgres[28359]: [81-1] LOG: archive command cp pg_xlog/00010085 /u10/postgres/archive/00010085 failed: return Jan 28 11:35:01 abcd postgres[28359]: [81-2]

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

2011-01-28 Thread Bernhard Schrader
Am Donnerstag, den 27.01.2011, 13:12 -0500 schrieb 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

Re: [ADMIN] WARNING: transaction log file ..... could not be archived: too many failures

2011-01-28 Thread Kevin Grittner
Joby Joba jobyjob...@gmail.com wrote: Jan 28 11:35:01 abcd postgres[28359]: [81-1] LOG: archive command cp pg_xlog/00010085 /u10/postgres/archive/00010085 failed: return Jan 28 11:35:01 abcd postgres[28359]: [81-2] code 256 The problem is that the

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

2011-01-28 Thread Tom Lane
Frank Brendel frank.bren...@eurolog.com writes: I've removed the line #include asm/ia64regs.h and it compiles now. OK, thanks for confirming that. Since this is not the default behavior are there any concerns to install this version into production? No, it will be the default behavior

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

2011-01-28 Thread Frank Brendel
Cool! Thanks a lot! Frank Am 28.01.2011 16:17, schrieb Tom Lane: Frank Brendelfrank.bren...@eurolog.com writes: I've removed the line #includeasm/ia64regs.h and it compiles now. OK, thanks for confirming that. Since this is not the default behavior are there any concerns to install

Re: [ADMIN] Warm Standby looking for already applied log files

2011-01-28 Thread Dimitri Fontaine
Kevin Grittner kevin.gritt...@wicourts.gov writes: that script to not delete. Personally, I like to keep the last two base backups and all the WAL files needed to restore from the earlier of those forward. We have cleanup script that deletes the oldest backup and WAL files only needed for

Re: [ADMIN] Warm Standby looking for already applied log files

2011-01-28 Thread Kevin Grittner
Dimitri Fontaine dimi...@2ndquadrant.fr wrote: Kevin Grittner kevin.gritt...@wicourts.gov writes: that script to not delete. Personally, I like to keep the last two base backups and all the WAL files needed to restore from the earlier of those forward. We have cleanup script that deletes

Re: [ADMIN] Warm Standby looking for already applied log files

2011-01-28 Thread Dimitri Fontaine
Kevin Grittner kevin.gritt...@wicourts.gov writes: I don't suppose there's something which looks *into* a backup file and deletes all WAL files not needed to restore the related base backup? That would eliminate an even *uglier* bash script here. Well with some luck Magnus will be able to

[ADMIN] Drop Schema Error

2011-01-28 Thread Bradley Holbrook
Hello! I'm trying to: DROP SCHEMA _old_permissions; And I get this error: ERROR: cannot drop schema _old_permissions because other objects depend on it DETAIL: function 17059 depends on schema _old_permissions function 17060 depends on schema _old_permissions HINT: Use DROP . CASCADE