Re: Restore/dump from "/usr/local/pgsql/data" directory

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@stud.ntnu.no 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@momjian.us>        http://momjian.us
>   EnterpriseDB                             http://enterprisedb.com
>
>   + It's impossible for everything to be true. +
>
>