Re: Restore/dump from "/usr/local/pgsql/data" directory - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Restore/dump from "/usr/local/pgsql/data" directory
Date
Msg-id 201009232134.o8NLYTT03295@momjian.us
Whole thread Raw
In response to Restore/dump from "/usr/local/pgsql/data" directory  (kongsgar@stud.ntnu.no)
Responses Re: Restore/dump from "/usr/local/pgsql/data" directory
List pgsql-general
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. +

pgsql-general by date:

Previous
From: kongsgar@stud.ntnu.no
Date:
Subject: Restore/dump from "/usr/local/pgsql/data" directory
Next
From: Alan Hodgson
Date:
Subject: Re: Restore/dump from "/usr/local/pgsql/data" directory