Guillaume Lelarge a écrit :
Olivier Boissard a écrit :
I'd like to compare postgresql tables content between 2 servers after a
replication.
Do you know which tools can do this ?
If you don't mind using a non-free product, there are DB Comparer for
PostgreSQL (http://sqlmanager.net/fr/
I read the release notes for 8.2 which mentioned that transaction id
wraparounds are now on a per-table basis versus database-wide. Currently
for 8.1 I issue a vacuumdb -a command which takes a coule of days due to
the size of the databse.
What is the equivalent command in 8.2 (assuming autovac
On Tue, 2007-01-02 at 06:04, [EMAIL PROTECTED] wrote:
> Hi List,
>
> I'm using postgresql 7.4 on FC4 linux.
> i have one table named "purchase". it is working fine since 10 months but
> suddenly from 3-4 days it creates problem.
> when i'm fire a simple "select * from purchase" query on psql promp
Hi List,
I'm using postgresql 7.4 on FC4 linux.
i have one table named "purchase". it is working fine since 10 months but
suddenly from 3-4 days it creates problem.
when i'm fire a simple "select * from purchase" query on psql prompt,it
gives following error:
Invalid page header in block 211 of
Benjamin Arai wrote:
> Just to make things more clear I ran EXPLAIN ANALYZE on the slow query.
> I got
> -> Index Scan using mutualfd_weekday_qbid_pkey_idx on
> mutualfd_weekday_qbid (cost=0.00..6.01 rows=1 width=19) (actual
> time=34.579..8510.801 rows=253 loops=1)
> Index Cond: ((pk
