Skip site navigation (1) Skip section navigation (2)

Re: how to load a .backup file

From: Guido Barosio <gbarosio(at)gmail(dot)com>
To: Alain Rodriguez Arias <alainrod(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to load a .backup file
Date: 2005-07-19 16:49:30
Message-ID: f7f6b4c705071909493be62eae@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(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.

In response to

pgsql-admin by date

Next:From: Ilja GolshteinDate: 2005-07-19 17:24:27
Subject: Re: Old question - failed to find conversion function from
Previous:From: Alain Rodriguez AriasDate: 2005-07-19 16:20:27
Subject: how to load a .backup file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group