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

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: kongsgar(at)stud(dot)ntnu(dot)no
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Restore/dump from "/usr/local/pgsql/data" directory
Date: 2010-09-23 21:34:29
Message-ID: 201009232134.o8NLYTT03295@momjian.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

kongsgar(at)stud(dot)ntnu(dot)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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ It's impossible for everything to be true. +

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alan Hodgson 2010-09-23 21:37:29 Re: Restore/dump from "/usr/local/pgsql/data" directory
Previous Message kongsgar 2010-09-23 20:49:50 Restore/dump from "/usr/local/pgsql/data" directory