HOLD THE PRESSES!! ... pg_dump from v7.0.3 can't import to v7.1?

From: The Hermit Hacker <scrappy(at)hub(dot)org>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: HOLD THE PRESSES!! ... pg_dump from v7.0.3 can't import to v7.1?
Date: 2001-04-10 18:22:14
Message-ID: Pine.BSF.4.33.0104101520140.72136-100000@mobile.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


v7.0.3 database:

trends_acctng=# \d
List of relations
Name | Type | Owner
-------------+-------+-------
accounts | table | pgsql
admin | table | pgsql
calls | table | pgsql
comments | table | pgsql
cookies | table | pgsql
credit_card | table | pgsql
credits | table | pgsql
logs | table | pgsql
personal | table | pgsql
radhist | table | pgsql
radlog | table | pgsql
remote_host | table | pgsql
static_ip | table | pgsql
users | table | pgsql
(14 rows)

v7.1 database:

trends_acctng=# \d
List of relations
Name | Type | Owner
--------------------------+----------+---------
buy | table | jeff
buy_bid_seq | sequence | jeff
clients_c_id_seq | sequence | jeff
cppvad_clients | table | jeff
cppvad_clients_cc_id_seq | sequence | jeff
cppvad_info | table | jeff
cppvad_info_cid_seq | sequence | jeff
download | table | jeff
download_dlid_seq | sequence | jeff
exchange | table | jeff
exchange_exid_seq | sequence | jeff
gallery | table | scrappy
listing | table | area902
listing_lid_seq | sequence | area902
ndict10 | table | pgsql
ndict11 | table | pgsql
ndict12 | table | pgsql
ndict16 | table | pgsql
ndict2 | table | pgsql
ndict3 | table | pgsql
ndict32 | table | pgsql
ndict4 | table | pgsql
ndict5 | table | pgsql
ndict6 | table | pgsql
ndict7 | table | pgsql
ndict8 | table | pgsql
ndict9 | table | pgsql
projects | table | scrappy
thepress | table | jeff
thepress_id_seq | sequence | jeff
ticket | table | pgsql
ticket_comments | table | pgsql
ticket_ticket_id_seq | sequence | pgsql
ticket_times | table | pgsql
(34 rows)

all I did was use pg_dumpall from v7.0.3 to dump to a text file, and
"psql template1 < dumpfile" to load it back in again ...

obviously this doesn't work like it has in the past?

Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joel Burton 2001-04-10 18:33:37 Re: HOLD THE PRESSES!! ... pg_dump from v7.0.3 can't import to v7.1?
Previous Message Thomas Lockhart 2001-04-10 17:38:17 Re: JDBC and Perl compiling problems w/ postgresql-7.1rc4