To specify: I have a copy of the data in "/usr/local/pgsql/data" from
my old, but I don't have access to the old system anymore so I cannot
simply do a "pg_dumpall" from there.
I believe I could copy the content of "/usr/local/pgsql/data" into
"/usr/local/pgsql/data" on my new system. But is there an alternative?
-Håvard Wahl Kongsgård
kongsgar@xxxxxxxxxxxx wrote:
Hi,
I have a copy of "/usr/local/pgsql/data" from old server. Is it
possible to do a dump of the sql databases in this directory, so that
I can easily migrate them to my current system?
Yes, run pg_dumpall, save it, and load it into the new system. You
really haven't given us much information on what problem you are having.
--
Bruce Momjian <bruce@xxxxxxxxxx> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
