Thread: how to load a .backup file
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
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.