Restore DataBase

--_4f9cd470-14cd-4f7f-b68a-761cf44eb646_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable




psql coon I'm trying to restore a database
that has 60 GB in size=2C where there is a table with 38 million records=
=2C
has raised 18 million records when the restore process fails on a
syntax error=2C the backup was made with a file. sql as the best way I can =
do
to restore??


Alexander Angel
Venezuela






____________________________________________________________ _____
Invite your mail contacts to join your friends list with Windows Live Space=
s. It's easy!
http://spaces.live.com/spacesapi.aspx?wx_action=3Dcreate&wx_ url=3D/friends.=
aspx&mkt=3Den-us=

--_4f9cd470-14cd-4f7f-b68a-761cf44eb646_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style><!--
..hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Verdana
}
--></style>
</head>
<body class=3D'hmmessage'>
<div id=3D"readMsgBodyContainer" class=3D"ReadMsgBody BorderTop" onclick=3D=
"return Control.invoke('ReadingPane'=2C '_onBodyClick'=2C event)=3B">
<div class=3D"ExternalClass" id=3D"MsgContainer">
<span id=3D"ecxresult_box" class=3D"ecxlong_text"><span style=3D"background=
-color: rgb(255=2C 255=2C 255)=3B" title=3D"">psql coon I'm trying to resto=
re a database
that has 60 GB in size=2C where there is a table with 38 million records=
=2C
has raised 18 million records when the restore process fails on a
syntax error=2C the backup was made </span><span style=3D"background-color:=
rgb(255=2C 255=2C 255)=3B" title=3D"">with a file. sql as the best way I c=
an do
to restore??<br><br><br>Alexander Angel<br>Venezuela<br></span></span>


</div>

</div>
<hr />Invite your mail contacts to join your friend=
s list with Windows Live Spaces. It's easy! <a href=3D'http://spaces.live.c=
om/spacesapi.aspx?wx_action=3Dcreate&wx_url=3D/friends.aspx& mkt=3Den-us' ta=
rget=3D'_new'>Try it!</a></body>
</html>=

--_4f9cd470-14cd-4f7f-b68a-761cf44eb646_--
ALEXANDER JOSE [ Mi, 02 Juni 2010 05:26 ] [ ID #2042491 ]

Re: Restore DataBase

--0016e6d9a3ba870a8a048805e74f
Content-Type: text/plain; charset=UTF-8

2010/6/2 ALEXANDER JOSE <aangelj [at] hotmail.com>

> psql coon I'm trying to restore a database that has 60 GB in size, where
> there is a table with 38 million records, has raised 18 million records when
> the restore process fails on a syntax error, the backup was made with a
> file. sql as the best way I can do to restore??
>
>
> Alexander Angel
> Venezuela
>


How did you make the backup?


regards
Szymon Guz

--0016e6d9a3ba870a8a048805e74f
Content-Type: text/html; charset=UTF-8

<br><br><div class="gmail_quote">2010/6/2 ALEXANDER JOSE <span dir="ltr"><aangelj [at] hotmail.com></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">




<div>
<div>
<div>
<span><span style="background-color:rgb(255, 255, 255)" title="">psql coon I'm trying to restore a database
that has 60 GB in size, where there is a table with 38 million records,
has raised 18 million records when the restore process fails on a
syntax error, the backup was made </span><span style="background-color:rgb(255, 255, 255)" title="">with a file. sql as the best way I can do
to restore??<br><br><br>Alexander Angel<br>Venezuela<br></span></span>


</div>

</div> </div></blockquote></div><br><div><br></div><div>How did you make the backup?</div><div><br></div><div><br></div><div>regards</div><div>Szymon Guz</div>

--0016e6d9a3ba870a8a048805e74f--
Szymon Guz [ Mi, 02 Juni 2010 08:07 ] [ ID #2042493 ]

Re: Restore DataBase

hi,

sounds like a plain text backup. your problem, I guess, will be some
constraint issue. I suggest commenting out the constraints in the backup
file before running the restore.

regards

andreas


ALEXANDER JOSE wrote:
> psql coon I'm trying to restore a database that has 60 GB in size,
> where there is a table with 38 million records, has raised 18 million
> records when the restore process fails on a syntax error, the backup
> was made with a file. sql as the best way I can do to restore??
>
>
> Alexander Angel
> Venezuela
>
> ------------------------------------------------------------ ------------
> Invite your mail contacts to join your friends list with Windows Live
> Spaces. It's easy! Try it!
> <http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us>


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Andreas Schmitz [ Mi, 02 Juni 2010 09:17 ] [ ID #2042495 ]

Re: Restore DataBase

--001636c931e466bb8e048819d6c7
Content-Type: text/plain; charset=ISO-8859-1

On Tue, Jun 1, 2010 at 9:26 PM, ALEXANDER JOSE <aangelj [at] hotmail.com> wrote:

> psql coon I'm trying to restore a database that has 60 GB in size, where
> there is a table with 38 million records, has raised 18 million records when
> the restore process fails on a syntax error, the backup was made with a
> file. sql as the best way I can do to restore??
>
>
It will be easier for people to help if you provide more info such as
postgres version, OS, how the backup was made, exact error message, etc.
But, if you're getting a syntax error, then my best guess would be that
either that you have a corrupt/incomplete backup, or that you're trying to
restore to a different version of postgres than you used to make the backup,
and the backup has syntax which would be valid for the version that made it,
but not for the version you're trying to restore to.

-Eric

--001636c931e466bb8e048819d6c7
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div class=3D"gmail_quote">On Tue, Jun 1, 2010 at 9:26 PM, ALEXANDER JOSE <=
span dir=3D"ltr"><<a href=3D"mailto:aangelj [at] hotmail.com">aangelj [at] hotmail=
..com</a>></span> wrote:<br><blockquote class=3D"gmail_quote" style=3D"bo=
rder-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding=
-left: 1ex;">




<div>
<div>
<div>
<span><span style=3D"background-color: rgb(255, 255, 255);" title=3D"">psql=
coon I'm trying to restore a database
that has 60 GB in size, where there is a table with 38 million records,
has raised 18 million records when the restore process fails on a
syntax error, the backup was made </span><span style=3D"background-color: r=
gb(255, 255, 255);" title=3D"">with a file. sql as the best way I can do
to restore??<br><br></span></span></div></div></div></blockquote><br></div>=
It will be easier for people to help if you provide more info such as postg=
res version, OS, how the backup was made, exact error message, etc. But, if=
you're getting a syntax error, then my best guess would be that either=
that you have a corrupt/incomplete backup, or that you're trying to re=
store to a different version of postgres than you used to make the backup, =
and the backup has syntax which would be valid for the version that made it=
, but not for the version you're trying to restore to.<br>
<br>-Eric<br>

--001636c931e466bb8e048819d6c7--
Eric McKeeth [ Do, 03 Juni 2010 07:54 ] [ ID #2042553 ]
Datenbanken » gmane.comp.db.postgresql.admin » Restore DataBase

Vorheriges Thema: PG_dump a large database fails
Nächstes Thema: pitrtools package wrong dependency (binary packages)