PostgreSQL Administration - how to load a .backup file

Author

how to load a .backup file

Alain Rodriguez Arias

2005-07-19, 11:24 am

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

Guido Barosio

2005-07-19, 11:24 am

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.

Sponsored Links