Re: how to load a .backup file

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(at)gmail(dot)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.