Thread
-
How to...?
Marc Fournier <scrappy@hub.org> — 1998-03-08T23:23:03Z
Bruce... Did I miss something here? I just looked through the migration file for 6.2.1->6.3, and it doesn't seem to say, but how do you dump the data from a v6.2.1 database and then reload it to a v6.3 one? Using v6.2.1's pg_dump/pg_dumpall, I did: pg_dumpall -o > db.dump That worked. Then, I installed v6.3, and using its psql, I did: psql -e < db.dump That failed miserably. First thing that failed was building the new pg_user...so I cut out that and did it manually using createuser... Then, using what was left, I did: psql -e < db.dump Again. Failed misearbly, with the following coming from the 'copy to <relname> from stdin;' section: 344984 johnb xgSldZdYEgIWo clio.trends.ca n \N \? -- help \a -- toggle field-alignment (currenty on) \C [<captn>] -- set html3 caption (currently '') \connect <dbname|-> <user> -- connect to new database (currently 'acctng') \copy table {from | to} <fname> \d [<table>] -- list tables and indices, columns in <table>, or * for all \da -- list aggregates \dd [<object>]- list comment for table, field, type, function, or operator. \df -- list functions \di -- list only indices \do -- list operators \ds -- list only sequences \dS -- list system tables and indexes \dt -- list only tables \dT -- list types \e [<fname>] -- edit the current query buffer or <fname> \E [<fname>] -- edit the current query buffer or <fname>, and execute \f [<sep>] -- change field separater (currently '|') \g [<fname>] [|<cmd>] -- send query to backend [and results in <fname> or pipe] \h [<cmd>] -- help on syntax of sql commands, * for all commands \H -- toggle html3 output (currently off) \i <fname> -- read and execute queries from filename \l -- list all databases \m -- toggle monitor-like table display (currently off) \o [<fname>] [|<cmd>] -- send all query results to stdout, <fname>, or pipe \p -- print the current query buffer \q -- quit \r -- reset(clear) the query buffer \s [<fname>] -- print history or save it in <fname> \t -- toggle table headings and row count (currently on) \T [<html>] -- set html3.0 <table ...> options (currently '') \x -- toggle expanded output (currently off) \z -- list current grant/revoke permissions \! [<cmd>] -- shell escape or command 344985 bonnies x/lgef4ULWJv2 clio.trends.ca n \N \? -- help \a -- toggle field-alignment (currenty on) \C [<captn>] -- set html3 caption (currently '') \connect <dbname|-> <user> -- connect to new database (currently 'acctng') \copy table {from | to} <fname> \d [<table>] -- list tables and indices, columns in <table>, or * for all \da -- list aggregates \dd [<object>]- list comment for table, field, type, function, or operator. So, is there, like, a trick to this? *raised eyebrow* Have I missed something important here? Thanks... -
Re: [HACKERS] How to...?
Bruce Momjian <maillist@candle.pha.pa.us> — 1998-03-09T00:28:50Z
> > > Bruce... > > Did I miss something here? I just looked through the migration > file for 6.2.1->6.3, and it doesn't seem to say, but how do you dump > the data from a v6.2.1 database and then reload it to a v6.3 one? > > Using v6.2.1's pg_dump/pg_dumpall, I did: > > pg_dumpall -o > db.dump Yes. > > That worked. > > Then, I installed v6.3, and using its psql, I did: > > psql -e < db.dump > > That failed miserably. OK. > > First thing that failed was building the new pg_user...so I cut > out that and did it manually using createuser... > > Then, using what was left, I did: > > psql -e < db.dump > > Again. Failed misearbly, with the following coming from the 'copy > to <relname> from stdin;' section: > > 344984 johnb xgSldZdYEgIWo clio.trends.ca n \N Check what is in the file around this line. It has existed the COPY for some reason, and the \N is triggering the \? output. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)