From: | Andrew Gould <andrewgould(at)yahoo(dot)com> |
---|---|
To: | Postgres Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | <Long> pg_xlog directory filled file system |
Date: | 2001-08-10 13:11:47 |
Message-ID: | 20010810131147.90840.qmail@web13407.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
It's Fiday; and certainly a better day than yesterday.
I'm posting this as:
1. A request for tips regarding log management; and
2. A tip to other newbies who are restoring multiple,
large databases.
The tip: Always do 'vacuumdb -a' after restoring a
database.
The question: What are the significant log issues
that dba's should be watching?
Background (long):
I have 3 databases that, in total, are 16 Gigabytes in
size. I had converted them from MySQL; and it was
time to move them to a different subnet. I'm running
PostgreSQL 7.1.2_2 on FreeBSD 4.3 stable (4.4
prerelease). I dumped each database separately,
piping the output through gzip into a *.gz file. I
restored the databases on the new computer by piping
the decompressed data into psql. (I couldn't seem to
get it to work with pg_restore.) The first two
restores went well. The third restore came to an
abrupt end with a message that the file system was
full. Postmaster had died; and I could not restart
the PostgreSQL server. 'du -h' revealed that the
database directories were of the expected sizes; but
also that the pg_xlog direcory was over 10 Gb in size!
Since I could not get the database server to restart
(even after rebooting), I uninstalled Postgres and
dependent applications, deleted the directories, and
started all over. I scripted the restores to run
sequentially overnight; but I put a 'vacuumdb -a'
after each restore.
This morning: The databases are restored. pg_xlog is
16Mb is size. The row counts, via phppgadmin, look
good.
Happy Friday,
Andrew
__________________________________________________
Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger
http://phonecard.yahoo.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Ketil Malde | 2001-08-10 13:38:55 | Re: Bug#108286: case sensitivity in column names |
Previous Message | Richard Huxton | 2001-08-10 11:48:22 | Re: installing Procedural Language PL/PGSQL |