Postgres Pro
Downloads
Home   >   mailing lists

copy a database - Mailing list pgsql-general

From David Suela Fernández
Subject copy a database
Date
Msg-id 1093437347.20799.7.camel@yen-lo-wang
Whole thread Raw
List pgsql-general
Tree view 
Hi!

Is it possible to copy/migrate one database from one postgres server to
other copying just the files in /var/lib/postgres/data/ ?

I can't use pg_dump because it give me an error. I think than the
instalation of postgres is corrupt because it give me a lot of error
like "ERROR:  relation "pg_catalog.pg_user" does not exist".

Thanks,

    Suela.

pgsql-general by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Question about SQL statement error
Next
From: Christopher Browne
Date:
Subject: Re: copy a database