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
Dear All:
Is there a guide/how to for Postgre 9.0.2 installation/Configuration on a
windows servers (2003 and above)
Thanks
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.
--
Ammar Fallaha ammar.fall...@automata4.com 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:
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
IñigoMartinez Lasala imarti...@vectorsf.com 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
Zoran muljevski muljev...@gmail.com 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
--
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
Scott Whitney sc...@journyx.com 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
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?
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
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
PostgreSQL
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 dev...@gunduz.org
On Tue, 2010-12-21 at 22:39 -0800, Adib wrote:
ERROR: type tsvector is only a
13 matches
Mail list logo
