t;Tom Lane"
Cc: pgsql-admin@postgresql.org, "Robert Treat"
Envoyé: Lundi 22 Avril 2013 13:28:22
Objet: Re: [ADMIN] Pb migrating database from Postgres 8.1 to 8.4
Also Thx to Robert :) ...
- Mail original -
De: "chanh tran"
À: "Tom Lane"
Cc: pgsql-adm
Also Thx to Robert :) ...
- Mail original -
De: "chanh tran"
À: "Tom Lane"
Cc: pgsql-admin@postgresql.org, "Robert Treat"
Envoyé: Lundi 22 Avril 2013 13:27:29
Objet: Re: [ADMIN] Pb migrating database from Postgres 8.1 to 8.4
Hi Tom,
First of all, Big
in@postgresql.org
Envoyé: Vendredi 19 Avril 2013 18:09:40
Objet: Re: [ADMIN] Pb migrating database from Postgres 8.1 to 8.4
Robert Treat writes:
> On Fri, Apr 19, 2013 at 10:19 AM, Tom Lane wrote:
>> chanh.t...@free.fr writes:
>>> I'm facing pbs trying to migrate my curre
Robert Treat writes:
> On Fri, Apr 19, 2013 at 10:19 AM, Tom Lane wrote:
>> chanh.t...@free.fr writes:
>>> I'm facing pbs trying to migrate my current database from Postgres 8.1 to
>>> 8.4.
>>> pg_restore: [archiver (db)] could not execute query: ERROR: could not find
>>> function "gtsvector_in
On Fri, Apr 19, 2013 at 10:19 AM, Tom Lane wrote:
> chanh.t...@free.fr writes:
>> I'm facing pbs trying to migrate my current database from Postgres 8.1 to
>> 8.4.
>
>> pg_restore: [archiver (db)] could not execute query: ERROR: could not find
>> function "gtsvector_in" in file "/usr/lib64/pgsql
chanh.t...@free.fr writes:
> I'm facing pbs trying to migrate my current database from Postgres 8.1 to 8.4.
> pg_restore: [archiver (db)] could not execute query: ERROR: could not find
> function "gtsvector_in" in file "/usr/lib64/pgsql/tsearch2.so"
Looks like you're missing the shared library t
Hi all,
I'm facing pbs trying to migrate my current database from Postgres 8.1 to 8.4.
The way I proceed is as 'root' :
su - postgres
createuser -A -R -d -E my_user
createdb --locale C --template template0 --encoding SQL_ASCII my_db
tsearch2_sql='/usr/share/pgsql/contrib/tsearch2.sql'
psql my
