Re: how to load a .backup file - Mailing list pgsql-admin

From Guido Barosio
Subject Re: how to load a .backup file
Date
Msg-id f7f6b4c705071909493be62eae@mail.gmail.com
Whole thread Raw
In response to how to load a .backup file  (Alain Rodriguez Arias <alainrod@gmail.com>)
List pgsql-admin
if you used pg_dump, you should try to restore the backup
with pg_restore.
 
You should read about:
pg_dump
pg_restore
psql
 
All main postgresql utilities.
 
Regards,
---guido
 

 
On 7/19/05, Alain Rodriguez Arias <alainrod@gmail.com> wrote:
Hi:
I have database backup in .backup format. How can I import the
database into the server???
I' ve tried with psql databasename < infile but there are a lot of errors.
Thanks

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings



--
"Adopting the position that you are smarter than an automatic
optimization algorithm is generally a good way to achieve less
performance, not more" - Tom Lane.

pgsql-admin by date:

Previous
From: Alain Rodriguez Arias
Date:
Subject: how to load a .backup file
Next
From: Dirk Lutzebäck
Date:
Subject: Re: dump/restore needed when switching from 32bit to 64bit