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