Is there some way to avoid restoring tsearch2 since full text searching is
now part of postgres 9.0, the apps that use the database don't do any full
text searching.
2010/12/21 Devrim GÜNDÜZ
> On Tue, 2010-12-21 at 22:39 -0800, Adib wrote:
> > ERROR: type "tsvector" is only a shell
> > ERROR:
On Tue, 2010-12-21 at 22:39 -0800, Adib wrote:
> ERROR: type "tsvector" is only a shell
> ERROR: operator class "gin_tsvector_ops" does not exist for access
> method
> "gin
*IIRC*, you need to load contrib/tsearch2.sql to database *before*
restoring your backup.
Regards,
--
Devrim GÜNDÜZ
Post
Hi,
I have a very old postgres 8.2 server which I want to upgrade to 9.0.2
server, the server are on different boxes and the 9.0.2 is fully running. I
think that my 8.2 contains tsreach2 which none of my applications use. The
postgres 8.2 is running on Windows 2003 server and 9.0.2 is running on
W
In postgres im beginer .How write procedure returned different types of value?i
need function to select different data types from table columns and returned.i
try overload name of function but its bad idea.it is possible? anybody?
Scott Whitney wrote:
> Each Saturday, I run: vacuumdb -a -v. I have autovac on all the
> time.
>
> However, my pg_clog directory lists clog files going back to
> July.
>
> This is pg 8.4.4 on Linux (CentOS 5.5).
>
> I know this isn't a whole lot of information at this time. What
> more would
Hello. I posted this once before, but I'm encountering it again.
Each Saturday, I run: vacuumdb -a -v. I have autovac on all the time.
However, my pg_clog directory lists clog files going back to July.
This is pg 8.4.4 on Linux (CentOS 5.5).
I know this isn't a whole lot of information at t
"Zoran muljevski" wrote:
> Database PostgreSQL 8.1.22 takes 2 GB. I deleted a table of 300
> MB. But the database still takes up 2 GB. I deleted the indexes of
> 200 MB but the base still has 2 GB.
> What should I do?
What is your OS? How are you measuring this?
-Kevin
--
Sent via pgsql-a
IñigoMartinez Lasala wrote:
> Data duplication happened on source server (that is, on production
> environment). This data duplication affected only on some tables,
> with some duplicated PKs and altered sequences (sequences value
> didn't match "select max()" and we had to fix it manually).
W
Database PostgreSQL 8.1.22 takes 2 GB. I deleted a table of 300 MB. But the
database still takes up 2 GB. I deleted the indexes of 200 MB but the base
still has 2 GB.
What should I do?
Thank you,
Muljevski Zoran
"Ammar Fallaha" wrote:
> Is there a guide/how to for Postgre 9.0.2 installation/
> Configuration on a windows servers (2003 and above)
In addition to the fine manual, there is a Wiki with some pages
which may help. In particular:
http://wiki.postgresql.org/wiki/Running_%26_Installing_Postgr
> Is there a guide/how to for Postgre 9.0.2 installation/Configuration on a
> windows servers (2003 and above)
Have you tried searching? A well known search engine finds about
3,840,000 results for "postgres install windows". Or try
http://www.postgresql.org/docs/9.0/static/index.html
--
Ian.
Dear All:
Is there a guide/how to for Postgre 9.0.2 installation/Configuration on a
windows servers (2003 and above)
Thanks
Hi everyone.
I have been installed postgresql 9.0.2 on a windows 2008 x64 server.
The postgres is running, without any application accessing the server.
In the log appear : WARNING: pgstat wait timeout
This error appear constantly and some times when I do a query, very simple
query l
13 matches
Mail list logo
