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=20
have postgres 8.2.5 on a windows server on another machine and I have=20
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
=20
____________________________________________________________ _____
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






: rgb(230=2C 236=2C 249)=3B color: rgb(0=2C 0=2C 0)=3B" title=3D"">I have a=
question=2C I=20
have postgres 8.2.5 on a windows server on another machine and I have=20
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 pan>8.4 gave me many errors that could not find some funct=
ions.



Atentamente

DBA Alexander Angel
Venezuela >

Re: Restore database in postgres 8.4 linux

On Wed, May 19, 2010 at 16:25, ALEXANDER JOSE 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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin