Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux)

Tom Lane wrote:

> So, how about showing us the first 20 or so lines of db.backup? You
> can't really expect us to guess much from this amount of info ...

Fair enough question.

select datdba into table tmp_pg_shadow from pg_database where
datname = 't
emplate1';
delete from pg_shadow where usesysid <> tmp_pg_shadow.datdba;
drop table tmp_pg_shadow;
copy pg_shadow from stdin;
nobody 60001 f t f t \N \N
seabee 10481 t t f t \N \N
yueyue 5535 t t f t \N \N
hagerty 27458 t t f t \N \N
armhold 29124 t t t t mysql \N
seredin 60002 f t f t \N
aynur 5869 t t f t \N \N
\.
\connect template1 postgres
create database armhold;
\connect armhold postgres
CREATE TABLE pgdump_oid (dummy int4);
COPY pgdump_oid WITH OIDS FROM stdin;
691497 0
\.
DROP TABLE pgdump_oid;
CREATE TABLE pfam (swiss_id varchar(16) NOT NULL, pfam_family
varchar(32), comme
nt varchar(80), sequence_data varchar(-5));
COPY pfam WITH OIDS FROM stdin;
536960 SWISS1 pfam_family1 comment data.... ABCDEFGHJ
536962 SWISS2 pfam_family1 comment data.... ABCDEFGHJ
536963 SWISS3 pfam_family1 comment data.... ABCDEFGHJ
536964 SWISS4 pfam_family1 comment data.... ABCDEFGHJ
536966 SWISS5 pfam_family2 comment data.... ABCDEFGHJ
\.
CREATE UNIQUE INDEX pfam_pkey on pfam using btree ( swiss_id
varchar_ops );
\connect template1 armhold
create database yueyue_test;
\connect yueyue_test armhold
CREATE TABLE pgdump_oid (dummy int4);
COPY pgdump_oid WITH OIDS FROM stdin;
691529 0
\.

Thanks.

--
George Armhold
Rutgers University
Bioinformatics Initiative