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: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly