pg_dump and truncate

From: "Feng Chen" <fchen(at)covergence(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: pg_dump and truncate
Date: 2007-02-21 19:56:38
Message-ID: 0D1719326D64BD4E9F92A0C12023767801B2D5DF@eserv.covergence.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hello there,

I was trying to do a live db archive using the following steps:

1. Open a connection to the database;
2. With the connection, do the following:

BEGIN;

SET transaction ISOLATION level SERIALIZABLE;

3. Execute the following from the Linux shell:

pg_dump dbname | gzip -9 > dbname-archive.gz

4. With the same connection, do the following:

truncate table1, table2,...;

end;

Well, the tables are truncated all right, but the db dump file is
empty!!!

What went wrong with my logic? What should be the correct procedure?

Thank you!

Feng

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Aaron Zedonis 2007-02-21 20:57:14 BUG #3049: psql does not honor md5 in pg_hba.conf file
Previous Message Dmitry Koterov 2007-02-21 16:20:42 BUG #3048: pg_dump dumps intarray metadata incorrectly