Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux