Re: device full ---> postgres will not start - Mailing list pgsql-admin

Assuming you'll be upgrading from 7.2 to 7.2.4, then yes, all you need to
do is upgrage the rpms.  you can do tham all at once, assuming they're in
the same directory and named postgresql-something or other:

rpm -Uvh postgresql*

should do it.

If you want to upgrade to 7.3.4, then you'll need to do a pg_dumpall first
and save the output of that file like so:

pg_dumpall >mydata.sql

so you can restore it.  Then, after installing 7.3.4, you'll need to set
up a data directory and restore there.  If you've got the space, do that
somewhere other than the old 7.2.x data directory, as you may have some
issues and need to go back to 7.2.x and tweak the backup procedure etc...

On 27 Oct 2003, kbd wrote:

> i will take the advice and upgrade to 7.2.4 ASAP as in now.
>
> this what rpm reports on the server currently:
> [root@localhost root]# rpm -qa | grep postgres
> postgresql-jdbc-7.2.1-5
> postgresql-libs-7.2.1-5
> postgresql-7.2.1-5
> postgresql-server-7.2.1-5
> postgresql-contrib-7.2.1-5
> postgresql-devel-7.2.1-5
> [root@localhost root]#
>
> i downloaded the following:
> [root@localhost download]# ls
> postgresql-7.2.4-1PGDG.i386.rpm          postgresql-libs-7.2.4-1PGDG.i386.rpm
> postgresql-contrib-7.2.4-1PGDG.i386.rpm  postgresql-perl-7.2.4-1PGDG.i386.rpm
> postgresql-devel-7.2.4-1PGDG.i386.rpm    postgresql-server-7.2.4-1PGDG.i386.rpm
> postgresql-docs-7.2.4-1PGDG.i386.rpm     postgresql-tcl-7.2.4-1PGDG.i386.rpm
> postgresql-jdbc-7.2.4-1PGDG.i386.rpm
> [root@localhost download]#
>
>
> i have done new installs using RPMs, but not an upgrade.
> silly question time:
> are these the correct RPMs?
> do I just upgrade them one at a time as follows:
>   rpm -Uvh  postgresql.......rpm
>
>
> many thanks
>
> kd
>
>
>
>
>
>
>
> scott.marlowe@ihs.com ("scott.marlowe") wrote in message
news:<Pine.LNX.4.33.0310270756530.14845-100000@css120.ihs.com>...
> > On Fri, 24 Oct 2003, Duffy House wrote:
> >
> > > Hello:
> > >
> > > It looks like I got caught sleeping.
> > >
> > > I am running Postgresql 7.2 under Red Hat 7.3.
> > > Postgresql failed today.  When I tried to restart it, I got a message
> > > stating that the device is full.
> > > I used df to confirm that /var where postgres reside is full.  /var is on a
> > > 4 Gig device.
> > > Postgresql is the only application on this machine.
> > >
> > > Please note, the backup of the database from the prior day, is 45 Meg
> > > zipped.
> > > I do not know how the database could be soaking up a 4 Gig device.
> > >
> > > Questions:
> > >
> > > How can I recover from this situation?
> > >
> > > If postgres will not start how can I restore the database from the prior
> > > day?
> > >
> > > When I run a backup does postgres truncate its logs?
> > >
> > > please keep it simple, I have about 1 hours admin experience with postgres.
> > >
> > > thanks in advance.
> >
> > It sounds like either you've never run vacuum, or you've had a few threads
> > holding transactions open for a very long time.
> >
> > Easiest way to recover:  Make a bigger partition, cp everything there, and
> > point the postmaster at that partition to startup.  Then vacuum etc... and
> > copy it all back over the original partition.  Then make sure you're
> > running the latest and greatest (at least 7.2.4, prefereable 7.3.4) and
> > look up the autovacuum daemon to make sure this never happens again.  If
> > you installed from source, it's in the contrib/pg_autovacuum directory,
> > just cd in there as root, and 'make;make install' and it's installed.
> >
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 3: if posting/reading through Usenet, please send an appropriate
> >       subscribe-nomail command to majordomo@postgresql.org so that your
> >       message can get through to the mailing list cleanly
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
>