Re: [HACKERS] Warm-Standby using WAL archiving / Seperate

2006-07-11 Thread Andrew Rawnsley
Just having a standby mode that survived shutdown/startup would be a nice start... I also do the blocking-restore-command technique, which although workable, has a bit of a house-of-cards feel to it sometimes. On 7/10/06 5:40 PM, Florian G. Pflug [EMAIL PROTECTED] wrote: Merlin Moncure

Re: [HACKERS] streamlined standby procedure

2006-02-08 Thread Andrew Rawnsley
On 2/7/06 1:19 PM, Tom Lane [EMAIL PROTECTED] wrote: Andrew Rawnsley [EMAIL PROTECTED] writes: IMHO the #1 priority in the current PITR/WAL shipping system is to make the standby able to tolerate being shut down and restarted, i.e. actually having a true standby mode and not the current

Re: [HACKERS] streamlined standby procedure

2006-02-07 Thread Andrew Rawnsley
IMHO the #1 priority in the current PITR/WAL shipping system is to make the standby able to tolerate being shut down and restarted, i.e. actually having a true standby mode and not the current method of doing it only on startup. While it is a trivial thing to fool postgres into staying in

Re: [HACKERS] Problem with PITR recovery

2005-04-20 Thread Andrew Rawnsley
for. ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings Andrew Rawnsley Chief Technology Officer Investor Analytics, LLC (740) 587-0114 http://www.investoranalytics.com ---(end of broadcast

Re: [HACKERS] Call for port reports

2004-12-07 Thread Andrew Rawnsley
PostgreSQL 8.0.0rc1 on powerpc-apple-darwin7.5.0, compiled by GCC gcc (GCC) 3.3 20030304 (Apple Computer, Inc. build 1495) Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114

Re: [HACKERS] Time off

2004-10-19 Thread Andrew Rawnsley
jd.vcf ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast

Re: [HACKERS] version upgrade

2004-09-01 Thread Andrew Rawnsley
On Aug 31, 2004, at 11:35 PM, Jan Wieck wrote: On 8/31/2004 9:38 PM, Andrew Rawnsley wrote: On Aug 31, 2004, at 6:23 PM, Marc G. Fournier wrote: On Tue, 31 Aug 2004, Josh Berkus wrote: Andrew, If I were loony enough to want to make an attempt at a version updater (i.e. migrate a 7.4 database

Re: [HACKERS] version upgrade

2004-08-31 Thread Andrew Rawnsley
]) Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP 8: explain analyze is your friend

[HACKERS] version upgrade

2004-08-30 Thread Andrew Rawnsley
? Is dusting off pg_upgrade a good place to start, or is that a dead end? There any chance of getting something to work at all? (I figure I made enough of a stink about it last year about this time, I should at least make the attempt...or have one of my minions do it...) Andrew

Re: [HACKERS] Too-many-files errors on OS X

2004-02-23 Thread Andrew Rawnsley
of broadcast)--- TIP 8: explain analyze is your friend Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP 2: you can get

Re: [HACKERS] Recursive queries?

2004-02-04 Thread Andrew Rawnsley
Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] pljava revisited

2003-12-10 Thread Andrew Rawnsley
: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP

Re: [HACKERS] pljava revisited

2003-12-10 Thread Andrew Rawnsley
---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast

Re: [HACKERS] Is there going to be a port to Solaris 9 x86 in the near future???

2003-11-18 Thread Andrew Rawnsley
://www.eviloverlord.com/ ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd

Re: [HACKERS] [GENERAL] Proposal for a cascaded master-slave replication system

2003-11-11 Thread Andrew Rawnsley
can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED]) Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast

Re: [HACKERS] Hacking PostgreSQL to work in Mac OS X 10.3 (Panther

2003-11-04 Thread Andrew Rawnsley
)--- TIP 8: explain analyze is your friend Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ

Re: [HACKERS] Single-file DBs WAS: Need concrete Why Postgres

2003-08-22 Thread Andrew Rawnsley
: subscribe and unsubscribe commands go to [EMAIL PROTECTED] Andrew Rawnsley President The Ravensfield Digital Resource Group, Ltd. (740) 587-0114 www.ravensfield.com ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster