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
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 |