7.2b3 pg_dump, general 7.2b3 comments - Mailing list pgsql-hackers

From Joe Conway
Subject 7.2b3 pg_dump, general 7.2b3 comments
Date
Msg-id 3C05BE27.5020700@home.com
Whole thread Raw
Responses Re: 7.2b3 pg_dump, general 7.2b3 comments
Re: 7.2b3 pg_dump, general 7.2b3 comments
List pgsql-hackers
Is pg_dump supposed to work against prior version databases? I was
moving data from an old server (running 7.2devel from several months
ago) to a new server (running 7.2b3), using pg_dump on the *new* server,
and got the following message:

# pg_dump -h 172.16.1.84 -U postgres -t el_names -i lt_lcat > el_names.dmp
Password: <types in password>
pg_dump: query to obtain list of tables failed: ERROR:  Attribute
'relhasoids' not found

Not that I need to do this, but it was convenient and I thought it was
supposed to work. Is this a problem, or am I trying to do something
unsupported?

On a side note, I was *very* happy when I was able to load a table with
~40 million rows about 30 minutes (compared to about a day+ on the old
hardware, Red Hat 6.2, and early 7.2devel Postgres). And that was 
without changing the default postgresql.conf, because I forgot to do it 
before I started the copy ;-). Memory usage according to 'top' never 
exceeded about 5 MB.

Also worth noting, I installed successfully from an RPM which I built
from the source RPM.

Thank you to *everyone* involved in getting PostgreSQL to where it is 
today! It is truly an awesome product.

-- Joe




pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: Second call for platform testing
Next
From: Tom Lane
Date:
Subject: Re: 7.2b3 pg_dump, general 7.2b3 comments