Re: When adding millions of rows at once, getting out of disk space errors - Mailing list pgsql-general

From Mike Christensen
Subject Re: When adding millions of rows at once, getting out of disk space errors
Date
Msg-id 499DA61D.3070108@comcast.net
Whole thread Raw
In response to Re: When adding millions of rows at once, getting out of disk space errors  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Yea sorry good point..  It's probably at least safe to say the process
should not just hang though, and there should be more info in the log as
to what it's doing..

John R Pierce wrote:
> Mike Christensen wrote:
>> First off, when Postgres starts and sees that your database was not
>> closed properly, it should tell you there's pending transactions and
>> ask if you want to dump them or try to process them (or maybe save
>> them for later).  If you process them, there should be clear status
>> and you should know what's going on.
>
>
> how does a system service ask you anything?   a service normally
> starts when the system boots, before anyone logs onto the console.
>
>
>

pgsql-general by date:

Previous
From: Erik Jones
Date:
Subject: Re: How to pipe the psql copy command to Unix 'Date' command
Next
From: Erik Jones
Date:
Subject: Re: Appending \o output instead of overwriting the output file