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: | Raw Message | Whole Thread | 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. |