Extending the volume size of the data directory volume

From: panam <panam(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Extending the volume size of the data directory volume
Date: 2011-11-29 00:14:11
Message-ID: 1322525651288-5030663.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

as I am importing gigabytes of data and the space on the volume where the
data dictionary resides just became to small during that process, I resized
it dynamically (it is a LVM volume) according to this procedure:
http://www.techrepublic.com/blog/opensource/how-to-use-logical-volume-manager-lvm-to-grow-etx4-file-systems-online/3016
Everything went without any problems and the import continued. Now, it is
suddenly stuck (pgAdmin shows it as idle (piped connection)) and there is a
good chance (as estimated from the space used) it just started using one of
the added LE-Blocks (HDD space that was added to the volume). The db
imported so far can be accessed just fine.
So from the postmaster architecture, is there something that would explain
this behaviour based on the hypothesis that newly added space was used? Any
chance to revive the import somehow?

Thanks

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Extending-the-volume-size-of-the-data-directory-volume-tp5030663p5030663.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2011-11-29 02:22:02 Re: psql query gets stuck indefinitely
Previous Message John R Pierce 2011-11-28 21:30:24 Re: Stored function debugging help