Обсуждение: how to load a .backup file

Поиск
Список
Период
Сортировка

how to load a .backup file

От
Alain Rodriguez Arias
Дата:
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

Re: how to load a .backup file

От
Guido Barosio
Дата:
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.