How to...? - Mailing list pgsql-hackers
| From | The Hermit Hacker |
|---|---|
| Subject | How to...? |
| Date | |
| Msg-id | Pine.NEB.3.95.980308181838.29397G-100000@hub.org Whole thread Raw |
| Responses |
Re: [HACKERS] How to...?
|
| List | pgsql-hackers |
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...
pgsql-hackers by date: