Thanks Tom... this reports that there were modifications to the tsearch2
functions. But this is how I worked around the restore problem, for
anyone that has similar issues:
1. pg_dump the 8.0.1 database in archive format.
2. Create an empty database on the 8.0.3 server
3. Run the contrib/tsearc
Howard Cole <[EMAIL PROTECTED]> writes:
> Interestingly, this is the latest tsearch2 function that ships with
> 8.0.3 - note the slightly different syntax to the one below. It looks
> like the compatibility issue is caused by this.
Read the 8.0.3 release notes ...
http://www.postgresql.org/docs/
Interestingly, this is the latest tsearch2 function that ships with
8.0.3 - note the slightly different syntax to the one below. It looks
like the compatibility issue is caused by this.
I shall try and modify the function in the 8.0.1 database, then try and
restore it to a 8.0.3 server and see w
Thanks for the response Doug. I am frightened to upgrade the linux
machine to 8.0.3 at the moment because the server is live and I want to
make sure that 8.0.3 will fix it. I have extracted the relevant parts of
the restore as follows:
1. The restore command
pg_restore.exe -i -h 10.202.6.1
Howard Cole <[EMAIL PROTECTED]> writes:
> To improve compatibility, I created a backup on the linux system
> (8.0.1) using plain format, data only with triggers disabled. However,
> when I try to restore the plain sql on the windows machine (8.0.3) it
> fails because the first insert command fails
There appears to be a problem with pgadminIII where the option to
disable triggers does not actually do anything! If I switch to the
pg_dump command line then the disable triggers works. Unfortunately I
still cannot restore a database backed up from a linux machine running
8.0.1 to an windows m
To improve compatibility, I created a backup on the linux system (8.0.1)
using plain format, data only with triggers disabled. However, when I
try to restore the plain sql on the windows machine (8.0.3) it fails
because the first insert command fails a foreign key constraint. Can I
disable fore
Hi,
Should it be possible to create a compressed backup of a version 8.0.1
database running on linux and restore that backup on version 8.0.3
running on XP? I ask this because it does not seem to work for me. Many
problems seem to arise to do with tsearch2 extensions to tables, even
though ts
