Q: migrating from serverA(gentoo) to serverB(centos) 8.2.4

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)

Browse pgsql-general by date

  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.