Hi all,
I'm facing pbs trying to migrate my current database from Postgres 8.1 to 8.4.
The way I proceed is as 'root' :
su - postgres
createuser -A -R -d -E my_user
createdb --locale C --template template0 --encoding SQL_ASCII my_db
tsearch2_sql='/usr/share/pgsql/contrib/tsearch2.sql'
psql my
icts during 'restore' of my DB cf.
http://rockfloat.com/blog/?id=42
I'll keep U posted on know how things work out via help from above link
Regards,
Chanh
- Mail original -
De: "Tom Lane"
À: "Robert Treat"
Cc: "chanh tran" , pgsql-adm
Also Thx to Robert :) ...
- Mail original -
De: "chanh tran"
À: "Tom Lane"
Cc: pgsql-admin@postgresql.org, "Robert Treat"
Envoyé: Lundi 22 Avril 2013 13:27:29
Objet: Re: [ADMIN] Pb migrating database from Postgres 8.1 to 8.4
Hi Tom,
First of all, Big
yn_|token_|tsvector|tsquery|tsdebug|ts_debug|tsearch|pg_ts_|dex_|lexize|
parse|prsd_|_cur|snb_|spell_' >| /tmp/pg_restore.list
Step 2. pg_restore -L /tmp/pg_restore.list -d my_db_name my_db.tar
Regards,
Chanh
- Mail original -
De: "chanh tran"
À: &quo
