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 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_BSP3089 in a s

[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/

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

2011-01-28 Thread Kevin Grittner
Joby Joba 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 requested file is

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

2011-01-28 Thread Tom Lane
"Frank Brendel" writes: > I've removed the line > #include > 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 come Monday ;-) http://git.postgresq

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 Brendel" writes: >> I've removed the line >> #include >> 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

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

2011-01-28 Thread Dimitri Fontaine
"Kevin Grittner" 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 recovery from it when

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

2011-01-28 Thread Kevin Grittner
Dimitri Fontaine wrote: > "Kevin Grittner" 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 ne

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

2011-01-28 Thread Dimitri Fontaine
"Kevin Grittner" 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 complete pg_basebackup in

[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