Restore database in postgres 8.4 linux

--_79a6b693-9000-4c61-abf7-ebaaf11f53d2_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


I have a question=2C I
have postgres 8.2.5 on a windows server on another machine and I have
suse linux enterprise 10 postgres 8.4=2C you perform a backup with pgadmin
1.10 to a database and restore the database in the version of postgres 8.4=
gave me many errors that could not find some functions.



Atentamente

DBA 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=

--_79a6b693-9000-4c61-abf7-ebaaf11f53d2_
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'>
<span id=3D"result_box" class=3D"long_text"><span style=3D"background-color=
: rgb(230=2C 236=2C 249)=3B color: rgb(0=2C 0=2C 0)=3B" title=3D"">I have a=
question=2C I
have postgres 8.2.5 on a windows server on another machine and I have
suse linux enterprise 10 postgres 8.4=2C you perform a backup with pgadmin
1.10 to a database and restore the database in the version of postgres </s=
pan><span title=3D"">8.4 gave me many errors that could not find some funct=
ions.<br><br><br><br>Atentamente<br><br>DBA Alexander Angel<br>Venezuela<br=
></span></span>
<hr />Invite your mail contacts to join yo=
ur friends list with Windows Live Spaces. It's easy! <a href=3D'http://spac=
es.live.com/spacesapi.aspx?wx_action=3Dcreate&wx_url=3D/frie nds.aspx&mkt=3D=
en-us' target=3D'_new'>Try it!</a></body>
</html>=

--_79a6b693-9000-4c61-abf7-ebaaf11f53d2_--
ALEXANDER JOSE [ Do, 20 Mai 2010 00:25 ] [ ID #2041723 ]

Re: Restore database in postgres 8.4 linux

On Wed, May 19, 2010 at 16:25, ALEXANDER JOSE <aangelj [at] hotmail.com> wrote:
> I have a question, I have postgres 8.2.5 on a windows server on another
> machine and I have suse linux enterprise 10 postgres 8.4, you perform a
> backup with pgadmin 1.10 to a database and restore the database in the
> version of postgres 8.4 gave me many errors that could not find some
> functions.

Well, you wont get much here unless you paste some of the actual errors.

My guess its its related to full text searching (in which case you
will want to read
http://www.postgresql.org/docs/8.4/static/textsearch-migrati on.html).
Otherwise its probably some other contrib or 3rd party module you
forgot to install.

Also, I don't know much about pgadmin but make sure it is using 8.4s
version of pg_dump/pg_restore.

--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Alex Hunsaker [ Do, 20 Mai 2010 00:53 ] [ ID #2041724 ]
Datenbanken » gmane.comp.db.postgresql.admin » Restore database in postgres 8.4 linux

Vorheriges Thema: Clarification Needed: When does autovacuum daemon run?
Nächstes Thema: troubled by pg_dump and pg_restore