X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C5D4C5284F for ; Tue, 19 Jul 2005 13:49:40 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 73382-08 for ; Tue, 19 Jul 2005 16:49:35 +0000 (GMT) Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.193]) by svr1.postgresql.org (Postfix) with ESMTP id 51BDF529E3 for ; Tue, 19 Jul 2005 13:49:32 -0300 (ADT) Received: by nproxy.gmail.com with SMTP id i2so330270nfe for ; Tue, 19 Jul 2005 09:49:30 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=dcd5ry70KTd7RaEuN/K6jz3HgmpH7OwG4b3CV5UBhpMS6X2GwzSGRjgssI6Bu53c2z1ndqwPErFV5Ov7EhZFjvbbnxUicdpsTIM/iq7jDQHF449QF3z2JL/qxT4T8I7XfH1sSyxRSu0QEtlchP0dZ2wHS4WKhtboD3Wrg5/ZjEE= Received: by 10.48.4.10 with SMTP id 10mr231346nfd; Tue, 19 Jul 2005 09:49:30 -0700 (PDT) Received: by 10.48.144.16 with HTTP; Tue, 19 Jul 2005 09:49:30 -0700 (PDT) Message-ID: Date: Tue, 19 Jul 2005 17:49:30 +0100 From: Guido Barosio Reply-To: Guido Barosio To: Alain Rodriguez Arias Subject: Re: how to load a .backup file Cc: pgsql-admin@postgresql.org In-Reply-To: <526cb99d05071909207df9b20d@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_4934_3161676.1121791770598" References: <526cb99d05071909207df9b20d@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.316 tagged_above=0 required=5 tests=AWL, HTML_40_50, HTML_MESSAGE, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200507/131 X-Sequence-Number: 18187 ------=_Part_4934_3161676.1121791770598 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline if you used pg_dump, you should try to restore the backup=20 with pg_restore. You should read about: pg_dump pg_restore psql All main postgresql utilities. Regards, ---guido =20 On 7/19/05, Alain Rodriguez Arias wrote:=20 >=20 > 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 >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 5: don't forget to increase your free space map settings >=20 --=20 "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. ------=_Part_4934_3161676.1121791770598 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
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 <alainro= d@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 sett= ings



--
"Adopting the position t= hat you are smarter than an automatic
optimization algorithm is generally a good way to achieve less
perfo= rmance, not more" - Tom Lane.=20 ------=_Part_4934_3161676.1121791770598--