Re: [HACKERS] Command tags in create/drop scripts

2007-05-31 Thread CAJ CAJ
On 5/31/07, CAJ CAJ <[EMAIL PROTECTED]> wrote: > Can it me made to return an integer like most UNIX commands do? This > helps > > immensely when writing shell scripts. > > Don't they do that already? If not, that's a bug quite independent of > Peter's

Re: [HACKERS] Command tags in create/drop scripts

2007-05-31 Thread CAJ CAJ
On 5/31/07, Peter Eisentraut <[EMAIL PROTECTED]> wrote: The messages output by the "scripts" always seemed unnecessary to me, e.g ., $ createdb foo CREATE DATABASE A Unix program (hi Magnus) shouldn't need to say anything if the requested action succeeded. I believe the history of this output

Re: [HACKERS] Updating large postgresql database with blobs

2007-03-12 Thread CAJ CAJ
> What is the fastest way to upgrade postgres for large databases that > has binary objects? Your procedure dumps and restore the databases twice. This seems less than sound. My prediction is that you could get a 50% speed improvement by fixing that ... Thanks for the response. This'd be wo

[HACKERS] Updating large postgresql database with blobs

2007-03-11 Thread CAJ CAJ
Hello, I didn't get any response on the GENERAL list so i'm escalating this We have several independent database servers with ~50GB+ databases running postgres 8.0.x. We are planning to upgrade these databases to postgres 8.2.xover the weekend We plan to use the following steps to upgrade

Re: [GENERAL] [HACKERS] urgent: upgraded to 8.2, getting kernel panics

2007-02-23 Thread CAJ CAJ
On 2/23/07, Tom Lane <[EMAIL PROTECTED]> wrote: "Merlin Moncure" <[EMAIL PROTECTED]> writes: > On friday we upgraded a critical backend server to postgresql 8.2 > running on fedora core 4. Umm ... why that particular choice of OS? Red Hat dropped update support for FC4 some time ago, and AFAIK