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
The DB size is around 11-12 GB. Yes I am planning to take a downtime for
upto 1 hour if required. I would like to understand the rollback steps if
things go murky.
Thanks,
Rajiv
From: Vasilis Ventirozos [mailto:v.ventiro...@gmail.com]
Sent: Thursday, April 18, 2013 4:49 PM
To: rajiv.kas...
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
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
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
Hi guys.
I created a database with default encoding (SQL_ASCII) and default collate
(C).
I created a table test like this:
create table test (a varchar (10));
Then i executed "insert into teste (a) values ('áéç&ã','Æ','ß');
After that:
select * from test;
a
-
áéç&ã
Æ
ß
Why did it s
