| From: | Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Q: migrating from serverA(gentoo) to serverB(centos) 8.2.4 |
| Date: | 2007-10-05 08:46:46 |
| Message-ID: | 1191574006.22907.17.camel@neuromancer.home.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
What's the best method for migrating data from my laptop to the final
server DB?
The data currently in my laptop is using SQL_ASCII encoding and the
deployment target is defaulted to using UTF-8. (should not be a concern
as the encoding should be handled via the dump right?)
However a concern would be that in my laptop, due to space consideration
etc, I have 3 tablespaces, dbspace2,dpspace3 and default. In the dump
(I did a
pg_dump -Upostgres hmxmms | ssh user(at)server "cat > /tmp/pgdatadump" )
I've tried to use pg_dump dbname | psql -h otherserver dbname but I keep
getting a connection refused w/ a statement saying that the server DB
may be allowing connections. (I can connect dine using psql -h
otherserver dbname fine w/o the pipe)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Schwarzer | 2007-10-05 09:11:14 | Re: Find min year and min value |
| Previous Message | Benjamin Arai | 2007-10-05 07:50:17 | Slow TSearch2 performance for table with 1 million documents. |